QUOTE (jamez @ Aug 31 2010, 04:17 AM)
I'm creating a macro that ties in several update, append & make table queries all into 1 action.
The update queries are adding a date to an exiting table.
Is it possible to have the macro prompt me to enter the date for the update query?
Not sure about doing this in a macro, as I never use 'em, but... one option I've used a LOT is to create an unbound form with a textbox formatted per my needs (in your case as a [long/short/general] date). Then put a button on the form that executes your update query.
DBEngine(0)(0).Execute "your update query"