Search results for query: *

Hi Vidru, On expert suggestion, I rebuilt the expression, and the above text worked... Thanks heaps for your help... Jenny.

Thanks Vidru, When I changed the code I got a runtime 91 error.. "Object variable or With Block Variable not set". What does this mean? How do I fix it with the following code? The third line is the problem.. Private Sub Image59_Click() 'Exporting to Word 'Defines report's format type...

I am currently viewing my crystal 9.0 reports through the ActiveX Viewer in Access2000. There is an export to pdf option which I wish to change to export to word doc. How do I go about it.. The pdf code is as follows: Private Sub Image47_Click() 'Exporting to PDF 'Defines report's format type...

Thanks for your quick reply.. I am using CR 9 to link to an access database. I have a customer request. Within that request they may may have a number of samples to have tests performed on. I want to raise an invoice based on an assigned cost to each of the tests performed on each of the...

Is there any way to summarize information in this way. I have different tests {Test.TestName} and test costs {Test.TestCost} in a laboratory database. What I want to do is show each test once, count the number of times it appears under a client request, take the maximum (no of units) and invoice...

Good Morning, I was wondering how to open a crystal report through access (if it can be done). I am using Access 2000 and CR 9. I can get Crystal to start up OK, but it won't open file type .rpt and CR 9 no longer has the compiler to create .exe for access to open. If anyone can help with...

Hi Jeremy, Not sure if I am applying this code properly.. I wish to filter all records with [FinishDate] = IsNull from a table [Samples]. When I enter the code "elect * from [Samples] WHERE [DateFinished] Is Null" in the criteria section of DateFinished, I get the following message...

Thanks Jeremy..

Just wondering if anyone knows how to set up a date field = IsNull query?

What is the difference between the two file types? Can I still modify the database in any way?

Could anyone please tell me how to get the database window to minimise. I have a switchboard and don't want most users to get into the main database window. Thanks..

Thanks DonDave.. very useful to know.

Access 2000

How do I get the switchboard to pop up upon opening the database? Any code to do so and suggestions on where it should be housed would be much appreciated.. Jenny.