========= QUESTION --------- Is it possible to Compact and Repair a Microsoft Access database from VBA? ========= ANSWER --------- The short answer is no. HOWEVER - we were lucky enough after much research to stumble across an obscure forum post discussing how to do it via simply sending keys via VBA! See Examples. [...]
========= QUESTION ---------How do I generate a random number between X and Y? ========= ANSWER ---------See EXAMPLES ========= EXAMPLES --------- Int ((999 - 100 + 1) * Rnd + 100) would return a random number between 100 and 999 ========= APPLIES TO / KEY WORDS --------- Random Numbers ========= REF ---------http://www.techonthenet.com/excel/formulas/rnd.php ---http://anySiteSupport.com [...]
========= QUESTION --------- Is it possible to code the event on one button to execute several buttons at once on an Access Form? ========= ANSWER --------- Yes - simply enter the following in the code for the 'master button' Private Sub MasterButton_Click() Call Button1_Click Call Button2_ClickEnd Sub ========= EXAMPLES --------- ========= APPLIES [...]
========= QUESTION --------- I have a long number that I need to collect the 2nd, 4th, 6th, and 8th characters from. ========= ANSWER ---------see EXAMPLES ========= EXAMPLES ---------Store: Mid([SurvNum_Span],2,1) & Mid([SurvNum_Span],4,1) & Mid([SurvNum_Span],6,1) & Mid([SurvNum_Span],8,1) ========= APPLIES TO / KEY WORDS ---------Microsoft Access VBA String Manipulation ========= REF --------- http://ycmi.med.yale.edu/nadkarni/access_course/String_Frame.htm [...]
========= QUESTION --------- When running a query from Microsoft Access against an Oracle table, I receive the following error and the query does not execute: ODBC--call failed. [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01722: invalid number. (#1722) ========= ANSWER --------- You are likely doing a type conversion (from text type to number type) on a database field [...]
========= 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 --------- 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 [...]