Hi
Below is a text string that I add to Access produced emails. What's the best way to create the URL as a web link?
txtMessage1 = Chr(10) & Chr(10) & "If you cannot read the attachments, please download the free Microsoft Snapshot Viewer SNPVW.EXE from" & Chr(10) &...
I'm using Access 2002 and want to force a record to be saved prior to printing. The VBA command line I'm using is
DoCmd.RunCommand acCmdSave
but this returns the error message
"Error 2046, The Command or Action 'SaveRecord' isn't available now."
Anyone got a work around?
Yes, It's the Analog modem that's connected via the MicroFilter, not the ADSL modem.
I am using the defailt settings on the modem, with call-waiting off, and Auto-Answer set to receive after 3 rings. Can you help any firther with the Modem settings? I'm using a Xircom Cardbus 100 + Modem 56...
I have recently installed Symantec WinFax Pro v10.0 and Microsoft's Fax Console on two separate Dell laptops, both running Windows XP pro.
Whilst I can successfully send faxes using both applications, I cannot receive anything at all on either. I have a normal ADSL line and the modem is...
In order to stop the same letter (report) being sent twice to the same person, I was trying to find a way of checking to see if the letter had already been produced, and if so, disallow the option. I am storing the CustomerID, date and Letter Name in a table so that a correspondance audit trail...
Thank you Duane. That works very well.
I now want to test each CustomerID to see if that letter (report) has been raised before. Using the same technique as before, I have created the following SQL statement, but it dosen't work. The statement line is as follows:
DoCmd.RunSQL "SELECT...
I am creating a report (a letter) under VBA from within Access 2000, passing through a customer ID number. When the letter has been created for that customer, I want to write today's date back to a field on the Access database so that the same letter will not be produced again for that customer...
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.