Search results for query: *

Thanks for the tip! Unfortunately Val, didn't work "out of the box" because result values of zero (0.00) returned the same as text values, but I figured out how to spot string characters in the result. Duh: [ReplicateValue] Like ("*[!0-9,.]*")

I am working on a database that has result values for testing stored as a string. The actual result can be either a string "Pass/Fail" or a number. This has been working fine until when I'm making reports. I have a reports form which allows a user to enter a value and the choose comparison...

just a thought, if it is a print driver issue, do you think setting the layout for print property to no will help?

The print driver thing sounds like a promising lead. The queries don't produce the crash when opened in a form or when opened by themselves. Additionally the reports crash opening them in design view too. BTW, what kind of printer was causing the problem. In my case, it may be our HP-4650.

Well, maybe I should give a little more info. This is an example of the type of thing i'm doing, but there are lots of variations on this in this project. The main form displays infor for an analytical lab sample. contained in the main form is a subform that displays info on each test...

I have an audit trail/electronic signature/ undo feature built built with VBA into my Access forms. It runs on the BeforeUpdate event of the main form. The problem I am having though is that I do not want the audit trail stuff to fire when i am simply moving the focus from the main form to a...

I have developed several databases in Access 97 (my employer doesn't want to upgrade because of conversion issues). While running these databases under both WIN2k and XP I have a probelm with the appilcation closing when I open a report (it comes up with an "Send error report?" dialog and then...

I'm setting up several secured databases to be shared over a netwrok. For people to log in using a user name from the system.mdw, i've had to set up separate shortcuts for each person, because access seems to be installed in different directories on several machines. I want to be able to use a...

If it helps at all, I also get this error when trying to open a report in design view as well.

I have developed several databases in Access 97 (my employer doesn't want to upgrade because of conversion issues). While running these databases under both WIN2k and XP I have a probelm with the appilcation closing when I open a report (it comes up with an "Send error report?" dialog and then...