========= QUESTION --------- How do I run a DOS command at the Command prompt from VBA? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Shell "cmd.exe /k dir c:windowssystem*.exe", vbNormalFocus ...consider running a .bat file for more involved commands? ========= APPLIES TO / KEY WORDS --------- Microsoft Access VBA Command Prompt Commands [...]
========= QUESTION --------- Can you execute or run a Saved Export in Microsoft Access from VBA? ========= ANSWER --------- Yes - see EXAMPLES ========= EXAMPLES --------- DoCmd.RunSavedImportExport "NameOfSavedExport" ========= APPLIES TO / KEY WORDS --------- Saved Export Saved Import ========= REF ---------http://bytes.com/topic/access/answers/895859-how-can-i-run-saved-export-vba ---http://www.anysitesupport.com/vba-run-saved-export/ http://anySiteHosting.com
========= QUESTION --------- How do I do a find and replace within a string using VBA? How do I replace a character in a string? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- Sometimes you will stumble across someone having entered a phone number in a database with a "/" between the area [...]
========= QUESTION --------- Can you save your ODBC user and password in the registry to avoid having to re-enter your password every time you connect to the database? ========= ANSWER --------- Yes - though it seems to work better in older versions of Oracle than newer ones. Open your Registry Editor (Run, RegEdit) Navigate [...]
========= QUESTION --------- How do I convert a file in Microsoft Publisher to a Microsoft Word Document? ========= ANSWER --------- Apparently the best way to do this is to save the TEXT of the Publisher file to a Word document first, and then copy over any images, etc... There does not appear to be [...]
========= QUESTION --------- How do I tell which edition (32 bit / x86 or 64 bit / x64) of Microsoft Office I have installed? ========= ANSWER --------- From any Microsoft Office application, select File, HelpOn the right side, you will see a version number in the following format:14.0.####.#### (##- bit)If the application version number [...]
========= QUESTION ---------I want to disable a button after the user has clicked it in my Form - is this possible? ========= ANSWER --------- Very simple - see EXAMPLES ========= EXAMPLES --------- clickedButton.Enabled = false ========= APPLIES TO / KEY WORDS --------- Microsoft Access VBA Button Command Button Enable Disable ========= [...]
========= QUESTION --------- All I am doing is trying to do a calculation or manipulation on a field in my query, and it comes up with #Error rather than the results. If I do the calculation in a test field, it works just fine - what's going on? ========= ANSWER --------- Obviously, this could [...]
========= QUESTION --------- To keep my VBA code clean, I use quite a few line continuations ( & _ ). Recently, however, Access errored out on me with the note: Too Many Line Continuations. Is there a way to work around this? ========= ANSWER --------- Yep - just trick it by setting half your [...]
========= QUESTION --------- I use a table called Parms in my database to store application specific parameters.If a user accidentally added a record to this table, instead of simply editing the single record containing the appropriate values, it would cause major issues for the application. Is there a way to restrict a table to contain [...]