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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.