Update a Report

  • Thread starter Thread starter RMires
  • Start date Start date
Kunal,

Okay then the only thing left to check is the Print Commnad... I assume you
used a Command Button. Please look at the Command Button and tell me what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just want to
print data related to that particular JobID which is shown on the Fom...

Mi form is always open as that print command is on the form itself... so I
click the print button and it prints all data one by one...

Gina Whipp said:
Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same then I
restate
my request. Please type your Macro actions here so we can look and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the Print
Command
on
the Form. But I think its the Macros where condition which is having
trouble... The condition which I pasted before is the one I copied
from
one
of the Templet I downloaded from Microsoft Website. Their Database
is
more
complicated than mine... and it does work there but not with mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help if you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hello John,

My database have got 3 tables, they have no relationships. First
table
is
the one which captures all the main data off the form. 2nd & 3rd
tables
are
just to fillup the 'Combo Box'. A single form on which all the
data
are
entred and calculated.

So according to this scenario I think the best reply would be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed in my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to the
'JobID'
specified
on the form through a click of the button... My Macro condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work... it
prints
all
the records...

Please post your actual code. What's the Recordsource of the
report?
--

John W. Vinson [MVP]
.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Gina,

The On Click event didnt had anything when I created the command button
through the wizard in which I defined wat report I want to print... so I
opened mi form and and defined the event as the Print Macro which we made...

Do you think it could b a problem wit the record source of the Report... it
just struck in mi mind tat the record source of the report is the Table...
and not the Form...???

Regards,

Kunal.

Gina Whipp said:
Kunal,

Okay then the only thing left to check is the Print Commnad... I assume you
used a Command Button. Please look at the Command Button and tell me what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just want to
print data related to that particular JobID which is shown on the Fom...

Mi form is always open as that print command is on the form itself... so I
click the print button and it prints all data one by one...

Gina Whipp said:
Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same then I
restate
my request. Please type your Macro actions here so we can look and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the Print
Command
on
the Form. But I think its the Macros where condition which is having
trouble... The condition which I pasted before is the one I copied
from
one
of the Templet I downloaded from Microsoft Website. Their Database
is
more
complicated than mine... and it does work there but not with mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help if you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hello John,

My database have got 3 tables, they have no relationships. First
table
is
the one which captures all the main data off the form. 2nd & 3rd
tables
are
just to fillup the 'Combo Box'. A single form on which all the
data
are
entred and calculated.

So according to this scenario I think the best reply would be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed in my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to the
'JobID'
specified
on the form through a click of the button... My Macro condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work... it
prints
all
the records...

Please post your actual code. What's the Recordsource of the
report?
--

John W. Vinson [MVP]
.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Kunal,

What is the RecordSOucre of the report and what is the RecordSource of the
form? Also, did you type in the name of the Macro or select it from a drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Gina,

The On Click event didnt had anything when I created the command button
through the wizard in which I defined wat report I want to print... so I
opened mi form and and defined the event as the Print Macro which we
made...

Do you think it could b a problem wit the record source of the Report...
it
just struck in mi mind tat the record source of the report is the Table...
and not the Form...???

Regards,

Kunal.

Gina Whipp said:
Kunal,

Okay then the only thing left to check is the Print Commnad... I assume
you
used a Command Button. Please look at the Command Button and tell me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just want
to
print data related to that particular JobID which is shown on the
Fom...

Mi form is always open as that print command is on the form itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same then I
restate
my request. Please type your Macro actions here so we can look and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the Print
Command
on
the Form. But I think its the Macros where condition which is
having
trouble... The condition which I pasted before is the one I
copied
from
one
of the Templet I downloaded from Microsoft Website. Their
Database
is
more
complicated than mine... and it does work there but not with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help if you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Hello John,

My database have got 3 tables, they have no relationships.
First
table
is
the one which captures all the main data off the form. 2nd &
3rd
tables
are
just to fillup the 'Combo Box'. A single form on which all the
data
are
entred and calculated.

So according to this scenario I think the best reply would be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed in my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to the
'JobID'
specified
on the form through a click of the button... My Macro
condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work...
it
prints
all
the records...

Please post your actual code. What's the Recordsource of the
report?
--

John W. Vinson [MVP]
.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Gina,

Record Source for both Form and Report is same "Quote" which is the 'First
Table' I selected the Macro from the Dropdown list. I am using Access 2003

Gina Whipp said:
Kunal,

