Report Data Empty

[Adzi]

Hi,

I have developed a system for taking campsite bookings at work and the problem is that when the booking has been taken a report prints, basically the booking form containing all the details the customer has given.

The report now isnt printing and I cant figure out why.

The report data source is a query that takes the booking reference from a function. Using breakpoints I can see the function is running correctly but the query doesnt display the data and then the report doesnt display the data.

Any help is greatly appreciated as this was working yesterday but not today.

Cheers,
Adzi

 

[Rabbie]

Have you tried running "Compact and Repair" on your DB? Does this help?

Have you a back-up of your DB? Does this work?

If you still have problems then post a copy of your DB.

 

[Adzi]

The repair function didn't solve the problem and the backups arent working either - I was assured by a collegue that the backup was a previous version however the backup is a release of the most recent one... never trusting him again!!

There is the backend system containing all the tables and stores the data, the front end system is distributed to all the employees. Obviously I cant attach the backend because the data held in there is confidential and protected by the DPA.

I've attached a copy of the front end system.

Cheers,
Adam

 

[Adzi]

Call me an idiot!

I deleted part of a query that made the whole thing function - ooops!

Cheers,
Adam

 

[Rabbie]

Glad to hear you got it fixed.