Is it possible to have a make table query that prompts the user for a name?
Once an invoice is submitted we create a table of the submitted data (long story why). At the moment, I have a make table query that creates "Invoice00" and then I manually change the table name to the relevant invoice number.
Ideally, I'd like to create a button that says "post invoice", the user selects the invoice to post, and the table is created with the relevant invoice number in the name.
Possible? Difficult?
*****
Just had a lightbulb moment. If I use an append query, and a single table I can do this very easily. Just have to think about how to use queries for the stuff I might need to use posted invoice data for.
Once an invoice is submitted we create a table of the submitted data (long story why). At the moment, I have a make table query that creates "Invoice00" and then I manually change the table name to the relevant invoice number.
Ideally, I'd like to create a button that says "post invoice", the user selects the invoice to post, and the table is created with the relevant invoice number in the name.
Possible? Difficult?
*****
Just had a lightbulb moment. If I use an append query, and a single table I can do this very easily. Just have to think about how to use queries for the stuff I might need to use posted invoice data for.
Last edited:
