Access 2000 using macro and queries to update table

[visualjoy]

I have created a macro that runs two queries
[red] Action: [/red]
[red]OpenQuery [/red] Query1
[red]OpenQuery [/red] Query2

[blue] Query1 [/blue][red]
[Table1]![Begin] <= [billing_date]
[Table1]![End] >= [billing_date]
[/red]
Get [Table1]![Daily_Rate]

[blue] Query2 [/blue] Update Query [red]
[Table2]![billing_date] = [billing_date]
[/red]
Calc [Table2]![billling_amt] = [Table2]![Possible] * [Table1]![Daily_Rate]

1. How do I carry over the [Table1]![Daily_Rate] for the calculation currently Query2 prompts me for [red]Table1!Daily_Rate[/red]
2. How do I turn off the message &quot;You are about to run an update query that will modify the data in your table.&quot; for everyone that runs this query... Do I have to go into Tool/Options and uncheck that on each machine or is there a way to do it from the macro?
3. How do I prevent the being prompted for the billing_date twice?

Thanks
Jeff

 

[MISMonkey]

Part 2 - you have options in the Macro design for 'Echo' and 'Set Warnings'. Select one of these and turn them off. You will need to turn them back on at the end of the macro for safety

I love deadlines. I like the whooshing sound they make as they fly by. (Douglas Adams)