Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...
  2. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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. :-)
  3. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...
  4. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...
  5. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...
  6. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...
  7. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...
  8. geekboi135

    Access 2000 form that needs data from dbase 3 and writes to table

    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...

Part and Inventory Search

Back
Top