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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. organizer

    Access 2000 & 97 together?

    The method described by Uriel365 above worked for me. A couple tips for after you have it installed: The default version to launch seems always to be whatever version you were most recently using. Consequently, I put a shortbut to EACH on my desktop to simplify moving between them without...
  2. organizer

    How can I click on email address and make it open mail program?

    I'm off this project for a few days - I'll try out your code next week Thanks! The procedure I described in the post immediately above works with a text field (actually, three text fields if you want to include the names). The reason I got intrigued with this hyperlink field was so we could...
  3. organizer

    How can I click on email address and make it open mail program?

    I wish my method were so elegant as to loop the addresses! I am only minimally literate with code so we do our bulk mailing with a query. All the code I've found works only for Outlook, and I get an error message when I try to activate the Outlook Express libraries in the references. Here's...
  4. organizer

    How can I click on email address and make it open mail program?

    I've tried a few more things toward the idea of getting the hyperlink field to be updated using code (and still work). Maybe this will click an idea for someone else here: I tried setting the "is hyperlink" property of the [MailTo] field to "yes" (that is the field that is...
  5. organizer

    User Error: How Do I Append Tables in Different Databases

    I should also mention, if you are not familiar with append queries, if you don't complete your project in one sitting, make sure when you go to work on it again you only open it in "Design" view, or it will run (it will ask you before it actually does so, however, so just say...
  6. organizer

    User Error: How Do I Append Tables in Different Databases

    If the append query can be set up so it only selects the records you want to put into the regular database then your method will work (move the table into your original database, then create an append query - then delete the table you moved in). If they are invoices, I would think you would be...
  7. organizer

    Forms again

    I think if you set the "views allowed" property (directly under the "default view" property in 97) to datasheet as well, it will probably solve your problem. -cynthia
  8. organizer

    How can I click on email address and make it open mail program?

    Hullo, No problem re-covering the ground! Others have done it for me in the past. I don't have tons of experience with the hyperlink format in this program myself, but my understanding is that it launches your default e-mail program, so I would guess it might work for Lotus. You can easily try...
  9. organizer

    How can I click on email address and make it open mail program?

    Apologies about my post just previous to huggybear. I'm accostomed to a different board format and in retrospect I realize in this format the reference to my code is not so good without including the code again in the new message. Similar to huggybear, my issue is that the database users do...
  10. organizer

    How can I click on email address and make it open mail program?

    Out of curiousity (and because it it awkward to edit the contents of a hyperlink field): Does anyone know why the hyperlink generated by my code would not work? (And in case Microsoft reads this, sure would be nice if the hyperlink field in Access could just recognize the difference...
  11. organizer

    How can I click on email address and make it open mail program?

    Thank you. I finally had time to try it today. It worked just fine. The person who uses this database is going to love this feature. -cynthia
  12. organizer

    How can I click on email address and make it open mail program?

    I have a question on this method. Since I also use the data in my E-Mail field to send bulk mailings to members, as well as when I print our directory, adding "mailto:" at the beginning of the addresses creates both technical and aesthetic problems. I thought I would solve this...

Part and Inventory Search

Back
Top