========= QUESTION --------- How do I link in a local database to a Snap Survey hosted on line? ========= ANSWER --------- See REF --------- Summary of stepsStep 1: Setting up the Database Linkage Wizard Step 2: Creating the data link for the SQL database Step 3: Matching records between the survey and the database [...]
========= 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 --------- How do I add a new or edit an existing email address? ========= ANSWER --------- Logon to the Control Panel http://www.anysitesupport.com/how-do-i-logon-to-the-hosting-control-panel/ Click the Domains icon Click the domain you are interested in working with Click the Email Accounts (POP3) icon *Note: if you do not see all of your email accounts [...]
========= 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
=========REF:---------http://www.access-programmers.co.uk/forums/showthread.php?t=200804 =========EXAMPLES:---------Me.StatusBox.SetFocusMe.StatusBox.SelStart = Len(Me.StatusBox.Value) ---http://www.anysitesupport.com/vba-automatically-scroll-to-bottom-of-text-box/
=========QUESTION: How do I add date and/or time values to Access queries, VBA, etc...? =========EXAMPLES:---------Day of the week of a given Date:Day: Weekday([TransDate])Day: IIf(Weekday([TransDate])=1,"Sun", IIf(Weekday([TransDate])=2,"Mon", IIf(Weekday([TransDate])=3,"Tue", IIf(Weekday([TransDate])=4,"Wed", IIf(Weekday([TransDate])=5,"Thu", IIf(Weekday([TransDate])=6,"Fri", IIf(Weekday([TransDate])=7,"Sat","nada"))))))) ---------The current month:DateSerial(Year(Date()), Month(Date()), 1) The next month:DateSerial(Year(Date()), Month(Date()) + 1, 1) The last day of the current month:DateSerial(Year(Date()), Month(Date()) + 1, 0) The [...]
========= QUESTION --------- We own/lease a Linux server from anySiteHosting.com and would like to enable the feature to allow users to visit their site via a temp url like http://cp.OURDOMAIN/~CPANELUSERNAME ========= ANSWER --------- Login to WHM Search for "mod_userid" using the find field at the top leftClick Apache Mod_Userdir TweakCheck "Enable mod_userdir Protection"Check the [...]
This content is password-protected. To view it, please enter the password below. Password: