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 Wanet Telecoms Ltd 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: *
- Users: presence76
- Content: Threads
- Order by date
-
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...- presence76
- Thread
- Replies: 7
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- presence76
- Thread
- Replies: 4
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- presence76
- Thread
- Replies: 2
- Forum: Microsoft: Access Other topics
