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 "You are about to run an update query that will modify the data in your table." 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
[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 "You are about to run an update query that will modify the data in your table." 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