Hello All,
I've been asked to take over admin of a database for our club. I haven't used Access for quite some time so I'm trying to get back up to speed on some things.
This is a very simple database for our football club registration. There are a few queries in the database already but I can...
OK--I've got it working and for the benifit of others looking here is what I did. I moved all of the files form the "SENT" folder and halve of the files from the INBOX folder out of OE. Then it started working. I assume that there was a corrupted file somewhere in there. Perhaps someone can tell...
Thanks for the replies. I've gone through most of the items listed on the site with no luck.
Smash:
I agree that it's obviously something particular to this box only. I am running Norton AV (not their firewall) I also run SpamSubstract from InterMute. The only firewall that I have is the one...
Greetings All,
For some reason, unknown to me, I can not send mail from Outlook Express 6. I've checked my server settings and tried sending from a couple of different accounts to no avail.
When I try to send a composed email, it just sits in the "OUTBOX" till a popup gives me this msg...
I'm guessing that you haven't installed your Mobo software yet, right? I've found that you have to do this and then possibly make changes in cmos before SATA gets recognized. I agree with electronicsfreak, read your manual.
Is it possible to export multiple objects, tables, queries etc. to another Access database? If so, please explain.
Thanks for all the incredible help here!!
Pat
Thank You-Thank You-Thank You.
Everything works great!
You two guys have gone far above what my expectations would have ever been.
If I ever get to the point where I can assist like this, I will be happy to do so.
Thanks So Very Much,
Pat
OK
I've added the code from Remou post and it seems to works! I tried it with two email address and one and it works fine.
Now if you can just tell me how I reference the two different email fields, "email-father" and "email-mother" in the code, I would greatly appreciate it. Again, both columns...
OK
I've replaced the line that you suggested Phil and added my email address. when I hit the button Outlook pops up the email, subject line and body intact, ready for me to hit send.
Actually, not knowing what was going to happen when I clicked the button, I created a new field called email and placed only my email address in it. All of the email addresses that I must use are loacated in "email-father" and "email-mother" The button is named "Email2"
I pasted the new code in...
Sure:
Private Sub email2_Click()
On Error GoTo Err_Email_Click
Dim dbs As DAO.Database, rst As DAO.Recordset
Dim strEmail As String
Dim strDate As String
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("Members")
strDate = Date
With rst
'writes all the email addresses to a string...
OK--I checked the references table and selected Microsoft DAO 3.6 Object Library. So now when I click the button I get an error msg. that says:
"Unknown message recipient(s); the message was not sent"
My table is named Members and the fields are:
MemberID
LastName
FirstName
DOB
Guardian
email –...
Phil4tektips:
Thanks for your replies. I did attempt to get this to work, but I had to get the emails out so I resorted to the laborious cut and paste solution. However, I am still trying to learn how to do this. I’ve read the FAQ that was suggested by Remou in the first post to no avail.
When...
Sorry if this question seems basic. Can somebody explain how I can send an email to everyone in my database? All of the email addresses are in the database. Does the email text have to be created in Access or can I create it in Word etc?
Thanks for any and all help.
Pat
Well, as it turns out, nothing worked. Had to reformat drive and start over. I really sort of knew it when I started here but thought I would as just the same. Thanks to all that viewed and helped.
Pat
My XP-Pro box gave me a "BOOT DISK FAILURE" msg. this morning and I've been trying to repair. I booted from XP CD and went into repair console. There I copied files from "\repair" into "\config" folder and restarted. I got the same msg.
Any other suggestions would be greatly appreciated. Should...
Hello All.
I was sent an Access database to input information into. Most of the information is already in our club database and I want to import it into the new database. Trouble is all I can see when starting the new database is the startup dashboard/directory and the forms associated with...
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.