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!

Register Log in
  • Congratulations Rhinorhino 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 WhiskyMac

  1. WhiskyMac

    Creating a URL within a Access created email

    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) &...
  2. WhiskyMac

    Error 2046, The Command or Action 'SaveRecord' isn't available now.

    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?
  3. WhiskyMac

    Receiving Faxes

    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...
  4. WhiskyMac

    Receiving Faxes

    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...
  5. WhiskyMac

    Writing back to access database from within VBA

    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...
  6. WhiskyMac

    Writing back to access database from within VBA

    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...
  7. WhiskyMac

    Writing back to access database from within VBA

    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...
See more

Part and Inventory Search

Back
Top