Mary,
Thank you. It worked. Couldn't have done it without your help. Have a happy holidays and hapy new year....
flynjack
Last Activity: Jan 10 '07, 06:38 PM
Joined: Oct 25 '06
Location:
-
Mary;
I'm sure I have annoyed you enough by now, but please let me ask one more questions. My query "qryReject" pulls the following info.
"Remarks" from SRB Weeklytbl
"Remarks" from SRB Error Code
"Grade" from SRB Weeklytbl
"Name" from SRB Weeklytbl
"SSN" from SRB Weeklytbl
"Reup_Date" from SRB Weeklytbl...Leave a comment:
-
My appologies to all. Instead of the SQL thread, i have devised a query that shows all columns needs for my email (8 columns). Each record needs to be sent individually through outlook. How do I devise the code to use my query. Thanks. (Very New at this!!!!!!!)Leave a comment:
-
Mmccarthy;
Can you elaborate on the code above and put it into idiot terms for me. Same idea as yesterday, only my query has extracted all of the fields needs to include a column will all email addresses.Leave a comment:
-
Mmccarthy;
Sorry about that. The info I gave you yesterday was bad info. Turns out the Dbase already had a query built into to so I didn't need the sql join statement. Couldn't figure out how to modify your info to adapt to a query.Leave a comment:
-
Access Query to Outlook
I have a query in my dbase that shows shows results in ten columns (let's call the columns a, b, c, d,e,f,g,h,i,j). Column j lists an array of email addresses. I want to email these results through outlook to the individual email addresses in column j. how do I do this.I will not need to add any attachment. I will need to add a subject line called "Employee Errors". Thank you.Leave a comment:
-
for some reason, I get a compile,syntax error on the follow line.
DoCmd.SendObjec t (acSendNoObject , , , rs![Email Address], , , "Error Code: " ,,, rs![Error Code], "Error Description: " & rs![Error description], False)
Any idea as to why?
Thanks again.Leave a comment:
-
Mary
Thank you for your prompt reply. One more question if you don't mind. How do I place "Error Discrepency" in the Email Subject line? Thanks a million.Leave a comment:
-
Access to Outlook
I have a table named "tblError". The table includes the following columns: (1) Employee ID (2) Error Code (3) Email Address (4) Email Sent (Check box from Yes or No, Yes if checked. I have a second table named "tblErrorCo des" that has two columns (1) Error Code (2) Error description. The tblError is populated by an append query and only pulls new records with error codes. My object is to pull a query that shows Employee... -
Splash Screen Question
My current dbase has a splash screen on start up with a time interval of 5000. After it closes the vb code then opens my main form.
Question: I would like to add text to my splash screen that says good morning, good afternnon, good evening depending on the time of the day my dbase is opened. for isntance, if user opens at 6:00AM, it would say good morning, but if the dbase was opened at 6:00PM, it would say good evening.
Question... -
Thank you all very much. I have managed to get into the DB now by using the properties tool program as described above. But my problem is now getting into the modules. I have password protected them in VBA and that's what I need help with. I know I can purhcase a $40 VBA password reset tool that will fix my problem, but before doing so, Is there any other way of resetting my password or is there any freeware to fix the problem? Thanks again...Leave a comment:
-
Tried that and yes it did allow me to get into the VB panel but of course I password protected the module. On ideas on how to undo my password??? Thanks again.Leave a comment:
-
Yes, I can get into the DB but not into the VB panel. I'll try the tool you sent me and see if it works. Thanks.Leave a comment:
-
Taking back Shift Bypass
I'm sure i'm not the only one who has done this, but please HELP!!!! I have devised a new Access Database and saw online I could disable the Shift Key bypass. So, trying to advance my Access skills, I ran the code in a Module and have now locked my self out of the database. Actually, not locked out. I just can't view my tables, modules, queries and such any more. Below is what I have adjusted:
StartUpShowStat usBar = False
...
No activity results to display
Leave a comment: