I am have some trouble automating sending an email in access. Im trying to Dim
Dim objOutlook As Outlook.Applica tion
But its telling me "User Defined type is not defined". I've downloaded the Microsoft.Offic e.Interop.....d ll but still no joy. Does anyone no whats up
Thanks
Ross
rossmrn
Last Activity: Jul 18 '07, 08:57 AM
Joined: Feb 27 '07
Location:
-
You could try opening a query in access. Bring in the fields from the first table ID/Firstname/Lastname/DOB
In an empty window in the query type
GetLenght: Len(ID) ( in the Field: area.)
Then in the next window type
PartialID: Right(ID,GetLen ght-3)
This will give 102898 as a linkable field in this query. Open another query and bring in the next table. In a blank window type
PartialID:Left( ID,6). ... -
I keep on getting caught up on things that i forget to thank the people that replied
The above piece of code was just what i was looking for
Thank you !Leave a comment:
-
Close a Program
Hi
I've opened a program using the code
Dim RetVal
RetVal = Shell("C:\Progr am Files\Outlook Express\msimn.e xe", vbNormalFocus)
Then i create file's and report's and send them off which works fine.
However now i want to close the Application, i've tried
Dim objOutlook As Object
Set objOutlook = CreateObject("O utlook.Applicat ion")
objOutlook.Clos e
but im being told... -
The properties of the Linked tables look like this
[ODBC;DSN=ODBC_P nP_RampUp_Manag er;Description= PnP_RampUpManag er_DB _Connection;APP =Microsoft Office 2003;WSID=PC;DA TABASE=*******; TABLE=******]
Its not a trusted connection it uses SQL authentication not just a network loginLeave a comment:
-
I am using a ODBC link, however its on the initial opening of the Database that i want to be able to give the password automatically to the SQL server login, once open it run's fine. Sorry if i was'nt being clear enough (first post and all)
Thank for the replyLeave a comment:
-
Automatically Link Tables on Database Opening?
Hi,
I've linked several tables from a SQL 2000 server, and used there data to create Pivot tables on my load form. this works fine. However when i added a form that shows tables info in list boxes (using queries) it asks for a user name and password every time the database is opened.
Is there anyway i could give these details automatically, i've tried opening a connection on load and i've tried looping through each table giving the...
No activity results to display
Leave a comment: