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 Mike Lewis 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. Chaddaman

    Receiving run-time error '3144' syntax error in update statement

    I have created a database using macros and I am recieving the above run-time error. The debugger is displaying the following code as the culpret: Private Sub Form_Current() DoCmd.SetWarnings (False) DoCmd.RunSQL "UPDATE tbl_Current_Record SET tbl_Current_Record.Current_Rec_CWS_Num...
  2. Chaddaman

    Windows explorer, autoCad issue

    I'm using autodesk autocad 14 on a dual monitor system, When I open a drawing in windows explorer it opens and everything is good. But when I minimize the first drawing and try to open a second drawing in windows explorer the first drawing maximizes and the second drawing does not open at all. I...
  3. Chaddaman

    Current record on form is not being updated.

    Paul, Thanks, big help...one more thing I am fairly new to coding in access so could you tell me where I could find avalible API information that describes what methods are avaliable and what they do...ie) DoCmd.RunCommand accmdSaveRecord thanks
  4. Chaddaman

    Current record on form is not being updated.

    I am running the macro from the "After Update" property of the fields. Where do I find the call to the macro. When I view the code for the form all I see is the code for the buttons. How do I view the code for the other properties on the form or fields so I can insert the above line of...
  5. Chaddaman

    Current record on form is not being updated.

    I currently have a form that has a number of fields that when changed will run a macro that will change the data in the tables for other fields for that particular record. However, in order for the changes to be visible on the form The macro must first go to the next record, continue to run...

Part and Inventory Search

Back
Top