Search results

I want to be able to open an update form when I double click a record in a datasheet (personally I don't like the split form). Do I have to create a double click event for every field? Or is there a shortcut for this one event for all? I tried Form's Detail_Dblclick but it doesn't do...

I have a subform on a form, although these 2 are NOT linked. This expression runs well - Forms!frmMasterSales!sbfUser_Default!chkCustomerContactInvalidDefault=True But both expressions below produce error '2465'-"Master Sales can't find the field 'sbfUser_Default' referred to in your...

During debugging mode, sometimes the DoCmd.Requery is available, sometimes it's not and produce error 2046 "The command or action 'Requery' isn't available now". Can anyone shed some light on when and why? Thanks for your help in advance.

Last time when I close Access, I forgot to clear the breakpoints. When I start Access again, the program break at the points where I set earlier, but no break indicator. "Debug>Clear All Breakpoints" doesn't work. How do I get rid of this pesky behavior? Thanks for your advise in advance.

Due to user requirement, I've changed the organization of one of my form. Some fields originally in the main form are now moved into its subform. Now I found some events should be moved from the main form to the subform. I can handle that. But my question is this - How do I know if any other...

Created a tab page to update a table record. For each field's afterupdate event, an update query is executed to update the record. I assume this causes network traffic. (I like DIY, not crazy about split form) To reduce network traffic, I added an invisible count control, instead of executing...

I used to be able to keep my Access program and data under C:\Program Files under Windows XP, under Windows 7 I get "not updatable" message, opening the data file under C:\Program Files shows "read-only". Does that mean I need to keep my data in other places? Thanks for your advice in advance.

When I use msgbox, I like to display which module this message comes from. Currently I hard code the module name in the message. Can anyone show me is there a system variable that has this module name so I can display it automatically? Thanks for your advice in advance.

I'm new with Access 2007 (what a mess), trying to convert my Access 2000 version system to 2007 version. The older version is all macro driven, I'm now much better with VBA, also need to add more functions (tables, queries, forms, reports, and of course class modules). How should I go about...