Search results

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

Thanks to everyone for there help. The using of Time() solved the problem. Thanks once more.

Thanks for everyone help. I have experimented with the Timer and I am confident that this is the way to go. I am experiencing a problem with the code part. e.g. I would like the database to be turned off lets say every night at 8:00 PM. By that time everyone is out of the office. But as...

Thanks for all the ideas. I need a little more clarification on how to code the AutoExec fucntion. And how to code the time for example shut people out after 5:30pm. Thank for the help thus far

How can I stop agents from leaving a database open after they have finished there days work. I maintain and modify a database from home, but some agents forget to close the database at the end of the day. That prevents me from doing any modification on the database. Maybe a simple message...

Perhaps I sould clairfy it a little more. What we need is some way to filter many fields that will reflect an evaluation or assement of the person...the male and female was just part of a list of options that would be clicked Yes/No. It could be likened to form that you would list various...