|
||||||
Access MVP (2010-2015) |
In Windows XP… "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "YourDriveLetter:\PathToYourDatabase\YourDatabase.mdb or accdb" /decompile In Windows 7 64 bit… "C:\Program Files (x86)\Microsoft Office\YourOfficeFolder\MSACCESS.EXE" "YourDriveLetter:\PathToYourDatabase\YourDatabase.mdb or accdb" /decompile 1,730 total views 1,730 total views SELECT YourFieldName FROM YourTableName UNION Select "ALL" as Bogus FROM YourTableName; Then set the Default Value for the Combo Box as “ALL” 1,832 total views 1,832 total views The Tab Control On_Change Events fires when you click on (and change) the tab page you are on The Tab Control On_Click event fires if you click in the tab area where there is no tab The Page On_Click event fires (for the selected page) when you click in the area below the tab […] 1,951 total views You just went grocery shopping and your car is full of groceries. Which is faster? Take bag from car, open door to house, put bag inside house, go back out door closing and locking it behind you, repeat as many times till done OR And, here’s the persistent connection part… Take bag from car, open […] 17,559 total views Simple UPDATE query… UPDATE YourTable SET YourTable.YourField1 = "Your Value"; Update a field in your table with values from another field in your table… UPDATE YourTable SET YourTable.YourField1 = [YourField2]; Update a field based on a field on your form… Note: The form must be open to perform this action! TEXT UPDATE YourTable SET YourTable.YourField1 […] 517 total views, 1 views today It’s always a nightmare when you’re trying to reference a control from one Form to another or one Report or another. You think you’ve typed it correctly but it’s still not returning the value. Here are two ways to get that accomplished… From The Access Web… Refer to Form and Subform properties and controls OR […] 3,345 total views To open a file regardless of the File Extension you can use… The below is run from a Command Button on a Form the has a Control listing all the files in said directory. Windows XP… Dim strFileName As String strFileName = Dir("C:\Documents and Settings\Regina Whipp\My Documents\YourFolcer\" & Me.FieldOnYourFormThatHasFileName & "*") Application.FollowHyperlink ("C:\Documents and Settings\Regina […] 1,385 total views |
Have an Access... ential you want to share? Drop me a line!
Note, all tips are moderated before posting. |
||||
|
Copyright © 2024 Access… entials - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
