Report Troubles

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

Guest

I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the query in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view, how
to keep the dialog box from opening and how to get the info from the query in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
 
Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.
 
This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there. If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

PC Datasheet said:
Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the query in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view, how
to keep the dialog box from opening and how to get the info from the query in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
 
You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there. If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

PC Datasheet said:
Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The query
shows up in datasheet view. I don't want this. Immediatly upon the
Click to expand...
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
Click to expand...
view,
how
to keep the dialog box from opening and how to get the info from the
Click to expand...
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


PC Datasheet said:
You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there. If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

PC Datasheet said:
Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from which you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose from
the combo box then I click the command button and the query runs. The
query
shows up in datasheet view. I don't want this. Immediatly upon the query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view,
how
to keep the dialog box from opening and how to get the info from the query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




AJ said:
Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


PC Datasheet said:
You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits
Click to expand...
there.
If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from
Click to expand...
which
you
select your query from a drop list. Then on the form is a command button
that you click to run the query.

When I open the report the form opens just as I want it. I can
Click to expand...
chose
from
the combo box then I click the command button and the query runs. The
query
shows up in datasheet view. I don't want this. Immediatly upon
Click to expand...
the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter
Click to expand...
here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet view,
how
to keep the dialog box from opening and how to get the info from
Click to expand...
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.



PC Datasheet said:
In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




AJ said:
Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


PC Datasheet said:
You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The Report is
opening the dialog box. I select the name I want and it just sits there.
If
I hit enter then I get an error. I double checked, I do have in teh after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I can chose
from
the combo box then I click the command button and the query runs. The
query
shows up in datasheet view. I don't want this. Immediatly upon the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info from the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.



PC Datasheet said:
In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




AJ said:
Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that shows
up correlates to the primary key in the table that generates the list. How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The
Click to expand...
Report
is
opening the dialog box. I select the name I want and it just sits there.
If
I hit enter then I get an error. I double checked, I do have in
Click to expand...
teh
after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I
Click to expand...
can
chose
from
the combo box then I click the command button and the query
Click to expand...
runs.
The
query
shows up in datasheet view. I don't want this. Immediatly
Click to expand...
upon
the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info
Click to expand...
from
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
Would this work better if I zipped up the database and sent it to you?

PC Datasheet said:
Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.



PC Datasheet said:
In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that
shows
up correlates to the primary key in the table that generates the list.
How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox
correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The Report
is
opening the dialog box. I select the name I want and it just sits
there.
If
I hit enter then I get an error. I double checked, I do have in teh
after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from
which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I can
chose
from
the combo box then I click the command button and the query runs.
The
query
shows up in datasheet view. I don't want this. Immediatly upon
the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter
here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info from
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
ID
Name
ID #
email address

PC Datasheet said:
Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.



PC Datasheet said:
In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name I want,
but then I get the error messace that "Record Source '1' spcidied on this
report or form does not exists. What is happening is the number that
shows
up correlates to the primary key in the table that generates the list.
How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox
correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The Report
is
opening the dialog box. I select the name I want and it just sits
there.
If
I hit enter then I get an error. I double checked, I do have in teh
after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from
which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it. I can
chose
from
the combo box then I click the command button and the query runs.
The
query
shows up in datasheet view. I don't want this. Immediatly upon
the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter
here
and no
matter what I do the report opens without the info from the query.

So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the info from
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
From your original post:
.....form from which you select your query from a drop list. Then on the
form is a command button that you click to run the query.

The fields you list here have nothing to do with a list of queries! How are
we suppose to communicate when you don't seem to be talking about your
actual problem?????

AJ said:
ID
Name
ID #
email address

PC Datasheet said:
Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


AJ said:
now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.



:

In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Thanks and hopefully this is the last problem. The record source isn't
working properly.

When I open the report the form pops up correct, I select the name
Click to expand...
I
want,
but then I get the error messace that "Record Source '1' spcidied
Click to expand...
on
this
report or form does not exists. What is happening is the number that
shows
up correlates to the primary key in the table that generates the list.
How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox
correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The Report
is
opening the dialog box. I select the name I want and it just sits
there.
If
I hit enter then I get an error. I double checked, I do have
Click to expand...
in
teh
after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from
which
you
select your query from a drop list. Then on the form is a command
button
that you click to run the query.

