Recent content by gunnie

Thanks heaps! Works great. As you can see I am no programmer. Put what I had together from snippets of code I searched for. Thanks again, Craig

I have the below form with javascript to calculate a hidden password based on the current year and day of the year. ie. 2006026 minus a 6 digit number = the hidden password All I want to do is enter the 6 digit number and then calculate. Currently I have to enter the current date and the 6...

Thanks PH... that did the trick. Here is the final code. Private Sub Repeat_AfterUpdate() Dim sClient As String Dim sDevice_ID As String Dim sCon_In As String Dim sStatus As String Dim sReceived As String Dim sSN As String sClient = NewClient sDevice_ID = NewDevice sCon_In = ConIN sStatus =...

Well at the moment it just copies and pastes one record. I want to have another unbound field with the number of times I want the record to be pasted. The field for entering the qty is not my problem but rather the code to loop it for n times. So basically some sort of loop that will continue...

At the moment I have a command button.. Private Sub Command122_Click() Dim sClient As String Dim sDevice_ID As String Dim sCon_In As String Dim sStatus As String Dim sReceived As String Dim sSN As String sClient = Client sDevice_ID = Device_ID sCon_In = Con_In sStatus = Status sReceived =...

Thanks for the response... It's not that I dont like your append solution,but how would I use this to paste a number of rows based on the value in an uound field for quantity of one product with the same serial number. Thanks again.

I need to exactly the same things, the reply you have received does not seem to be the answer. Please advise if you have worked this out as I am pulling my hair out trying to find the same solution. Thanks craig

I am using access to add new devices received. I enter the description and serial number in unbound fields which adds the new serial number along with the details from the unbound fields to a new record. I also add devices that have no serial number as "Non Serialised". What I want to accomplish...

Could some kind person explain the use of Dim in modules please.