What is the RecordSOucre of the report and what is the RecordSource of the
form? Also, did you type in the name of the Macro or select it from a drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Gina,

The On Click event didnt had anything when I created the command button
through the wizard in which I defined wat report I want to print... so I
opened mi form and and defined the event as the Print Macro which we
made...

Do you think it could b a problem wit the record source of the Report...
it
just struck in mi mind tat the record source of the report is the Table...
and not the Form...???

Regards,

Kunal.

Gina Whipp said:
Kunal,

Okay then the only thing left to check is the Print Commnad... I assume
you
used a Command Button. Please look at the Command Button and tell me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just want
to
print data related to that particular JobID which is shown on the
Fom...

Mi form is always open as that print command is on the form itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same then I
restate
my request. Please type your Macro actions here so we can look and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the Print
Command
on
the Form. But I think its the Macros where condition which is
having
trouble... The condition which I pasted before is the one I
copied
from
one
of the Templet I downloaded from Microsoft Website. Their
Database
is
more
complicated than mine... and it does work there but not with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help if you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Hello John,

My database have got 3 tables, they have no relationships.
First
table
is
the one which captures all the main data off the form. 2nd &
3rd
tables
are
just to fillup the 'Combo Box'. A single form on which all the
data
are
entred and calculated.

So according to this scenario I think the best reply would be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed in my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to the
'JobID'
specified
on the form through a click of the button... My Macro
condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent work...
it
prints
all
the records...

Please post your actual code. What's the Recordsource of the
report?
--

John W. Vinson [MVP]
.



.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Kunal,

Then the RecordSource is not the problem. Is the field JobID on the form
and can you confirm that that is the field name?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Gina,

Record Source for both Form and Report is same "Quote" which is the 'First
Table' I selected the Macro from the Dropdown list. I am using Access 2003

Gina Whipp said:
Kunal,

What is the RecordSOucre of the report and what is the RecordSource of
the
form? Also, did you type in the name of the Macro or select it from a
drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

The On Click event didnt had anything when I created the command button
through the wizard in which I defined wat report I want to print... so
I
opened mi form and and defined the event as the Print Macro which we
made...

Do you think it could b a problem wit the record source of the
Report...
it
just struck in mi mind tat the record source of the report is the
Table...
and not the Form...???

Regards,

Kunal.

:

Kunal,

Okay then the only thing left to check is the Print Commnad... I
assume
you
used a Command Button. Please look at the Command Button and tell me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just
want
to
print data related to that particular JobID which is shown on the
Fom...

Mi form is always open as that print command is on the form
itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same then
I
restate
my request. Please type your Macro actions here so we can look
and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the
Print
Command
on
the Form. But I think its the Macros where condition which is
having
trouble... The condition which I pasted before is the one I
copied
from
one
of the Templet I downloaded from Microsoft Website. Their
Database
is
more
complicated than mine... and it does work there but not with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help if
you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hello John,

My database have got 3 tables, they have no relationships.
First
table
is
the one which captures all the main data off the form. 2nd
&
3rd
tables
are
just to fillup the 'Combo Box'. A single form on which all
the
data
are
entred and calculated.

So according to this scenario I think the best reply would
be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed in
my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to the
'JobID'
specified
on the form through a click of the button... My Macro
condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent
work...
it
prints
all
the records...

Please post your actual code. What's the Recordsource of
the
report?
--

John W. Vinson [MVP]
.



.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Gina,

Yes that part is correct as well...!!!

Kunal.

Gina Whipp said:
Kunal,

Then the RecordSource is not the problem. Is the field JobID on the form
and can you confirm that that is the field name?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Gina,

Record Source for both Form and Report is same "Quote" which is the 'First
Table' I selected the Macro from the Dropdown list. I am using Access 2003

Gina Whipp said:
Kunal,

What is the RecordSOucre of the report and what is the RecordSource of
the
form? Also, did you type in the name of the Macro or select it from a
drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

The On Click event didnt had anything when I created the command button
through the wizard in which I defined wat report I want to print... so
I
opened mi form and and defined the event as the Print Macro which we
made...

Do you think it could b a problem wit the record source of the
Report...
it
just struck in mi mind tat the record source of the report is the
Table...
and not the Form...???

Regards,

Kunal.

:

Kunal,

Okay then the only thing left to check is the Print Commnad... I
assume
you
used a Command Button. Please look at the Command Button and tell me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just
want
to
print data related to that particular JobID which is shown on the
Fom...

