Search results for query: *

Karl, I ran into the same problem (or one that sounds similar) a while back and here's the problem. Your database sounds like it's corrupted. 1. Close your database 2. Open a new blank database. 3. Choose "Get External Data" from the File Menu 4. Import your old database into the...

Anybody know how to invoke acrobat reader with command line switches. (I am trying to create an MS Access Form that will open a PDF File) Note: Putting in the name of the PDF File does NOT work. Access must use an executable path. Thanks in advance.

Hi, Fixed that problem by using a =iserror function on the master form. I created two controls, one that returned an 0 or -1 based on whether one control was an error. The other control used an if statement to pull values from two different controls based on the iserror statement. Thanks for...

FYI, It happened again. I called MS Tech support and they diagnosed it as a form corrpution. I exported the database into a new "Container" by giving it a new name and this filtered any corrupt files. Thanks, Grant.

Wait - It came back. I'm not sure what I did but I guess praying (interspersed with swearing) did the trick. Grant.

Yesterday I set up a query to run based on input from a form: Parameter: [Forms]![Decoder]![Option1] The query worked yesterday, but today, the query is now asking for the parameter, even though the form is open with data in the combo box. What could have caused this. Note: I've checked...

Michael, That answer makes total sense. However, I can't find any reference or instruction on HOW to check the recordcount property of the query. I thank you all for the help. Grant.

Thanks for the info. I did leave out the extra 'I' in the iif statement when I wrote my post, but I had it in the actual statement. I tried using the NZ function but got the same result anyway. Basically, how do you return 0 if the query returns no results. Maybe I'm going about it the...

Here's what I tried, but I still keep getting a blank field when I run the form: =if(Sum([price])=Null,0,Sum([price])) I keep thinking that it has to do with the format of the field, but it seems not to work. Thanks.

I need help with a continuous form. I want the subtotal in the form footer to read $0.00 if the query returns no results.Currently the total is blank when the query returns no results. How do I fix this (I want to use the subtotal later on a master form) Thanks in advance.