I chose the fields I want to insert from the form, now I have another question. I have 5 other combo boxes that select the day of the week of payroll actions, ie. Pay Period end, Check Date, etc. is there a way I can have the form automatically insert the day of the week from a date that is...
For clarity sake I want to make sure we are thinking about the same thing. By an insert query do you mean an append query? They're probably the same thing I just want to be sure before I procede. :-)
The server is now operational. The code that is in the Add Record button is as follows:
Private Sub cmdAddRecord_Click()
On Error GoTo Err_cmdAddRecord_Click
DoCmd.GoToRecord , , acNewRec
Exit_cmdAddRecord_Click:
Exit Sub
Err_cmdAddRecord_Click:
MsgBox Err.Description
Resume...
The Add Record button does have some onClick event code that my supervisor added when he designed the form. I've just been given the task of finishing the form's code to get the form functional. I'll be happy to share the code once the server is restored if that will help. Which may or may not...
Almost. The 2 (dbase3) fields I want transferred to 2 corresponding fields in the .mdb table (each in its own field on one row). Then, There are the memo fields that I want the form to input data to the corresponding memo field that is drawn as a text box on the form. Lastly I want all this...
The memo fields I discussed is only memo type fields for the .mdb database table. The dbase 3 fields I need to get client data from are simple text I think. Our server crashed today and the drives are being rebuilt as we speak. I'll get more information about those particular fields when I can...
Sorry if I was confusing with the details. My problem is that the text boxes in the Access 2000 form are not linked to the memo fields on the table I have to store values. I can't find a way to link the fields. Most likely I'll need some code to direct it to the table manually since it has the...
I've been searching for solutions for a week now and I can't find any examples of this. I am just learning Access 2000 that my company works with as well as trying to learn more about VBA for Access 2000. I need to get a form working that has a combobox that takes clientnumber and clientname...
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.