Search results

Hello, experts. I am working on a machine with Access 2007 Hebrew version installed. The OS is Windows 7 in English. I want to switch all Office programs to English UI language also. I have followed steps described on Microsoft official help site and set up the default display language of Access...

Thank you so much. It worked perfectly.:D

Hi, I use Access 2003. I am trying to populate a list box with the names of files found in specific folder in my computer. The problem is that if the file name has a comma (,) in it, so the name is being separated in two parts - first what is before a comma and second what is after. I need them...

Hi, experts. I am using Access 2003 on XP Home SP3. I have a MainForm with a TabControl on it with 3 pages. Pages No'2 and No'3 each have their own Subform (let's call them sbfParent1 and sbfParent2). Each sbfParent has its own TabCtl with a sbfChild (1 and 2) on each page. Each sbfChild (we...

I want to update "LastUpdated" only when data was really changed and not when *someone* touched that record. That's why "BeforeUpdate" (If Not Cancel) and not "OnDirty".

Thank you, GinaWhipp. First, I do not want too many controls on the form, as I do not want to display this info (even if I put it in Footer/Header and make it invisible, it is still there). However, this is not an issue. More important that OnDirty will update this field even if later the Cancel...

Hi, I am working with Access 2003. I have a MainForm with few subforms. I want to update the "LastUpdated" field in the source table of MainForm, but I get "Write Conflict" message. There are no other users on my PC. Here is the code in MainForm: Private Sub Form_BeforeUpdate(Cancel As...