Search results

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

Hi Ladies and Gentleman, my intentions is to send an automatic email every morning at 10 to the suppliers who has outstanding deliveries. Private Sub Form_Timer() SetWarnings = True If TimeValue(Now) > CDate("10:00") Then Me.TimerInterval = 0 DoCmd.SendObject acSendForm, "WaldinPODetails"...

what a bummer, so much for Automated hey. thanks again Eugin.

Since we do not want emails to be sent every 2 minutes after 10 am you set the interval back to 0, thus it will not be called again.. when do i set the time interval to 0?

Greetingz To What OnFunction do i apply the SendObject or do i create an unbound field on the form and apply it to that field...?

could i please bother you with this specific task that i have, you seem quite comfortable with the whole automated email Subject and i got everything i need to put it in place (i think) but im toggling back and fo0rth between forms almost clueless