Search results

In Access, Tools->Start... I uncheck the "Show Database Window" checkbox to hide the database window when the database opens. When I enter an icon to be used for the program, the hide DB window utility cease to work on Windows 2000, but not on Windows XP, e.g. the DB window is shown when...

I have the Swedish version of Access. When I write =expresions in the controlsource of control in a form/report, I cannot use the english function names as in VBA, but must use the swedish substitute for the name, which access then translates into english, but still view it as swedish in form...

I have a form in spreadsheet view. Basically all I want is to update the information which is viewed, but Form.ReCalc doesn't requery the database. So I tried Form.Requery. But after doing Form.Requery, the first record of the form becomes the active record, and in some cases I have to scroll to...

I use Microsoft Treeview Control 6.0 (SP6) in both Excel and Access. In Excel I can see the properties/methods in the VBA using Ctrl+J (or Ctrl+Space) but in Access I get the wrong list of methods/properties, e.g. properties is missing, and those viewed in the list doesn't exist. Why, and how...

Form spreadsheet view BUG I have serious problems when viewing forms in spreadsheet View. I have forms named Form1, Form2 and Form3. All forms is viewed in datasheet view. Form3 is subform to Form2, and Form2 is subform to Form1. When I click the + sign next to a record (say, record #3) in...

Form1 has a sub form, Form2, which have a tab control with a number of tabs. One of them, Tab4, includes a sub form, Form3. I have an SQL statement that I want to run (using DoCmd.RunSQL) when Form3 is shown on screen the first time, e.g. when Tab4 activates. I've tried OnClick for Tab4...