Need Runtime help! How to turn off warnings

[dakcg]

Hi,

I have a simple Invoice database that I have converted to open in runtime. When creating invoices, I run an append query, then a form for printing options opens up. Except in the runtime the form doesn't open, instead warnings regarding the append query appear, even though I have turned them off in my Access before creating the runtime version. And after those warnings, no form opens up.

Anyone know about this? Help!!

Thanks

dackg

 

[WayneRyan]

dackg,

You can still set: Tools --> Options --> Edit/Find

There are three options. You should be able to set them programatically
too.

Wayne

 

[dakcg]

What?

I am sorry, but that made no sense at all! Could you expand?

 

[dakcg]

Sorry, I will try again

Hi, I have created a couple of databases, but this is the first one that I am creating for the Runtime enviroment. The problem is, I am just learning to write code, and the only thing I know about error handling is that it is important!

During testing of the runtime db, I discovered just how important it was.
The task is to create invoices using data saved in customer table, and append that to the invoice table, with the inv # as an autonumber.

When the button on the Invoice form is pushed, it runs the append query, then opens up a secondary form that gives the options for the printing of the invoices.

So, In testing the button was pushed and a warning appeared about appending into table, standard Access warning. But I disabled that in my Access before creating the runtime, shouldn't that have turned off the warnings in the runtime?

And, after the warnings, the next form did not open, which meant that you could not even see if the append query worked or not.

I realize that I have alot to learn about runtime, however, the client would like to do the invoice run by Friday!

Any help anyone has will be very welcomed.

Thanks
dakcg

 

[Rich]

I'm not sure why you're running an append query at all, why not just write straight to the invoice table, you should only need the PK from the customer table as the FK in the invoice table.
However if you use the .Execute method you'll get no warnings, or use
DoCmd.SetWarnings False, don't forget to turn them back on again, DoCmd.SetWarnings True

 

[dakcg]

reason for query

Hi,

The reason I am using an append query is because the client only offers one service to his customers, so I have saved the name of the service, plus the monthly charge in the Customer table. So, instead of having to create the invoices by hand one at a time, the database takes the saved service info from the table and uses that to create the new invoice, basically automating his invoices.

Make sense?

Thanks
Dak

 

[WayneRyan]

dak,

Go to the Menu Bar.

Choose Tools --> Options

Then select the Edit/Find Tab.

In the upper-right hand corner, you can UNCHECK the confirm.

Wayne