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...

Thanks for the input Brad will do some testing and hopfully resolve. ddbrook

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...

Great thanks for the help again... ddbrook

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

Worked great!! The reason I have to delete is for the report, manager does not want to see all the records because it made the report to long!! We do what they want... Thanks so very much, Ddbrook

Great, I will try and let you know... Thanks, ddbrook

It is numeric. Table name is ActiveAccounts. No Autonumber field. This is a make-table query. 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...