Search results for query: *

In the expression IIF([SSN]=50,99,[SSN]) when I enter 60, all works well. But if I enter 50, I get "The value entered doesn't meet the validation rule for the field or control". BTW SSN is defined iin a tabale as Number (long intiger). Any thoughts?

Is it safe to restore an entire backed up version of an Access database to the production version? Or is the best way to copy in only those objects from the backed up version to production? If I delete the production version first, then I would have to setup short cuts again for all users...

What is the cause and cure for this condition? I get a window that says "Could not find field 'Description'". The related error code is 3799. I had previously cloned a database and made changes to it. Somehow a table must have gotten corrupted. The error condition went away only when I...

Upon EXIT of a FORM, how do you validate a field NOT to be space? Thanks!

My query has a Percent to Totals calculation (w/ group by clause). The report that uses this query prints 3 columns (the item name, "number of rows", and Pct to Total). Now I want to add a Sum("number of rows") to the report footer but am getting "Multi-level group by clause is not allowed in...

If you try to compact a database you, receive the following error message: "Could not find field "Description" This was caused when I cloned/renamed an Access database then made changes to the clone. At the end of the day I compressed & repaired the ORIGINAL database and got this error. Only...

Can an Access Report read a date from a second table or is the query used to create the report the only place to add the date?

I can update a table (dates)in a form then click on a button to execute a query but the new dates in the table are NOT used with the query. If I close the form and re-enter, the dates are then used with the form. If I click the SAVE button the dates are NOT saved in the table to then be used...

Form1 searches table1 for a key. Go to Form2 and store key (not visible). Then read table2 using this key. If NO match, just enter new data and close Form2 to save to table2-this works ok. But if there IS a match, click on NEW Record icon at top of screen and enter new data-but this New...

I have successfully created a command button a form to do a search on a primary table for a key, entered data on the form and saved it into a second table. However the key for that second table does NOT get saved (but does show on the form). What happened?