Search results

This is my code to load my form when I open it. Which it works fine, but when I have 2 or more emails to send out for that day... Can someone show me how to loop to next record???? Please... Private Sub Form_Load() On Error GoTo Err_Form_Load DoCmd.Maximize DoCmd.GoToRecord , , acFirst...

I am creating a form so I can input all calendar master information so it can email a reminder on a certain date to an employee. Example: reportdate,email,reportfor,reportbody. 5th of month,somebody@yahoo.com,John Williams,Run AP Claims Report. I have the email part working fine. What I need...

I have a form that dispays the calendar... What I need is when I choose a time sheet to print I want the date field to fill in on my report from my calendar. Right now I am prompting with a parameter. I want to be able to click a sbegin date and then an end date and show on my report. Without...

I have a date field[trans_date] this has multiple months in the field...I need to pull the last 12 months of data in my query. Data looks like this: Acct#,trans_date,trans_amt,journ#. 1234,10/4/02,5900.29,24 I need to take the current month and minus 12 months. Thanks for your help. DDBROOK

I have a customer number that can have multiple account numbers. The probably is that I only want 5 of them on each customer number. Below is a query I ran to get customer numbers > 5. Cust_no, CustCount 16188,112 205612,63 12417,49 Now I need to delete anything >= 5 on each customer number...