Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: vbmanchris
- Order by date
-
Formating test string in body of email
If you know that the user will have an e-mail client that supports HTML (Outlook, Outlook Express, Netscape Mail, etc.) you can use HTML to format the table. <TABLE> <TR> <TD>Customer</TD> <TD>Part</TD> <TD>DateStart</TD> <TD>DateEnd</TD> <TD>Discount</TD> </TR> </TABLE>- vbmanchris
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
How to use System Variables?
Hello, I am trying to use a system variable to determine and set the path to an export file that my VBA code is creating. What variables can be used in VBA to set the path to the user's desktop, or the Windows directory, for example? Obviously, "C:\Windows\Desktop" isn't going to...- vbmanchris
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
link a ODBC Table, the following Code still prompts for a DSN
Since you DSN is two words, have you tried to place quotes around the DSN name? For example: tdf.Connect = "ODBC;Database = " & strdbname & ";DSN = '" & strdsnname & "';Integrated Securtiy = True" Also, if you are using a DSN, you shouldn't need to include the...- vbmanchris
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
