Recent content by Waldin

as an access rookie i learn new things then master them. i have an excell spreadsheet from the previous system we used and i need to duplicate this spreadsheet and all its headings, cells and formulas into a form in the access database, Where and how do i do this...? or do i just import the...

hi Eugin no compiling problems but in form view when the event is called up the RunTime error still exists. im going to explore some other options. thanks for the contribution.

Hi Eugin thanks for the assistance, the report exists and the name is spelled correctly and i cannot seem to find the problem so what ive done is i created a diffrerent code shown below: Code: Private Sub Form_Timer() If TimeValue(Now) > CDate("07:00") Then DoCmd.SendObject ...

This is the highlighted section Private Sub Form_Timer() If TimeValue(Now) > CDate("07:00") Then Me.TimerInterval = 0 DoCmd.SendObject acSendReport, "WaldinPODetails", _ acFormatPDF, "support@magcc.co.za", , , _ "Reminder Of Parts Not Deleivered", _...

the message doesnt occur when i compile, it occurs in form view when the event is called up but before outlook opens up

Thanks eugin, it worked however now when the automatic email is called up another warning apears saying: "Track cannot find the object '|1'. any help with this? im guessing it cannot find a report with the given name right?

GoodMorning All My code below is supposed to send automatic emails but it generates the following error "Invalid Use Of Property" when i compile it, how do i get rid of this error...? Private Sub Form_Timer() If TimeValue(Now) > CDate("07:00") Then DoCmd.SendObject Me.TimerInterval = 0...

Private Sub Form_Timer() If TimeValue(Now) > CDate("07:00") Then DoCmd.SendObject acSendForm, "WaldinPODetails", _ acFormatPDF, support@magcc.co.za,,, _ "Reminder Of Parts Not Deleivered", _ "Good Morning, please recieve this reminder to state that the following parts has not been delivered", _...

upon compiling it, i get : compile error : syntex error.

thanks for your speedy reply Eugin, the above generates a syntax error code

hi Eugin below is my code Private Sub Form_Timer() If TimeValue(Now) > CDate("07:00") Then DoCmd.SendObject "track2@magcc.co.za"_ End If End Sub now this opens outlook but ive tried every way possible that i know but i cannot seem to get the recipients, CC, subject...

i was under the impression your code would instruct Access to send the email automatically without human intervention?

thanks Eugin Theres no error once i compile, but the email doesnt send!

Yes it is Multiselect

hi Eugin Thanks for your Response, after entering the code the way you suggested i still recieve an error when compiling it