Mi form is always open as that print command is on the form
itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same then
I
restate
my request. Please type your Macro actions here so we can look
and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the
Print
Command
on
the Form. But I think its the Macros where condition which is
having
trouble... The condition which I pasted before is the one I
copied
from
one
of the Templet I downloaded from Microsoft Website. Their
Database
is
more
complicated than mine... and it does work there but not with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help if
you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hello John,

My database have got 3 tables, they have no relationships.
First
table
is
the one which captures all the main data off the form. 2nd
&
3rd
tables
are
just to fillup the 'Combo Box'. A single form on which all
the
data
are
entred and calculated.

So according to this scenario I think the best reply would
be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed in
my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to the
'JobID'
specified
on the form through a click of the button... My Macro
condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent
work...
it
prints
all
the records...

Please post your actual code. What's the Recordsource of
the
report?
--

John W. Vinson [MVP]
.



.



.



.



.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Kunal,

Now, I'm stumped because everything you have confirmed *appears* correct so
the report should filter and not show all the records. Is the database in a
state where you can send it to me?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Gina,

Yes that part is correct as well...!!!

Kunal.

Gina Whipp said:
Kunal,

Then the RecordSource is not the problem. Is the field JobID on the form
and can you confirm that that is the field name?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Record Source for both Form and Report is same "Quote" which is the
'First
Table' I selected the Macro from the Dropdown list. I am using Access
2003

:

Kunal,

What is the RecordSOucre of the report and what is the RecordSource of
the
form? Also, did you type in the name of the Macro or select it from a
drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

The On Click event didnt had anything when I created the command
button
through the wizard in which I defined wat report I want to print...
so
I
opened mi form and and defined the event as the Print Macro which we
made...

Do you think it could b a problem wit the record source of the
Report...
it
just struck in mi mind tat the record source of the report is the
Table...
and not the Form...???

Regards,

Kunal.

:

Kunal,

Okay then the only thing left to check is the Print Commnad... I
assume
you
used a Command Button. Please look at the Command Button and tell
me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just
want
to
print data related to that particular JobID which is shown on the
Fom...

Mi form is always open as that print command is on the form
itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same
then
I
restate
my request. Please type your Macro actions here so we can
look
and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the
Print
Command
on
the Form. But I think its the Macros where condition which
is
having
trouble... The condition which I pasted before is the one I
copied
from
one
of the Templet I downloaded from Microsoft Website. Their
Database
is
more
complicated than mine... and it does work there but not
with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help
if
you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hello John,

My database have got 3 tables, they have no
relationships.
First
table
is
the one which captures all the main data off the form.
2nd
&
3rd
tables
are
just to fillup the 'Combo Box'. A single form on which
all
the
data
are
entred and calculated.

So according to this scenario I think the best reply
would
be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed
in
my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,

I m havin trouble generating the report according to
the
'JobID'
specified
on the form through a click of the button... My Macro
condition
states
tis
"[JobID]=[Forms]![QuoteForm]![JobID]" but tis dosent
work...
it
prints
all
the records...

Please post your actual code. What's the Recordsource
of
the
report?
--

John W. Vinson [MVP]
.



.



.



.



.



.
Click to expand...


.
Click to expand...
Click to expand...
 
Yes... provide me with your email address...

Gina Whipp said:
Kunal,

Now, I'm stumped because everything you have confirmed *appears* correct so
the report should filter and not show all the records. Is the database in a
state where you can send it to me?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Gina,

Yes that part is correct as well...!!!

Kunal.

Gina Whipp said:
Kunal,

Then the RecordSource is not the problem. Is the field JobID on the form
and can you confirm that that is the field name?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Record Source for both Form and Report is same "Quote" which is the
'First
Table' I selected the Macro from the Dropdown list. I am using Access
2003

:

Kunal,

What is the RecordSOucre of the report and what is the RecordSource of
the
form? Also, did you type in the name of the Macro or select it from a
drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

The On Click event didnt had anything when I created the command
button
through the wizard in which I defined wat report I want to print...
so
I
opened mi form and and defined the event as the Print Macro which we
made...

Do you think it could b a problem wit the record source of the
Report...
it
just struck in mi mind tat the record source of the report is the
Table...
and not the Form...???

Regards,

Kunal.

:

Kunal,

Okay then the only thing left to check is the Print Commnad... I
assume
you
used a Command Button. Please look at the Command Button and tell
me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I just
want
to
print data related to that particular JobID which is shown on the
Fom...

