Search results

Printing Columns in a subreport Does anyone know how to print report that contains a subreport with the subreport printing in columns. When I originally set up the subreport, I set the page setup to 5-columns and it appeared fine. But when I added it to my report, the columns formatting does...

Weekday Thank, I kew it would be simple. I just could find it. Thanks for your time, Maria

Hi Is there a way to search for a day of the week. I don't care what the date is I just want to check to see if it is a Saturday or sunday. Thanks, Maria

thanks for helping Thank you for taking your time to help me. i still could not get it to work so I did it a different way. I made the fields transparent and put the company filed behind and changed the color if the company field in stead. so now I have several fields set = to the company...

Emailing with attached Private Sub Getlist() Dim stDocName As String Dim rsEmail As DAO.Recordset Dim strEmail As String stDocName = "ECNBCNVIPrpt" Set rsEmail = CurrentDb.OpenRecordset("EmailList") strEmail = rsEmail.Fields("EmailAddress").Value rsEmail.MoveNext Do While Not rsEmail.EOF...

Conditional Formatting Thank for responding! I tried that but it didn't do what I need. I will try to be clearer. I have written a program that grays out fields that cannot be edited. Problem: I have a continuous form that has different addresses in it. If there is a company name the...

Hi, 1 need to Change the color on 7 fields based on the value of one field. Basically if there is a company in the company field I need ti change the address field to a different color. Thnaks, Maria

Hi, I need Help. I have a File that is automatically created by another program. I need to get it in to a table in access. The only way I have found to do this is to first pull in in to excel then I can Automate it to pull in to access. I cannot figure out how to pull the file in to excel...

Text file is not in access The text file in not in access. For some reason When I import directly in to access all the information goes into one field. When I import into excel it goes into the proper fields.

I need to be able to do the following using access VBA: 1. Open excel 2. Import a text file 3. Save the file Any help would be appriecated. Thanks, Maria

Subreports without date All your fields ahave to have data to add them. Here is a way around it. exp1: IIf([Food Cash Sales ] is null,0,[Food Cash Sales]) This will fill the empty fileds with zeros if there is not amount. Maria

Reply to send emails Private Sub cmdSendMail_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("EmailList") Do While Not rsEmail.EOF strEmail = rsEmail.Fields("EmailAddress").Value DoCmd.SendObject , , , strEmail, , , "Test 3", "Hi", False...

Hide Addresses I am not sur if this can be done. I am not very good at outllook. I would just send the same email to all the people seperately. It would still work and it would be automated. Maria

Send one email at same time to all rivate Sub cmdSendMail_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("EmailList") strEmail = rsEmail.Fields("EmailAddress").Value rsemail.movenext Do While Not rsEmail.EOF strEmail = strEmail & " ; " &...

Reply Auto send emails Private Sub cmdSendMail_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String Set rsEmail = CurrentDb.OpenRecordset("EmailList") Do While Not rsEmail.EOF strEmail = rsEmail.Fields("EmailAddress").Value DoCmd.SendObject , , , strEmail, , , "Test 3", "Hi", False...

I am trying to import a text file The file is not consistant i any way. I would like to import it into one field and then got through it line by line (W/VBA) and assign it to the proper field. Each line is to ling to a memo field. How can I do this. Thanks, Maria

I already answer my own question Thanks, anyway

I am trying to create an email and send it automatically. I can set it up with all the information, but I cannot get it to send. Thanks Maria

Hi I am Trying to get rid of the the pop up message that says: Not found in list. Any one know how to get rid of it. I wrote in the notonlist event code to add the entry to the list so it is in the list but the message still. Thank you, maria

Hi I am trying to get rid of the not in list pop up box. i have written the following code to handle not in this but at the end of the code not matter what I seems to do the Messege box Not In list shows up. Me!Compid = Null StrInput = InputBox("Enter a New Company Name") Comp.AddNew...