Recent content by sandrao

have found the following code with the loop Private Sub SendAll_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strTo As String Set db = CurrentDb() Set rs = CurrentDb.OpenRecordset("Emailer", dbOpenSnapshot) With rs Do While Not .EOF strTo = !Email & ";" & strTo .MoveNext Loop End...

Is there a way to modify my original code to be able to send a report to ALL email address in a field? If so could you be an example of that code.

One other question. If I wanted to have a Combo Box on the form with Email address attached how could I get the code to accept email address on the form without including it as part of the code. Mainly because the reports have a potential to be sent to over a dozen agents.

Thanks! Changed it to False and everything works fine. Thanks again!

I do have a code for SendObject. But it opens outlook with the attachment then I have to click send button to complete the message. DoCmd.SendObject acReport,"report", acFormatRTF,"my email address",,,"Subject",,True what else could I add to send the message without opening Outlook?

I am still trying to find a way to use code to send email through access of reports. I would like to have the ability to send more that one email to several addresses.

Yes I have and it dosen"t work

I have been looking for a way may date field to increase the date with each new record. Example for the first record the date field has the date of 01-jun-08 so when a new record is created the date will change to 08-jun-08 or vbSunday or +7. This is for secheduling purposes. Any...

Where would I place the Code? In the actural number field? In the Form?

How can I have a number field behave like the auto number function? I saw somewhere that through code you could have the number field increase each record by 1. Any ideas?

That has been tried and it still includes the $0.00. I feel that its a problem caused by the round to the next highest number feature in access. I am not sure what to do about this.

I am have trouble eliminating the $0.00 balances in a query. From what I can figure out is that even though the Balance appears as $0.00 in reality it could be anywhere from $0.0012 to $0.009 or something like that. What I am trying to do re reconcile the Balance field. If the balance reads...

What I eventually did was similiar to what suggested above. I created a Update Query and linked the TableA and TableB by the (Subject#) then in the Update To: I placed [TableA].[Date]. I attach Macro to the form to run the query on unload. This is working fine. Thanks for the suggestions.

I tried to use append but it didn't work. The problem is that the Date has to match the Subject# when the information is transfered.

How would I go about retrieving data from one table into another? One Table "A" has three fields "Subject#", "Subject" and " "Date" Another table "B" has a form attached that is used in scheduling these subjects with the same three fields mentioned above. (plus other fields that need not be...