Recent content by Gegsynz

Still the same I'm afraid - I will give it away for tonight as its getting towards midnight here and I have a 5am start in the morning. I will go over everything tomorrow night to make sure I have correct. Thanks again for your help and most probably be back here again soon kind regards Gerry

I am entering numbers in the SystemNumber and AccessNumber fields, populating all the other fields but have CopyNumber field default value as 1. When I click my Add copy button it creates a new record but is not copying over the SystemNumber and AccessNumber fields nor increasing the CopyNumber...

Run-time error '3601' : Too few parameters, Expected 2 Set rs = db.OpenRecordset(strSQL) highlighted in VB

Chergh thanks again for the prompt response and appreciate your help. I had done your suggested changes but posted wrong code. Still get same result with this code: on line: Set rs = db.OpenRecordset(strSQL) Dim db As Database Dim rs As Recordset Dim strSQL As String Dim x As Integer Set db...

Cut and pasted the code but keep getting an error on line: Set rs = db.OpenRecordset(strSQL) Code now reads: Private Sub Command4_Click() Dim sSystemNumber As String Dim sAccessNumber As String Dim sFirstName As String Dim sLastName As String Dim sMailingLocation As String Dim sPhoneNumber As...

I'm thrilled with the responses I am getting to my problem but some of the code is getting getting the better of me. Chergh has set me off in the right direction and maybe now may be a good time to explain a bit about my document db. Basically to keep track of technical manuals. Fields include...

Chergh, thanks for your help and patience. I have added suggested code into my trial form and it works very well. However it finds the highest copy number in the copy number field of the table where I actually want the highest copy number for the group of records that relate to a particular...

Made more progress in the last couple of hours than for the last couple of weeks! However I have struck a problem.. Everything is OK when the user is at the last copy number of the record and clicks my add copy button to add another copy but if they happen to go back a couple of records say from...

Doing a quick form here at home and your last suggestion works perfectly. Can't wait to get to work to try it out on the real thing. Can't thank you enough. Kind regards Gerry

Thanks for the very prompt reply, please forgive my ignorance but would this suggested code tag on the end of the code I have to duplicate the record ? Gerry

Greetings from New Zealand I have just followed GHudson method of copying a record by adding his code to the Onclick event of a command button on a data entry form and it works beautifully. As a newcomer to access this feature has had me stumped for a couple of weeks now. Thanks a lot GHUDSON...