Search results

Hello all, Ok what's the best way to send individual emails from a Query result. I have a search button on a form that looks for any month of the year the user types in. The results show the following fields - Name, Date of Birth and Email Address. Now I want to send an email with an...

ok thankyou that's great

Is it possible to view email addesses as actual hyperlinks in a query?

It's ok I've fixed it thanks

Ok after reading your posts I have got it to work but when the results show the Field Name changes to Expr1 How do I change it back to Date of Birth?

Oh erm yes, I feel a little stupid now...haha Cheers Bob

Hello bob, I now get two message boxes appearing one after the other, the first says: Enter Perameter Value OrderDate the next: Enter Month 1-12

Hello all, What's the criteria code for searching by month. I have a list of birthdays like this = 00/00/00.

thanks Ron_dK

oh thanks that's great

My suggestion is to have Video Tutorials on this site. Like this: http://www.youtube.com/watch?v=pT2boGE-bAg

If you have bitttorrent apps like the previoyuss poster said that slows things down look for something called "DNA" in "Program Control" and then click "Programs"tab and set DNA to Kill on Trust Level, Access, Server and Email. Then check the update options under "Anti-virus" "Advanced Options"...

i don't need the log out button on that form i'll have it on the main menu screen instead as i don't think there will be need for two log out buttons. thanks people...:)

no i've just noticed that when i click to "log out" on the Contacts form the Contacts form closes but the Main Menu form opens and the log out screen both appear.

Yes I also have a button located in the header part of the Contats form and the following code is attached to that and this works fine. Private Sub ExitButton_Click() DoCmd.Close DoCmd.OpenForm "MainMenuScreen" End Sub

Ok I've made lots of progress in Access over the last few weeks, but having a spot of trouble working out where I've gone wrong, I have a form with a button and on click I want that Form to clos and another form to open, but at the moment the form isn't closing. I have a Form called "Contacts"...

ok thanks Dave and DCrake you have both been great helps.

I understand that when I open the Query I'll see the result I'm after and having a message box appear will also verify that. I know I don't need a message box to tell me as I can see it on the Query. But I've been asked if this is possible.

This part is correct :) This part incorrect :confused: I wanted a message box to appear upon opening the Query. And yes I have learnt things and have to say that this forum is the best that I've found so far. I think the key is for me to read up on code for the module and then we're...

it's ok I'll not bother with the message as I don't really need it. But thanks for all you help.