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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ratnek
-
Send email
This works for me: ' Start Outlook. ' If it is already running, you'll use the same instance... Dim olApp As Outlook.Application Set olApp = CreateObject("Outlook.Application") ' Logon. Doesn't hurt if you are already running and logged on... Dim olNs As...- ratnek
- Post #5
- Forum: Visual Basic (Classic)
-
LINK WITHIN SQL STATEMENT
This SQL statement works and connects on the fly to an external database: SELECT * FROM ([ODBC;DRIVER={Microsoft ODBC for Oracle};SERVER=servername;UID=myID;PWD=myPassword].ownername.ExternalTable I have lost the source example for this code. I want to link to an external Access database usin...- ratnek
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
Access Permission and Scheduled Tasks
I have a simple VB6 application that opens an Access 2000 DB and runs two macros. When someone is logged on, I can set a scheduled task to run the application as anyone with a proper network password and it works fine. But when no one is logged onto the computer and the scheduled task is set...- ratnek
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
How do you CREATE VIEW in Access
In Access you would create a querydef instead of creating a view. But if you are linked to an Oracle DB or another DB that uses views, then you can create a pass-through query that bypasses the JET Engine and goes straight to the underlying DB. Then you can use the Create View syntax.- ratnek
- Post #2
- Forum: Microsoft: Access Other topics
