Info for Invoice Disappeared

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on an invoice based on a report that has al the general stuff in
it: PO#, etc. The report is based on a select query from my inventory,
purchase Order, Employee, shipping, etc. tables. The query has a parameter in
the PO# field so that I can pull them up by PO#. The report was working until
I did a final save on the report and closed it. Now when I open the report,
the query does not seem to be pulling any info. The record source is still
correct in the Properties box, but no info. I have another report structured
this way that works reliably. How can I fix this? Any help is greatly
appreciated.
 
Does your query still work for a certain PO, but doesn't work for the same
PO in the report?

If it does work, how are you inputting the PO#? Do you just have a
standard query that produces a pop-up box asking for the PO, or do you have
the parameter pointing at a form control?
 
Hi, Thanks for your help. The answer is yes, the PO would show in its form,
but not in the report. I've managed to determine that the problem is actually
the query, but I've tried numerous times to even make new queries based on
the Purchase order table and it won't work. Sometimes strange parameter query
boxes for another table altogether will come up, other times it just shows me
an empty datasheet with the fields I've requested. I also cleared all of the
Row Source boxes in the Lookup page of the Design View, to no avail. I'm
afraid there's serious issues with my table properties. Any thoughts on that?
Thanks Again,
Aaron
 
Parameter queries for another table are showing up when you have a query
that's based solely on a separate table? That sounds like a serious
problem, and I have no idea why it should be happening. Do you have any
really odd relationships between these tables? Do you have any other query
that pulls from these 2 tables?

An empty datasheet just means that the query did not produce any results.
If it should have, there's something wrong with the query and the way it's
being put, or the information is not actually in your table. But the query
did run.

Is your db too big to email? I'd be glad to take a look at it.
 
I figured out that the parameters from the other table were being thrown up
by the report, which was looking for information to fill in the fields that
were from the other tables. (if that makes sense) I tried again to make a new
query based on my tables and then use it as the record source for the report
and this time it worked- the report and all- but I'm not sure how long it
will stay that way. I'm afraid the query is unstable or something. As far as
strange relationships, I don't think so, just pk to corresponding pk. This
database has been heavily modeled after Northwind and the other sample
databases. If I have trouble with it on Monday, I'd like to email it to you,
or try- I don't think that it is too big. I'll do that then. I really
appreciate your help! My email is (e-mail address removed) if you have any more
suggestions.
 
Queries aren't usually unstable - if it's pulling the right information,
the only thing that'll break it is giving it bad information.
But if you start piling queries on queries, which happens all the time, you
could start running into problems if they aren't talking well to each
other. Feel free to email it in a .zip file to (e-mail address removed)
if it goes kabloohey.
 
Back
Top