Even with the correct identifier (control) the query still creates "ODBC call failed" error. The only time the extract works via ODBC is when you replace the variable with a literal value.
I currently have an Access 97 application that uses an ODBC connection to extract data out of an external database. The application uses a reference to a form to designate the search key. In Access 97 this program works flawlessly.
I recently began the process of converting the application...
I have an procedure that exports and formats data from Access into an Excel spreadsheet. The programs works fine the first time I execute the program. Subsequent executions yield the following error at the Range statement. Range("A1:G10").Select
Run-time error '1004'
Method Range of object...
How would I go about creating an outlook 2000 macro that opens up an email message and copies the name of the sender to the body. Then save and close the message.
Use an Access form to collect content. The content contains Html fields. Use SendOpbject to send an email via Outlook. Before sending the email the user can view it for accuracy.
Could you give me an example of how you do it?
When you open an outlook form you can add www.microsoft.com within the body of the text and when the recipient clicks on the link it opens the web site.
I have an application that requires that I send emails to customers with URL links. I have tried several approaches to accomplish this requirement to no avail. I am able to send the document as an attachment. Does anyone have any ideas how I can achieve this>
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.