When I open the report the form opens just as I want it.
Click to expand...
I
can
chose
from
the combo box then I click the command button and the
Click to expand...
query
runs.
The
query
shows up in datasheet view. I don't want this.
Click to expand...
Immediatly
upon
the
query
in
datasheet view showing up on the screen a dialog box opens with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter
here
and no
matter what I do the report opens without the info from
Click to expand...
the
query.
So, I need to know how to not have the query show up in datasheet
view,
how
to keep the dialog box from opening and how to get the
Click to expand...
info
from
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
I don't see a need to get ugly. If I knew what I was doing I wouldn't be in
here needing help. I listed the fields in the table that the form is pulling
from the combo box. I apologize if this was not the table you were referring
too. If I made any mistake I apologize. I simply did not know which table
you were referring to.

Here are the fields in the table the query and report are pulling from:
QI#
Issue Date
Rejection Type
Dept Identified
Identified By
Part #
Customer
Shade
Batch Code
Reject Qty
Units
Production Date
MO#
Qty Sampled
# of Defects
Reject Reason
Accepted By
Accept Date
QA Review
Returned
Released
Closed
Rework
Scrap
RW#
QA manager Approval
QA manager APproval Date
Return Date
Approval Date
Materials
Method
Manpower
Machine
Immediate Corrective Actions
Permanent Corrective Actions
Completed by
Lot Size
Lot Size Units
ResourcesNeeded 1
Resources Needed 2
Resources Needed 3
Resources Needed 4
Resources Needed 5
QI Type
Corrective Actions Accepted
Rework APproval 3
Rework Procedure
Rework APproval 1
Rework Approval 2
Department to Rework
Rework Approval Date
Team Leader
Corrective Actions Complete
Returned to Vendor

Hopefully this is the correct table you are requesting.

PC Datasheet said:
From your original post:
.....form from which you select your query from a drop list. Then on the
form is a command button that you click to run the query.

The fields you list here have nothing to do with a list of queries! How are
we suppose to communicate when you don't seem to be talking about your
actual problem?????

AJ said:
ID
Name
ID #
email address

PC Datasheet said:
Post back with the list of fields in your table in the exact order they are
in your table.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


now it is the same error execpt it actually has the name instead of the
number. I went and opened the query, to get it to run I have to have the
number else I get an error there too. the query wants the number, but the
form is selecting the name.



:

In the code in the report's Open event, Change this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
to this:
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9].Column(1)

If that does not work yet, post back with the list of fields in your
table
in the exact order they are in your table.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com




Thanks and hopefully this is the last problem. The record source
isn't
working properly.

When I open the report the form pops up correct, I select the name I
want,
but then I get the error messace that "Record Source '1' spcidied on
this
report or form does not exists. What is happening is the number that
shows
up correlates to the primary key in the table that generates the list.
How
do I get this to link to the name field, not the primary number field.

I do appreciate your help, thanks!


:

You need to delete the Enter button.

You apparently did not code the AfterUpdate event of the combobox
correctly
or your dialog form would disappear when you made a selection.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


This helped alot thanks. Just one problem at this point. The
Report
is
opening the dialog box. I select the name I want and it just sits
there.
If
I hit enter then I get an error. I double checked, I do have in
teh
after
update event just as you said Me.Visible = False.

thanks so much for your help.

:

Put the following code in the Open event of the report:
DoCmd.OpenForm "frmQueryforTeamLeaderreport",,,,,acDialog
Me.Recordsource = forms![frmQueryforTeamLeaderreport]![Combo9]
DoCmd.Close acForm, "frmQueryforTeamLeaderreport"

Put the following code in the AfterUpdate event of the combobox:
Me.Visible = False

Delete the button and its code on frmQueryforTeamLeaderreport.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


I have a report that is set up to immediately open a form from
which
you
select your query from a drop list. Then on the form is a
command
button
that you click to run the query.

When I open the report the form opens just as I want it. I
can
chose
from
the combo box then I click the command button and the query
runs.
The
query
shows up in datasheet view. I don't want this. Immediatly
upon
the
query
in
datasheet view showing up on the screen a dialog box opens
with
"forms![frmQueryforTeamLeaderreport]![Combo9] I have to enter
here
and no
matter what I do the report opens without the info from the
query.

So, I need to know how to not have the query show up in
datasheet
view,
how
to keep the dialog box from opening and how to get the info
from
the
query
in
the report. (the report is set up to pull from that query).

thanks for any help you can give.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top