Re: DH Query By Form

Tech-Archive recommends: Speed Up your PC by fixing your registry

The table it references is <Customers>. There are 7 fields referenced,
all "Expr: [Company]" or some variation of that.

Removing the fields gives me an error saying the query must have at
least one destination field. Removing the table reference gives me the
error that I must have a table referenced.

I modified this query to reference my table, and then whatever fields I
include from my table show up in the report. However, none of the
filtering or sorting schemes I apply take any effect. I know I'm not
supposed to be editing the content of MyQuery, but I wanted to see what
would happen. Also, it's pretty apparent to me that whatever part of
the programming is supposed to be altering the content of MyQuery is
not doing that. I can change it manually and then run the applet many
times with many options, but the content seen in the design mode never
changes.

Katherine

Duane Hookom wrote:
Find the query "MyQuery" and see what it shows in design or data***.


--
Duane Hookom
MS Access MVP

"Katherine" <OatBoatBaBoatBoatMcBoatNut.Nog@xxxxxxxxx> wrote in message
news:1154638441.263781.27670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I did create my own queries. I have a query labeled <Mailing List
Test> that references a mailing list table in my db. I also deleted
all the records that were in QBFSource and QBFFields as the
instructions said.

I then went about designing a report in the applet by selecting
<Mailing List Test> as the Data Source and then selecting some of the
available fields to include. After doing all of this is when I get the
error I mentioned before. As far as I can tell, all the of the data
I'm asking the report to reference does not mention the Customers table
anywhere, only references things that are actually in my db, and yet
"Customers" is what it keeps asking for.

Is there something else I can try?

Katherine


Duane Hookom wrote:
Those un-needed tables were needed for the samples only. You need to
create
your own datasource queries so you could work with your data, not the
samples. Then delete the existing records from the QBFSource and
QBFFields
tables so you didn't see the samples. I believe there are a few
instructions
on creating your own datasources based on your tables.

Then create your own new report/queries.

Let me know if you need additional help.
--
Duane Hookom
MS Access MVP

"Katherine" <OatBoatBaBoatBoatMcBoatNut.Nog@xxxxxxxxx> wrote in message
news:1154627575.974860.256900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi,

So I downloaded the DH Query By Form mdb from Duane Hookom's library,
and I'm having some trouble getting it to work. I've imported
everything recommended into my own db and have followed the available
instructions in an attempt to create my own report.

After I've selected my query and the fields I'd like in my report, I
click the "Run Report/Query" button, and get the same error message
every time: "Error #: 3078 Error Description: The microsoft Jet
database engine could not find the input table or query 'Customers'.
Make sure it exists and that its name is spelled correctly."

I know this is one of the tables/queries from the sample database, and
yes, I didn't import the table into my database because the
instructions said it wasn't needed. (My guess is that somewhere in the
code, the string currently storing "Customers" is supposed to be
cleared, but it's not happening.) I've also tried importing everything
in the hopes that will fix the problem, but then when I click the Run
button I'm asked to specify results for fields from the Customer table
and my reports will only generate results from that table even after
selecting any other table or query instead.

I'm not sure what the problem is, but it's not letting me do any of my
own reports because it keeps looking for Customers. Is anyone else
having this problem? Can you please tell me how to solve it?

Thanks in advance,
Katherine



.

Quantcast