Append and delete queries

  • Thread starter Thread starter markwmiller via AccessMonster.com
  • Start date Start date
M

markwmiller via AccessMonster.com

Is there any way to have 1 query to append then delete the records that were
appended?
 
No. That takes two queries.

You can run them consecutively using a macro or some vba code.
 
I have a delete and append query that the user needs to enter beginning date
and a ending date. How can I set it up so the user only has to enter the
dates once? I have them running with a macro.
 
Use a form with two unbound controls (textboxes or, better yet,
calendars) where you set the date boundaries; a command button next to
them fires the macro or code which runs the two queries; bot queries
reference the controls on the form for their criteria, rather than
opening input boxes. Criteria could look something like:
= Forms!frmCriteria!txtDateFrom And <= Forms!frmCriteria!txtDateTo
Click to expand...

HTH,
Nikos
 
Back
Top