Search results

Thanks For your help.

Thanks for you help.

Hello. Is there a way of setting up my database so that Access will automatically send me a e-mail or an alert when a field reaches a certain value? Thanks

How are you? I would like to change the format of a date on a report. The current format is =NOW() which gives me 2/24/2004 9:10:58 AM I want to change it to February 24, 2004. What do I have to do to make the change? Thanks

Thanks. The "between" function worked. Another question! In the same query I also need the records where the "code" is TO or PR or GA.

Help......I have a query where I need to select records within a date range: Equal to or Greater Than 8/1/2002 and Less Than or Equal to 7/31/2003. I tried " >=#8/1/2002# and <=7/31/2003", but get all the records in the table. Thanks

Yes. I did not get your example.

Hello. I have a table in which some of the records have the same info in the "Name" field. Is it possible to create a Make Table Query that will not select any records with duplicate info in the "Name" field?

Is there a way to enter a table data selection criteria from within a Report without using a Query? Thanks....much

Update Tbale The first two fields are empty. They need to be filled with the Date and Desc from the first record in the series.

Hello. I have a table with 8 fields and 3,500 records. Each record will always have data in all but two fields: Date and Desc. Example: Date - Desc - Month - Number- ...... 1/1/02 - AMT - June - 850 - June - 850 - June - 850...

I'd like to put 5 checkboxes on my form. Each time one box is selected, a predefined message will be put into a text or memo field. Thanks very much

Is there a way for Access to send out an e-mail messase reminder when the current date = reorder date? Thanks...much

I need help with the following: If TYPE = c THEN NEWDATE = DATE + 15 ELSE DATE = DATE + 30 Thanks....much

I have 15 pre defined text messages. I want to be able display any one of them in a field based upon the checkbox that is selected. Example: If I select checkbox1, "this is a good day" will be inserted into a text field1 If I select checkbox2, "this is a not good day" will be inserted into a...

I have a table with a name field which contains the full name of a customer. I need to separate the name field into first name and last name fields. Any suggetions on a query that wil do that for me? The full name field looks like this: Joe Smith Thanks...much.

I have field1 containing the following: X400:c=US;a= ;p=DCF;o=REGION1;s=MBAKSAY;%SMTP:fname.lname@PO.STATE.CT.US I need to be able to create a new field2 which will always contain the information between the ";%" and the ".US". Help..please. Thanks

Is there a way of sending the the result of my Access query to an Excel spreadsheeet ?

Can someone help me. I need to combine the fields from 3 different tables onto the same form. Thanks

I have a table with 7,000 records with fields Worksite and Category. Half of the records have data in the Worksite field, the other half has no data. What is the Update query that will enable me replace the empty Worksite fields with the word "Used". Thanks...much.