Search results

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

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

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

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

Hi, I want to dsiable some of the choices on the file/View/edit memus. How do you do this. Thnaks, Maria

I want to check a form to see if the user has made any changes. This Chaeck has to take place when a cancel button or save button is pressed. I dont want the user to be propted if no changes have been made. Thnaks, Maria

Hi I have a feild with an error in it because it is empty. I want to write an if statement as follows: IIf(Total = error,0 ,Total) Does nyone know how to do this. Thanks, Maria

Hi I need Help. I can't seem to get the foolowing doce to work. I got it out of the Outlook 2002 book. I only have 2000. The whole thing works except getting the contact info from the contact folder. Anyone know how to do this in 2000. I would appreciate any help even a point in the right...

I don;t know if anyone here can help. I need to write a macro in Outlook that opens a document when a certain contact is selected. If anyone could help, point me in the right direction i would really appreciate it. Thnaks, Maria

How I have a report to print. There are about 100 lines. I want to skip a line every 5th line to make it easyier to read. How do i do this?

I want to a a carraige return a line on a query. EX: address1 & <CR> & Adress2 & <CR> & Address3 I want to do this so that when the report prints out it does not print empty lines. Please help thanks Maria

Hi,Can I open a word document using VBA. If I can how can I do this. Maria

Hi, I want to Check to see if a certain form is open. ex: If("MyForm" is open) then 'Do what ever end if I would appreciate any help. Thanks

Hi I Need to get the following statement to work. Set RST = db.OpenRecordset("Select * From [users]where [user]=" & Forms!usersignin!User) User in users is text. Please help.

Hi I Have the following statement and I cannot get it to work. Set Rec = DB.OpenRecordset("Select * From [Loan_Tbl]where Loan ID = Loan") Can I use a varriable to selct form a table. Thnaks, Maria

I have written a report and I do not want the zeros to show up. I tried using the IIF Statement but I kept getting errors. My statement: IIf([Sponsor]=0,"",[Sponsor]) I just get error. Sponsor is a dollar amount. Thanks