
July 3rd, 2003, 06:50 AM
|
|
Junior Member
|
|
Join Date: Jul 2003
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
2 important questions about Access 2000
Hi Everyone!
Could anyone help me?
I'm trying to create a macro which opens a query which saves certain records from a table into a floppy, and afterwards the macro opens a query which takes the same records that the first one got (without asking the user again) and deletes them.
I have 2 problems:
1. I wrote:
Between DateSerial([forms]![request_delete_records]![start_year_],[forms]![request_delete_records]![start_month_],1) And DateSerial([forms]![request_delete_records]![end_year_],[forms]![request_delete_records]![end_month_],31)
in order to ask the user's criteria through my own form - but the Access ignores it and uses its own default form.
2. How can I tell the deletion query to take its input from the backup query, I mean: How can I take a query's output to be another query's input?
Please help me if you can!
Thanks
|