========= QUESTION ---------How do I copy, move, rename files from within the VBA code of my Access project? --------- How do I write a file backup routine into my Microsoft Access project/form? ========= ANSWER ---------See EXAMPLES ========= EXAMPLES --------- DoCmd.Hourglass True DoCmd.SetWarnings False 'store a serial number in the parms table 'then read [...]
========= QUESTION ---------How do I install the latest Adobe Flash Player on my computer? ========= ANSWER ---------Open your preferred web browserVisit : http://get.adobe.com/flashplayer/ Click the Download Now button Follow the on-screen instructions ========= APPLIES TO / KEY WORDS ---------Adobe Flash ========= REF ---------http://get.adobe.com/flashplayer/ ---http://www.anysitesupport.com/how-do-i-install-the-latest-flash-player-on-my-computer/ http://anySiteHosting.com
========= QUESTION ---------How do I delete all records in a table using VBA? ========= ANSWER ---------Simply execute a SQL statement as follows: DELETE * FROM NameOfTable; ========= EXAMPLES ---------Docmd.RunSQL "DELETE * FROM NameOfTable;" ========= APPLIES TO / KEY WORDS ---------Microsoft Access VBA SQL Clear ========= REF ---------http://www.access-programmers.co.uk/forums/archive/index.php/t-81194.html ---http://www.anysitesupport.com/access-vba-how-do-i-delete-all-records-in-a-table/ http://anySiteHosting.com
========= QUESTION ---------Microsoft Access doesn't handle null values very well when doing calculations, etc... Is there a way to check for a null value, and simply flip it to zero, or another entry? ========= ANSWER ---------Use the NZ() function Nz ( variant, [ value_if_null ] ) ========= EXAMPLES ---------Nz(Data,0) Was: StudentApprovals: IIf([StudentApproves] Is [...]
========= QUESTION --------- How do I round a number in the Query output in Microsoft Access ========= ANSWER --------- Round(Expression,[Decimal_Places])Expression is the number you wish to roundDecimal_Places is the number of decimals you wish to round to ========= EXAMPLES --------- Round(Goals) Round(Goal,2) Round(153.38,1) = 153.4 ========= APPLIES TO / KEY WORDS --------- Microsoft Access Functions [...]
========= QUESTION --------- How do I access my DNS Settings? How do I update my DNS records? ========= ANSWER --------- Windows Hosting Accounts Logon to your Control Panel (http://www.anysitesupport.com/how-do-i-logon-to-the-hosting-control-panel/) Click the Domains icon Click the domain you would like to work with Click the DNS Settings icon Click the record you need to edit --------- [...]
=========CALENDAR---------[Ctrl]+2: Go to Calendar view from any other view. [Alt]+1-9: View specific number of days, beginning with the selected day. For instance, if April 14 is selected and you press [Alt]+4, Calendar will display April 14 through 17. I use this one often. [Ctrl]+G: Go to a specific date. When you press [Ctrl]+G in Calendar [...]
=========QUESTION---------How do I ping a web site address? =========ANSWER---------In Microsoft Windows: Start button, Run, type COMMAND, click [OK]A black window titled Command Prompt should openAt the prompt type the following:PING WEBSITENAME (replace WEBSITENAME with your domain name) --------- In Macintosh OS X: Launch Terminal (open Spotlight by pressing Command + Space bar, and type Terminal)A small [...]
=========NOTES---------Create a form to house the controls (ControlPanel) Create buttons on the form and a CurrentStatus text box Write VBA Code tied to the buttons to update the CurrentStatus text box and to execute Macros that execute Queries ---http://www.anysitesupport.com/access-application-best-practices/
=========EXAMPLES---------Set rst = CurrentDb.OpenRecordset("Parms")EOW = rst.EOWDateMe.CurrentStatus = "EOW Date set to " & EOW & vbcrlf rst is simply a name to hold your recordset where you are opening the table ParmsEOW is simply a name to hold the field you are querying ---http://www.anysitesupport.com/access-vba-how-do-i-display-a-field-value/