I am trying to create a database in Microsoft Access 2010 involving records of employees. One of my macros involves running the following SQL query:
SELECT
*
FROM
Employees
WHERE
[First Name] = [Enter First Name]
AND [Last Name] = [Enter Last Name];
Currently running the query results in 2 dialog windows popping up to enter the first and last name. This works as intended, but I want to bind the query to a button in my database next to some text boxes, like this, so that when I click on the blue button it runs the query with the text boxes as the first and last name inputs. I'd like to not get too deep into VBA if I can help it, as I haven't had any experience coding in it.
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…