We have tables linked to an SQL server and imported directly into Access via ODBC.
Our sample database represents a video store in which employees can check out videos for customers.
We'd like to have the employee enter the video's call # into a text box where a button called "Check Out" will run a query that updates a table of "checkout out" (rented) videos.
This involves pulling data from other tables that are already linked by primary keys.
How would we go about linking a button to an SQL query based on input from the user?
Our sample database represents a video store in which employees can check out videos for customers.
We'd like to have the employee enter the video's call # into a text box where a button called "Check Out" will run a query that updates a table of "checkout out" (rented) videos.
This involves pulling data from other tables that are already linked by primary keys.
How would we go about linking a button to an SQL query based on input from the user?
Facebook
Twitter