Question Query NOT working after compact and repair

[naym]

I there,

I have just come across this problem recently. I have a Ms access epos programme and when changing it to a new takeaway i have deleted the data and compacted and repaired the database but now the problem is the query for printing a receipt is not working all its showing is nothing at all.

Any help on this would be much appreciated guys.

Regards

Naym

 

[dpw204]

Some thoughts: If you 'deleted the data' - could it be that the query is working - just that now there is no data to report?

- Is this a multi-table query? Perhaps a join is now failing because an expected link is now coming back empty? Perhaps changing the join-type might help?

- Is this part of a form/vba operation, or just a straight up interactive use of a query?
If on a form, try stepping through the VBA (F8) to see where things go wrong.

Good Luck

 

[naym]

Hi Dpw204,

Thank you for the reply, no I havent deleted the data, the data is basically details of an order which then prints out a reciept based on a order query.

I think I have managed to solve the problem, also on the query was another table field called reciept message which a user can write to have his message on the query reciept when i delted the message in table view i think the query was not understanding, after i filled the field the query started working fine again.

Learn something new every day but thank you for your comment.