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!

Register Log in
  • Congratulations Chris Miller 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. presence76

    Updating table from textbox input

    A push button on the form executes a query that executes the VBA code. Yes, I am viewing the form when I do this. I thought maybe because the textbox was in the Header section of the form - but I moved the textbox to Detail and nothing. When I creat a new textbox in the "bad" form, it does...
  2. presence76

    Updating table from textbox input

    Took care of it. I created another form. Thanks again for all your help.
  3. presence76

    Updating table from textbox input

    Woops. Did not work first time. The message told me the table was updated, but that was just because when the query is over. It is still getting hung up about the textbox being null. Is there any setting in the properties of the textbox that could be preventing data from being passed...
  4. presence76

    Updating table from textbox input

    You did a great job. Worked first time. Thanks for all the help.
  5. presence76

    Updating table from textbox input

    I have a form that has a textbox in it. I am using the information to update a table in ACCESS. I am getting "invalid use of null" on this line: newmgmtcode = Forms![form1]![textmgmtcode] I have also tried newmgmtcode = Forms![form1]![textmgmtcode].Value Either way, I get invalid use of...
  6. presence76

    checking for existence of table in VBA using SQL

    Thanks for the quick response. As a general rule, I don't use error bypassing so On Error Resume Next was code I had never used - consequently, my erroneous placement of it. I tested it and it worked like a charm. Thanks a bunch.
  7. presence76

    checking for existence of table in VBA using SQL

    I have a problem. I have a table that is created in an ACCESS DB that runs daily. This table is deleted at the beginning of the next run. In certain situations, the table does not exist. I have been trying to test for that situation so I can continue processing without error but have been...
  8. presence76

    inserting SQL in criteria section of a make table query

    Thanks for the code. I found out how to do it within the make table query itself. I just had to add the tblUserids table to the available tables and then right clicked on the criteria box. Then select Build. Then double click on the table tblUserids and the code is generated. Thanks for the...
  9. presence76

    inserting SQL in criteria section of a make table query

    Hello. I have a make table query where I am selecting records from a table based on values I have put in to the criteria section of the query. This works fine. There is one field on the table "user", that I want to select from based on values in another table "tblUserids". Can I do that in...

Part and Inventory Search

Back
Top