Search results

Hayley, Here is the code i'm using. It worked the first time i tried, but hasn't since. Lee. Private Sub Email_these_students_Click() Dim strEmail As String Dim strBody As String Dim strBody1 As String Dim strBody2 As String Dim strBody3 As String Dim strBody4 As String Dim strSubject As...

Nothing happens. Just get the message saying e-mails have been sent, when they haven't. it did work the first time, but now nothing. Can't post db as it has linked tables.

Also, if they do send, they only send to the first person. it is not looping through all records.

Thanks again. have now got a from to select the results. My problem now is the e-mails don't send?????

Thanks for that. My only problem is that i am running a query to select specific items first

I currently have a table which includes the fields e-mial, name, address, course, amount owed, reason. I would like to send all these people e-mails, rather than have the Finance Department raise invoices. Anyone got the code to help, rather than me re-invent the wheel??? Thanks, Lee.

I have a database which has start dates off all employees in it. i need to work out the number of years and months between this date, and today's date. Any help gratefully accepted. Thanks, Lee.

Private Sub Command4_Click() On Error GoTo Err_Command4_Click DoCmd.SetWarnings False DoCmd.OpenReport ("R_Standard Monitoring Report"), acViewPreview, , "[T_Formatted data]![Period] = Me.Period.Value" Exit_Command4_Click: Exit Sub Err_Command4_Click: MsgBox Err.Description...

Can anyone tell me a piece of code which will allow me to round values up or down. Thanks, Lee

You need to make sure that you have only selected the tab you wish to work on. I have had this problem, and it is to do with selecting the object rather than just that tab. HTH, Lee.

I have a report with a list of codes and values against each code. I want the report to give me 2 totals at the bottom. One will be a total of all the codes which begin 05, and the other total will be the rest of the codes. Any ideas ???? Lee.

You need to write some code and assign it to both the Close button, and the On Close function of the form. You need the code to check that the required fields are complete else don't close. HTH, Lee.

Mike, I have used the following code : DoCmd.SendObject acSendReport, "R_Old SC Detail Report(E-mail)", "SnapShot Format(*.snp)", RstTmp.Fields![Budget Holder].Value, , , "Budget Monitoring Reports", "Please find attached your Budget Monitoring Reports. Should you have any queries regarding...

I have created a message box using code with OK and Cancel boxes. Why, when I click Cancel button does the code continue to run ???

Is TextBox1 the name of the box with the calculated field in it, or the name of its label ???? Maybe, you should try using the Sum function in your group footer. HTH, Lee.

I have done this using this code : Private Sub Command0_Click() On Error GoTo Err_Command0_Click Dim strUsr As String DoCmd.Close , , acSaveYes strUsr = InputBox("Who do you wish to e-mail this report to ? : ", "E-mail to ") DoCmd.SendObject acSendReport, , "SnapShot Format(*.snp)", strUsr, ...

Have you tried using the *. If in the query which your report is based on, you use the Like command, the report should print either the selected record, or if * is typed, ALL. HTH, Lee.

Create a report based on the data in the form. Then create a macro which Opens the Report, but has criteria which is equal to the form. I've done it before, and it works fine. If I don't make sense, e-mail me. Lee.

Have you set up your sub-form as a continuous form ??? This may solve the problem, Lee.

Try splitting the tables so that one table has details about the worker (I.e. Name, Address etc), and the other table contains there working data. Thene link the tables using The Employee ID field, and you can then create a form and subfrom to allow numerous work patterns to be enetered against...