Recent content by ledmark

Hello - I am trying to build an expression on a receipt form for school expenses and I can't figure out where to put the expression or how to correctly build the expression. The form has the following fields: RegistrationFee EquipSupplyFee TuitionPaid1 TuitionPaid2 TuitionPaid3 TuitionPaid4...

I understand and will move the End If. Thank you so much for your help :)

OK - I have to apologize because it is working. Something happened to my Hotmail account through my Outlook so I wasn't receiving any messages but when I tried it at work it automatically puts in the new FUDateContaced and sends the e-mail just fine. I don't think I'll run into any snags at...

Help Beetle! OK - I put the code in like this: Private Sub FUDateContacted_AfterUpdate() If Not FUComplete Then 'project is not complete so add 4 days to Date Contacted Me!FUDateContacted = DateAdd("d", 4, Me!FUDateContacted) End If Dim appOutLook As Object...

Hello Beetle - The e-mail issues is really not an issue - I have a table set up with only the e-mail's and no e-mail ID. I put EmailRecipient as the countrol source for the field on the form and it now stores the e-mail address selected in the table. For the adding 4 days to the...

OK - I'm a little confused. I looked in the table and it is not storing the e-mail address when it is entered. The clerk enters the sales person's e-mail address from a list box then enters the FUDateContacted (this being the date the sales person is supposed to call the client). If they have...

Hello - I have a form that has a field where a follow-up date is entered and an e-mail is generated based on that date to send a reminder e-mail. I have also added a field call FUComplete, which is a yes/no field. I want to have an If-Then statement say "If FUComplete = True then do nothing...

I have posted this on every Access forum I can find and not a single person has responded and I’m getting very frustrated. Can someone please just tell me if this is possible or not? Is it possible to at least put a hyperlink in the e-mail that will just open the database? I have a form for a...

I'm reading about the DateAdd function and it is always referring to a query but I'm working on a form and when I put in the ProjectDate then tab down to enter the e-mail address and then when I tab tot he FUDateContacted I want it to automatically add 4 days to the Project date and fill the...

OK - I put in the line you gave me: .deferredDeliveryTime = DateAdd("d",4, Me.FUDateContacted) This did nothing so I changed it to this thinking it didn't know what to look at to add the 4 days: .DeferredDeliveryTime = DateAdd("Me.ProjectDate", 4, Me.FUDateContacted) 'get the date from the...

OK - I'm seeing it and I'll give it a whirl soon. I'll let you know what happens - thank you tons!

OK - I feel like a dummy but where in the coding would I put that line or would it go someplace else?

Hello! I'm having some technical difficulties and would love your expertise - I have a form built where there is a date field in one section that has the date of the request put in it called ProjectDate. Then in another section for following up I have it set up so that an e-mail address is...

That did it - thank you so much@!!

Hello - I have a form set up so when the sales person enters a date for a follow-up call it generates and e-mail reminder and sends it to the sales person on the day of the follow-up call. For the subject line I have outlook getting the infomation from the ClientStreet field. This works fine...