Update a Report

  • Thread starter Thread starter RMires
  • Start date Start date
R

RMires

I have a command button that opens a report based upon a information in a
form. I want to be able to change the data on the record and update the
report without having to go to the next record and without having to manually
close the report.
 
RMires,

Once you open the report it in essence becomes an image. You cannot
*refresh* it the traditional way. You have to close and reopen all which
can be accomplished in the After_Update event of the control you change.
Other then that there is no other way, that I am aware of, to do what you
want without closing/reopening the report.

--
Gina Whipp

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

http://www.regina-whipp.com/index_files/TipList.htm
 
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...

Thanks.

Kunal.
 
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...
Click to expand...

Please post your actual code. What's the Recordsource of the report?
 
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.

John W. Vinson said:
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...
Click to expand...

Please post your actual code. What's the Recordsource of the report?
Click to expand...
 
Hello John,

My database have got 3 tables, they have no relationships.
Click to expand...

Then it's not really a database. What are the three tables? What Entities
(real-life people, things or events) do they represent? How are those entities
logically connected to one another in the real world?
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.
Click to expand...

If you're designing a database starting with a Form, you're probably on the
wrong track. Forms do not generally map all that well to logical, normalized
designs.
So according to this scenario I think the best reply would be "the 1st Table
is the Record Source for the Report."
Click to expand...

If you open the Report in design view, view its Properties, and select the
Data tab, what is shown in its "Record Source" property?
The Where Condition for the Macro is same as I informed in my earlier post
"[JobID]=[Forms]![QuoteForm]![JobID]".
Click to expand...

Macros don't have Where Conditions. Forms do.
 
Joh,n

Ummm, macros do have Where Conditions when using OpenForm or OpenReport
actions.

--
Gina Whipp

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

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

John W. Vinson said:
Hello John,

My database have got 3 tables, they have no relationships.
Click to expand...

Then it's not really a database. What are the three tables? What Entities
(real-life people, things or events) do they represent? How are those
entities
logically connected to one another in the real world?
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.
Click to expand...

If you're designing a database starting with a Form, you're probably on
the
wrong track. Forms do not generally map all that well to logical,
normalized
designs.
So according to this scenario I think the best reply would be "the 1st
Table
is the Record Source for the Report."
Click to expand...

If you open the Report in design view, view its Properties, and select the
Data tab, what is shown in its "Record Source" property?
The Where Condition for the Macro is same as I informed in my earlier post
"[JobID]=[Forms]![QuoteForm]![JobID]".
Click to expand...

Macros don't have Where Conditions. Forms do.
Click to expand...
 
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 said:
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.

John W. Vinson said:
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...
Click to expand...

Please post your actual code. What's the Recordsource of the report?
Click to expand...
Click to expand...
 
John,

1. I very well knw tat my Database design is not in Third Normal Form
neither in Second Normal Form !!! As I am not as good on creating the forms
and as this database requirement is urgent I added all the fields required in
the form into a single table, which can hav only one adverse effect - 'the
size of the database will be big' and I am not worried about the size at tis
point !!! To get tis work I made all the fields optional (not required) and
thus it allows me to put everything togather in one simple form. The only
thing Report has to do is to knw copy data opposite to the relevant JobID and
print it !!! Also the Layout of the Report is same as Layout for Form.

2. Regarding the Record Source for the Report, my reply would be same... its
the "First Table".

3. Macros DO have WHERE CONDITIONS !!! As Gina replied to ur post, they are
used to Open Report or Form through Macros.

Thanks.

Kunal.

John W. Vinson said:
Hello John,

My database have got 3 tables, they have no relationships.
Click to expand...

Then it's not really a database. What are the three tables? What Entities
(real-life people, things or events) do they represent? How are those entities
logically connected to one another in the real world?
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.
Click to expand...

If you're designing a database starting with a Form, you're probably on the
wrong track. Forms do not generally map all that well to logical, normalized
designs.
So according to this scenario I think the best reply would be "the 1st Table
is the Record Source for the Report."
Click to expand...

If you open the Report in design view, view its Properties, and select the
Data tab, what is shown in its "Record Source" property?
The Where Condition for the Macro is same as I informed in my earlier post
"[JobID]=[Forms]![QuoteForm]![JobID]".
Click to expand...

Macros don't have Where Conditions. Forms do.
Click to expand...
 
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.

Gina Whipp said:
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 said:
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.

John W. Vinson said:
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?
Click to expand...
Click to expand...


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

Gina Whipp said:
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?
Click to expand...


.
Click to expand...
Click to expand...
 
V,

I do not see what fields are in the First table, did you post that
information somewhere?

--
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 said:
John,

1. I very well knw tat my Database design is not in Third Normal Form
neither in Second Normal Form !!! As I am not as good on creating the
forms
and as this database requirement is urgent I added all the fields required
in
the form into a single table, which can hav only one adverse effect - 'the
size of the database will be big' and I am not worried about the size at
tis
point !!! To get tis work I made all the fields optional (not required)
and
thus it allows me to put everything togather in one simple form. The only
thing Report has to do is to knw copy data opposite to the relevant JobID
and
print it !!! Also the Layout of the Report is same as Layout for Form.

2. Regarding the Record Source for the Report, my reply would be same...
its
the "First Table".

3. Macros DO have WHERE CONDITIONS !!! As Gina replied to ur post, they
are
used to Open Report or Form through Macros.

Thanks.

Kunal.

John W. Vinson said:
Hello John,

My database have got 3 tables, they have no relationships.
Click to expand...

Then it's not really a database. What are the three tables? What Entities
(real-life people, things or events) do they represent? How are those
entities
logically connected to one another in the real world?
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.
Click to expand...

If you're designing a database starting with a Form, you're probably on
the
wrong track. Forms do not generally map all that well to logical,
normalized
designs.
So according to this scenario I think the best reply would be "the 1st
Table
is the Record Source for the Report."
Click to expand...

If you open the Report in design view, view its Properties, and select
the
Data tab, what is shown in its "Record Source" property?
The Where Condition for the Macro is same as I informed in my earlier
post
"[JobID]=[Forms]![QuoteForm]![JobID]".
Click to expand...

Macros don't have Where Conditions. Forms do.
Click to expand...
Click to expand...
 
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.

Gina Whipp said:
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 said:
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.

Gina Whipp said:
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,

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

Gina Whipp said:
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,

Try changing the Where condition to...

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

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

Gina, don't you have an extra = sign there? It should probably be

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

Thank you... I have the sister to David Fenton's typist!

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

John W. Vinson said:
Kunal,

Try changing the Where condition to...

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

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

Gina, don't you have an extra = sign there? It should probably be

"[JobID]=" & [Forms]![QuoteForm]![JobID]
Click to expand...
 
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

Kunal Jariwala said:
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.

Gina Whipp said:
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...
 
Back
Top