Search results

When I sent you my database before, I had to send it to your personal email address.

IT STILL STOPS AT THE COMMAND BUTTON Private Sub Command175_Click() Call eMailOverdue End Sub I would be happy to do that but I dont know what you mean by Code Tags. thanks,

this is the module Option Compare Database Option Explicit Public olApp As Object Public olNameSpace As Object Public objRecipients As Object Public objNewMail As Object 'Outlook.MailItem Function InitializeOutlook() As Boolean ' This function is used to initialize the global Application and...

ok it got thru that now but it stops at the command button event procedure and highlights on Call eMailOverdue Private Sub Command175_Click() Call eMailOverdue End Sub

here is a screen shot of the table in design view thanks,

ok great i will do that thanks,

What do you think is wrong with this. thanks for your help.

It is a table and yes ID is just a number field.

ok i changed the code and ran it and it stops on the command button event procedure Private Sub Command175_Click() Call eMailOverdue End Sub Then I debugged the module and it stops and highlights .ID still. I took out the [EMAIL ADDRESSES].ID from the codes and then ran it but it stops on...

ok here is the path....i understand up until this ![Email Addresses].ID.& "ToDoListFor_".....not sure why i need this?? DoCmd.OutputTo acOutputReport, "rptPROJECTS REPORT", acFormatPDF, "S:\ALLFILES\SUE'S STUFF\PROJECTS REPORT\" & ![EMAIL ADDRESSES].ID & "-ToDoListFor_" & Format(DATE...

ok i checked the spelling and then I Debugged and it stop at the same place.

I did Debug and error comes up saying Compile error: Method or data member not found on this line and highlighted on the word .ID. DoCmd.OutputTo acOutputReport, "rptPROJECTS REPORT", acFormatPDF, "S:\ALLFILES\SUE'S STUFF\PROJECTS REPORT\" & ![EMAIL ADDRESSES].ID

i just created a module and named in PROJECTS. Sorry Im such a pain lol.

I click on the button then the error comes up Compile error: Sub or Function not defined and highlights the Call eMailOverdue

oh yea...i knew that lol

Ok I think I got everything. Here it is. ption Compare Database Option Explicit Public olApp As Object Public olNameSpace As Object Public objRecipients As Object Public objNewMail As Object 'Outlook.MailItem Function InitializeOutlook() As Boolean ' This function is used to initialize the...

SELECT [EMAIL ADDRESSES].ID, [EMAIL ADDRESSES].[EMAIL ADDRESSES] FROM [EMAIL ADDRESSES] Should be this.

I know I will have to change some things I think but I just wanted to get it started...my module is called PROJECTS Thanks,l Option Compare Database Option Explicit Public olApp As Object Public olNameSpace As Object Public objRecipients As Object Public objNewMail As Object...

ok I did that but it gives me the same error and highlights the Private Sub Command175_click() Call eMailOverdue

Thanks for that. But I have a stupid questions. I created a module but how do I get the command button to use it. I thought I know LOL. It gives me an error on the Public. It says Invalid Attribute in Sub or Function. thanks,