Screen updating ms access Free naughty online sacramento chat phone numbers

For example, this code will resize a sub-form within a resized form: [font=Verdana][size=2]You should not have to do all that.Queries will run in the background if the correct command syntax is used.

Don't forget error handling & turn the screen on before you try to msgbox an error or exit the sub.

[/size][/font] Try the following steps and let me know what happens: If it does not do the trick in a macro setting, I will show you how to accomplish it with just a few lines of VBA code. Before running your macro, make sure that the checkbox for confirming action queries is unchecked. Modify your macro to sandwich the Open Query action between the Set Warnings On = No and Set Warnings On = Yes actions as shown.

Action ............................................... Arg uments Set Warnings ................................... On = No Open Query................................... View = Datasheet; Data Mode = Edit Set Warnings .....................................

Thanx Kind Regards Dump the macro, convert it to VBA.

You have a design problem if your function is opening a module and also opening a table.

Leave a Reply