Computers Archives - Page 17 of 21 - Technology Solutions Provider

Access VBA: Date modified of table

========= QUESTION --------- I want to show the date the table was last modified ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- Me.Signature2.Value = CurrentDb.TableDefs("ControlPanel").Properties("LastUpdated") ========= APPLIES TO / KEY WORDS --------- Microsoft Access VBA Date Modified ========= REF --------- http://www.accessmonster.com/Uwe/Forum.aspx/access-modulesdaovba/30880/Access-VBA-Date-Modified ---http://www.anysitesupport.com/access-vba-date-modified-of-table/ http://anySiteHosting.com

By AdmAny9348|2017-12-01T23:47:48+00:00May 23rd, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off

Access: View System Tables

========= QUESTION --------- How do I view System Tables or objects in Microsoft Access? ========= ANSWER --------- Access 2007 Right-click (Shift + F10) the top of the Navigation Pane on the left side of the screen Select Navigation Options Choose your options in the Display Options in the lower left of the Navigation Options [...]

By AdmAny9348|2017-12-01T23:47:48+00:00May 20th, 2011|Access, Computers, Documentation, Microsoft|Comments Off

Snap Survey: Variable Properties

========= QUESTION --------- Please define the different Variable Properties ========= ANSWER --------- The following options apply to the Variable Properties ofOpen questions only. Data Length –the maximum number of characters for openquestions. Box Length –the size of the answer area for an open question(in characters). Valid –the range of valid responses for open questions. [...]

By AdmAny9348|2011-05-18T13:31:09+00:00May 18th, 2011|Computers, Documentation, Snap Survey|Comments Off

Keyboard Shortcuts

========= QUESTION --------- Where do I find info on various Keyboard Shortcuts for my computer? ========= ANSWER --------- http://www.anysitesupport.com/keyboard-shortcuts-microsoft-outlook/ http://www.anysitesupport.com/keyboard-shortcuts-for-microsoft-excel/ ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- ========= REF --------- ---http://www.anysitesupport.com/keyboard-shortcuts/ http://anySiteHosting.com

By AdmAny9348|2011-05-17T09:07:15+00:00May 17th, 2011|Computers, Documentation|Comments Off

How do I view the headers for an email?

========= QUESTION --------- How do I view the headers for an email? ========= ANSWER --------- anySiteHosting.com SmarterMail Webmail Select the message you are interested inClick the Header link on the View line just below the Subject line ---------Outlook 2010 Open the email you are interested inSelect the File tab Under the Info section, click [...]

By AdmAny9348|2017-12-01T23:47:48+00:00May 16th, 2011|anySiteSolutions.com, Computers, Documentation, Email, Microsoft, Outlook|Comments Off

Access VBA: How to copy a table

========= 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 [...]

By AdmAny9348|2017-12-01T23:47:49+00:00May 12th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off

Can I use a mini-CD in my slot loading Mac?

========= 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

By AdmAny9348|2011-05-10T10:23:30+00:00May 10th, 2011|Apple, Computers, Documentation|Comments Off

Access: How do I open a new email message from VBA?

========= 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 [...]

By AdmAny9348|2011-05-05T09:08:36+00:00May 5th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off

Access: VBA to open Internet Explorer

========= 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 [...]

By AdmAny9348|2011-05-04T10:47:37+00:00May 4th, 2011|Access, Documentation, Microsoft, VBA|Comments Off

Access: Export report to PDF using VBA

========= 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 & [...]

By AdmAny9348|2011-05-04T10:05:40+00:00May 4th, 2011|Access, Computers, Documentation, Microsoft, VBA|Comments Off