 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Queries / May 2006Append and delete queries
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. > Is there any way to have 1 query to append then delete the records that were > appended? > > -- > Message posted via AccessMonster.com > http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200605/1 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. >No. That takes two queries. > >You can run them consecutively using a macro or some vba code. > >> Is there any way to have 1 query to append then delete the records that were >> appended? 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 HTH, Nikos |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.