Search results for query: *

It almost sounds like someone else has the db open (the icon will have a lock on it).

It appears that the size of the graphic is doing it. Look at Google but I believe that a GIF graphic has less colors therefore it should be a smaller size but I could be wrong. At anyrate use a smaller graphic to reduce the size of the file. Good luck!

Try using a smaller black/white gif file. Color takes a lot bigger size.

Yes, the update query would be one way to do this but I wanted to try using an expression on the SSN field of the form. It appears nobody uses this kind of update because nobody has told me how to do it. I initially thought using Validation Rules was where the expression is used but am now...

Yes, in a text box and update a table.

Well, if you put =IIf([SSN]=50,99,[SSN]) in Control Source for SSN, then you get a green edge on the SSN field (in design) and #ERROR on the SSN field after opening up the form. Any thoughts?

Well, SSN in this case is not social security number. I was trying to use the Expression Builder for the field to change 50 to 99. Can you tell me the correct code to enter in Expression Builder to do this?

So how do I edit the SSN field to change all 50 to 99? I almost feel that this edit should be put someplace else. If so where?

But I put the expression in the validation rule. Where should the expression be placed?

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?

Copy and rename to the drive = cloned

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!

I seem to sense that a "trashed" table can cause this problem but there may be other issues too.

Thanks,I'll try it.

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

That DLookup works GREAT!! Thanks!!

GingerR I've got a MS Access report with a file that feeds the query. Now, I want to read a file (only has one row) with beginning and ending date. Is there an easy way to do that rather than change the query (that has counts)?