========= QUESTION --------- I need to have double quotes (") in a string in VBA, as I am entering WHERE statements in a SQL statement, but every time I have quotes in a string, it errors out. ========= ANSWER --------- Any time you have double quotes ("), simply double them ("") and you will [...]
========= QUESTION --------- How do I use the value from the field of one table as the criteria in a query against a different table? How do I use the DLookup function? ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- Number Fields:DLookup("FieldName" , "TableName" , "Criteria = n") Text Fields: DLookup("FieldName" , "TableName" , "Criteria= 'string'") Date [...]
========= QUESTION --------- I have a spreadsheet where I need to have a number in a cell for the calculations being done on that cell, but I want TEXT to actually display in that cell, not the number. For example, I have a spreadsheet showing a per line item cost, and the per line item [...]
========= QUESTION --------- I converted a Microsoft Access database from .mdb to .accdb format, and now when I run my usual VBA code to export a report to PDF, it gives me the error: Run-time error ‘13’: Type mismatch ========= ANSWER --------- If you are not using an ADO object library, clear the reference to [...]
========= QUESTION --------- How do I export to a spreadsheet using VBA? ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- MyFilePath = "C:Test" Me.Status = "Creating Spreadsheet file" Me.Repaint DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "ReportOrQueryName", MyFilePath & "FileName.xls" --------- Me.CurrentStatus = _ "Exporting to Excel for Distribution" & vbCrLf & _ Now() & vbCrLf & _ vbCrLf & _ [...]
========= QUESTION --------- What utility can I use to mimic the Snipping Tool from Windows 7 on Windows XP? ========= ANSWER --------- ScreenPrint32 ========= EXAMPLES --------- ========= APPLIES TO / KEY WORDS --------- Snipping Tool Screen Print PrtScPrint Screen Screen SnipPrintScreen ========= REF --------- http://www.screenprint32.com/ ...or just google it - this [...]
========= QUESTION --------- How do you view the DNS records for a domain? ========= ANSWER --------- If you are a client: http://www.anysitesupport.com/how-do-i-access-my-dns-settings/ If you are simply looking in general, you can do so on a Windows PC by opening the command prompt and typing the commands in the EXAMPLES area. ========= EXAMPLES --------- [...]
========= 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
========= 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 [...]
========= 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 [...]