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!
-
use button to open query
is it possible to open a query (Delete) by using the docmd in VBA for a button on a form? like: docmd.openquery "TEST",(now, where would the filter or criteria go?) Thank you for any and all help!- pbrown99
- Thread
- Replies: 5
- Forum: Microsoft: Access Forms
-
Join 2 tables
Two tables need to be linked for query but having problems Table 1 has vendor invoice info like: Name, amount, date, and status (if the vendor is overseas the status is 1, otherwise 0) Table 2 has the cargo charge percentages. Since the percentages change, it has the fields: Status, Start Date...- pbrown99
- Thread
- Replies: 5
- Forum: Microsoft: Access Queries and JET SQL
-
Access 2003 Security for Common Drive
I need to put a DB on the common drive, but only certain persons should have access. Initially , I tried maintaining a table with usernames, etc, to restrict access, but I have been told that I need to use the access security. I have tried to use the print-out for "User-leval security wizard"...- pbrown99
- Thread
- Replies: 1
- Forum: Information Security Group
