Search results

Hi, lcook - That was definitely an excellent reference. Appreciate you help. Still my question in the original post was why do the 2 different expressions work? Thanks for your advice.

Sorry, changing my table structures resulting in massive form and event changes. I'm in Windows 7, Access 2007

Sorry, missed one word: when "double click column header DIVIDER", it opened the update form as you prescribed, but not sizing the column heading to fit. I'd like to preserve the sizing option.

Hi, John - Thanks for your quick response. I tried Form_DblClick event and works but ..., if I double click the datasheet column heading, instead automatically expand the column to fit, instead it opened the update form. Any way to prevent that from happening? Appreciate your help.

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...

That was a silly question. Turn out I wasn't in frmMasterSales but in one of its subform. Replacing Me with Me.Parent solved the problem. Still the question, both the following works - Forms!frmMasterSales!sbfUser_Default!chkCustomerContactInvalidDefault...

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...

Thanks! I'll change all my docmd.Requery to method Requery.

Oh yes, I always use DoCmd.Requery "(controlname)", the (controname) is either a list, combo box, or a datasheet with a list of values based on user selection on the form.

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.

Wow It works. One of those undocumented features. Thanks for your quick response.

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...

I use control = control.DefaultValue

Re: Tab page Lost Focus Event - Thanks Hi, Bob - Thanks for the advice. Tried it and works just like you said. Except I realized it doesn't work with my philosophy of refreshing other displays real time. Had to send through network to refresh them. Never thought it is controlled somewhere...

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...

Thanks so much. I'll give it a try.

Bob - That makes sense, albeit sucks. Nigel - Yes, the new file is under the root directory, outside of Program Files. (sorry, some adjustments below) So the conclusion - I'm converting an Access 2000 application under Windows XP to Access 2007 under Windows 7. Under Window XP the users...

Wow! That's just what I asked for. I'll give it a try and let you know the result. Any special library I need to include? Thanks for your help. Actually I want to have both module name and sub/function/class name so I can code a generic msgbox response and copy it around. additional...

Thanks for all your input. I checked off all Read-Only properties of parent folders and files, but it still won't let me update. When I opened up property again, they're read-only again. This is indeed related to Access 2007. Once I moved the files out to a folder I created, no more update...