Recent content by JJT

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