Code:
SELECT Data.*, Data.ID
FROM Data
WHERE (((Data.ID)=InputBox("id")));
How do I make an input box select what record to view in a report?
3 results in 0.0023 seconds.
-
InputBox to select records
I want to run a report that first asks what "ID" to find:
But I get an error that says: Function not available in expression.
How do I make an input box select what record to view in a report? -
VBA InputBox Automatic Population
I have a function which produces an email for a specific contact, and I have a report which again is for the same specific contact. This function opens Outlook and enters the email data into the message body (derived from one Query), and it then attaches the report (derived from another query) to the email.
This routine works perfectly, however, it means I have to enter the Contact name into both InputBoxes. Is there a way to use... -
Collect Data On Excel Sheet Using Input Box
I have a user form which has a number of buttons on it. Each button represents a vegetable (Eg, Cucumber, Carrot, Tomato)
The purpose of this is to take orders from customers for the vegetable they would like to order and the amount.
When each button is clicked (eg, Carrot) the macro would place the word 'Carrot' on the excel sheet. After which an input box will appear for the user to input the amount needed.
...
