Search results

I was unable to view your attachment, I got the following error: "Unrecognized database format"

Here's my situation, I have Access 97 I have a form that users update, but they continue to leave this one field blank and I have to go behind them to enter this date. Field Name: OrigProcDt This is a date field I don't want this field to be a required field in the table, because it won't...

Is there a way to make certain fields within a form required fields, I don't want to make them required on the TABLE, just the form. I have a problem with certain individuals leaving certain fields blank when they update a form and I need it to stop. Any help would be appreciated.

Scenario: A claim is sent to processing today 6/17/04 and we need to follow-up in 7 days to make sure it was completed. How can this information be stored in the table, so that a query can be run at a later date that displays all the records that are 7 days are older, just in case we don't...

What about... I have a similar situation. Balance Adj Reductions Less fee credits (amount we pay the vendor) Savings (amount we'd like to auto calculate if possible) I tried to run a query but it returned no results, even though I had 8 records that met the criteria. I placed the formula in...

We use the email system to send requests by form when sending to another department. Can this form system be used to automatically log the data into an Access database. I am not a tech person, so please try and explain it as simple as possible. Any help would be appreciated. The ultimate...

any existing database, it won't let me create a new database (crashes)

Msaccess will now close... This is happening when I try to create a new form, query or report as well as trying to import data. Do I need to remove Access and reinstall it? I have Access 97, please help, thanks

One problem though, we update several records before we close a form, would it go back and convert all of them when we close the form?

I have a form that has two text boxes. We want the data entered in these text boxes to be in ALL CAPS. I entered an Input Mask, however, there is a limit of 250 characters for a mask, even though these are Memo fields and can have more than 250 characters entered in these boxes when the masks...

Still no answer yet

Insert key doesn't make a difference, toggled on or off...

I have a problem that I need help with. When I go to edit data within a field, example, to fix a mis-spelled word, it won't let me insert the data, I have to re-type all the information to the right of where I am making my correction. Example: This is the incorect information entered in the...

Access '97 - Is there a way to track the amount of work completed by an individual. I have about 10 users and the Auditing Department wants to know how many records were updated the previous day and if those records updated can be listed somehow. I said that I would ask, so here you go!

I am having a problem with the way the entered data is displaying in my text box. Here is an example below: The Insured called and asked why did we deny her claim. The entered text will move to the next line automatically when there is plenty of space left on the previous line. I have set...

Thanks, it's working perfectly now.

Query - filtering out specific data I have created a query that contains information received within the 4th qtr of 2003. However, I also need to filter out specific data from another field. Example: under the received date I have the criteria set as: Between #10/1/03# and #12/31/03# Under...

I get a Compile error: Expected list separator or ) This happens at "tblClaims" How exact do I have to be with the spaces and commas and quotation marks?

I have set up a database that doesn't allow Duplicate Claim#'s and when our users are entering new Claim#'s in their forms, it doesn't notify them that they are Duplicate Claim#'s until they have completed filling in all of the form. This is wasting valuable production time. I want to know HOW...