========= QUESTION --------- How do I copy a table using VBA or SQL in Access? ========= ANSWER --------- See EXAMPLES NOTE: the use of of the square brackets ("[" and "]") will save you a lot of grief! For instance in the example below, the date formatting having hyphens in it screws up the [...]
========= QUESTION ---------Can I load a mini-CD or non-standard shaped CD-ROM in my macintosh computer that uses a slot loading CD-ROM drive? ========= ANSWER ---------No ========= EXAMPLES ---------See REF ========= APPLIES TO / KEY WORDS --------- MacCD-ROM ========= REF --------- http://support.apple.com/kb/HT2446?viewlocale=en_US ---http://www.anysitesupport.com/can-i-use-a-mini-cd-in-my-slot-loading-mac/ http://anySiteHosting.com
========= QUESTION ---------How do I open a new email message from VBA? ========= ANSWER ---------See EXAMPLES ========= EXAMPLES ---------Dim olLook As Object 'Start MS OutlookDim olNewEmail As Object 'New email in OutlookDim strContactEmail As String 'Contact email address Set olLook = CreateObject("Outlook.Application")Set olNewEmail = olLook.createitem(0)strEmailSubject = "TopSellers.accdb Application"strEmailText = ""strContactEmail = NAME@DOMAIN With [...]
========= QUESTION ---------How do I put a WordPress menu into the content of a WordPress page? How do I call a navigation menu using a short code? How do I add a navigation or site map to all sub pages on my page? ========= ANSWER ---------First setup a menu in WordPress under Appearance, Menus [...]
========= QUESTION ---------How do I open a web site from VBA? How do I open a url from VBA? How do I use VBA to open Internet Explorer? ========= ANSWER ---------See Examples ========= EXAMPLES ---------Private Sub ViewURL_Click() Set browser = CreateObject("InternetExplorer.Application")browser.Navigate ("http://www.Google.com")browser.StatusBar = Falsebrowser.Toolbar = Falsebrowser.Visible = Truebrowser.Resizable = Falsebrowser.AddressBar = True End [...]
========= QUESTION ---------Using VBA, how do I export a report to PDF in Microsoft Access? ========= ANSWER ---------Access 2010 option of opening report and outputting to PDF using the Access engine, not Adobe Acrobat Printer: see EXAMPLES --------- Other options: http://www.granite.ab.ca/access/pdffiles.htm ========= EXAMPLES ---------Private Sub SendReports_Click() Me.CurrentStatus = "Sending Reports..." & vbCrLf & [...]
========= 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 move my Kindle Books to a new iOS (iPhone, iPad, iPod) device? How do I manage my Kindle purchases? ========= ANSWER ---------Download the Amazon Kindle app to your new deviceOpen the Kindle appEnter your Amazon.com account email address and password and tap Register this Kindle If you already have the [...]
========= 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