Mi form is always open as that print command is on the form
itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" -> View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the same
then
I
restate
my request. Please type your Macro actions here so we can
look
and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set the
Print
Command
on
the Form. But I think its the Macros where condition which
is
having
trouble... The condition which I pasted before is the one I
copied
from
one
of the Templet I downloaded from Microsoft Website. Their
Database
is
more
complicated than mine... and it does work there but not
with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might help
if
you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hello John,

My database have got 3 tables, they have no
relationships.
First
table
is
the one which captures all the main data off the form.
2nd
&
3rd
tables
are
just to fillup the 'Combo Box'. A single form on which
all
the
data
are
entred and calculated.

So according to this scenario I think the best reply
would
be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I informed
in
my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,
Click to expand...
Click to expand...
Click to expand...
 
Kunal,

classon <at> aol <dot> com

Please replace the <at> with @ and the <dot> with a . Trying to prevent the
Spammers from harvesting.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Kunal Jariwala said:
Yes... provide me with your email address...

Gina Whipp said:
Kunal,

Now, I'm stumped because everything you have confirmed *appears* correct
so
the report should filter and not show all the records. Is the database
in a
state where you can send it to me?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Yes that part is correct as well...!!!

Kunal.

:

Kunal,

Then the RecordSource is not the problem. Is the field JobID on the
form
and can you confirm that that is the field name?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

Record Source for both Form and Report is same "Quote" which is the
'First
Table' I selected the Macro from the Dropdown list. I am using
Access
2003

:

Kunal,

What is the RecordSOucre of the report and what is the RecordSource
of
the
form? Also, did you type in the name of the Macro or select it
from a
drop
down list? Also, what version of Access?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message
Gina,

The On Click event didnt had anything when I created the command
button
through the wizard in which I defined wat report I want to
print...
so
I
opened mi form and and defined the event as the Print Macro which
we
made...

Do you think it could b a problem wit the record source of the
Report...
it
just struck in mi mind tat the record source of the report is the
Table...
and not the Form...???

Regards,

Kunal.

:

Kunal,

Okay then the only thing left to check is the Print Commnad...
I
assume
you
used a Command Button. Please look at the Command Button and
tell
me
what
you see in the On_Click event of the Command Button.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

in
message
Hi Gina,

Thanks for the reply...

The work same as mi previous one... prints all the data... I
just
want
to
print data related to that particular JobID which is shown on
the
Fom...

Mi form is always open as that print command is on the form
itself...
so I
click the print button and it prints all data one by one...

:

Kunal,

Try changing the Where condition to...

"[JobID]=" & =[Forms]![QuoteForm]![JobID]

Please confirm that the form is open when you run this...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Gina,

Mi Macro Action is "OpenReport" -> Report Name "Quote" ->
View
"Print" ->
Filter Name 'Blank' -> Where Condition
"[JobID]=[Forms]![QuoteForm]![JobID]"
-> Window Mode "Normal".

Regards,

Kunal.

:

Kunal,

If the form name is the same and the field name is the
same
then
I
restate
my request. Please type your Macro actions here so we can
look
and
see
if
we spot any errors.

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala" <[email protected]>
wrote
in
message
Hi Gina,

Mi JobID is Numeric (Auto Integers). I m trying to set
the
Print
Command
on
the Form. But I think its the Macros where condition
which
is
having
trouble... The condition which I pasted before is the
one I
copied
from
one
of the Templet I downloaded from Microsoft Website.
Their
Database
is
more
complicated than mine... and it does work there but not
with
mine...
All
names are correct, but still dosent work???

Thanks.

Kunal.

:

Kunal,

Is the form open? Is JobID text or numberic? Might
help
if
you
type
your
Macro arguements here..

--
Gina Whipp

"I feel I have been denied critical, need to know,
information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Kunal Jariwala"
<[email protected]>
wrote
in
message
Hello John,

My database have got 3 tables, they have no
relationships.
First
table
is
the one which captures all the main data off the
form.
2nd
&
3rd
tables
are
just to fillup the 'Combo Box'. A single form on
which
all
the
data
are
entred and calculated.

So according to this scenario I think the best reply
would
be
"the
1st
Table
is the Record Source for the Report."

The Where Condition for the Macro is same as I
informed
in
my
earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".

Thanks.

Kunal.

:

On Wed, 23 Dec 2009 14:55:01 -0800, Kunal Jariwala

Hi Mires,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top