DH Query By Form

  • Thread starter Thread starter Katherine
  • Start date Start date
K

Katherine

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
 
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.
 
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
 
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
 
It seems like some code isn't running. Did you set a reference to the DAO
object library within the code?
Do you have the code option set to break on unhandled errors?
Are you getting any other errors after clicking the Run Report button?

--
Duane Hookom
MS Access MVP

Katherine said:
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
Click to expand...
 
Duane,

I didn't change anything in the code before trying to run it, and I
still haven't. Are these things you mentioned things that I should try
changing? I may go in and do that just so I can see what happens, but
I haven't had the chance yet. I'll let you know what happens.

Katherine

Duane said:
It seems like some code isn't running. Did you set a reference to the DAO
object library within the code?
Do you have the code option set to break on unhandled errors?
Are you getting any other errors after clicking the Run Report button?

--
Duane Hookom
MS Access MVP

Katherine said:
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 said:
Find the query "MyQuery" and see what it shows in design or datasheet.


--
Duane Hookom
MS Access MVP

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

message
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
Click to expand...
Click to expand...
Click to expand...
 
I'm not sure what is happening. There is DAO code in the click event of the
run report that loops through a recordset clone of the subform and builds a
SQL statement. The SQL statement is then place in the SQL property of the
query "MyQuery". Then a form opens and sets the Source Object of the subform
control to the query.

--
Duane Hookom
MS Access MVP

Katherine said:
Duane,

I didn't change anything in the code before trying to run it, and I
still haven't. Are these things you mentioned things that I should try
changing? I may go in and do that just so I can see what happens, but
I haven't had the chance yet. I'll let you know what happens.

Katherine

Duane said:
It seems like some code isn't running. Did you set a reference to the DAO
object library within the code?
Do you have the code option set to break on unhandled errors?
Are you getting any other errors after clicking the Run Report button?

--
Duane Hookom
MS Access MVP

Katherine said:
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 datasheet.


--
Duane Hookom
MS Access MVP

message
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

message
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
Click to expand...
Click to expand...
Click to expand...
 
I just sat down to open up the code and see what I could come up with,
but, for whatever reason, it works today. I haven't touched it since
Thursday when it didn't work at all, and now everything's working just
as it should. I have no idea what happened.

Thanks for all your help, and I'm so glad it's working now! It seems
like exactly what I've been looking for. Sorry if I caused you any
headaches.

-Katherine

Duane said:
I'm not sure what is happening. There is DAO code in the click event of the
run report that loops through a recordset clone of the subform and builds a
SQL statement. The SQL statement is then place in the SQL property of the
query "MyQuery". Then a form opens and sets the Source Object of the subform
control to the query.

--
Duane Hookom
MS Access MVP

Katherine said:
Duane,

I didn't change anything in the code before trying to run it, and I
still haven't. Are these things you mentioned things that I should try
changing? I may go in and do that just so I can see what happens, but
I haven't had the chance yet. I'll let you know what happens.

Katherine

Duane said:
It seems like some code isn't running. Did you set a reference to the DAO
object library within the code?
Do you have the code option set to break on unhandled errors?
Are you getting any other errors after clicking the Run Report button?

--
Duane Hookom
MS Access MVP

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 datasheet.


--
Duane Hookom
MS Access MVP

message
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

message
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top