Report help


B

blake7

Hi All, I have created a report that is linked to a query, the query criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks
 
Ad

Advertisements

A

Al Campagna

blake7,
I'm not sure, but try the exclamation "!" instead of period the "."
I've used the same many times.
Make sure the form stays open...
=[Forms]![weekly summary date select]![startdate]
=[Forms]![weekly summary date select]![enddate]
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks
 
B

blake7

HI, thanks for replying, It does not make a difference if I close the form or
leave it open, I cannot get the text boxes to show the dates on the other
pages of the report.

Gina Whipp said:
blake7,

Do you close the form at any point?

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

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks


.
 
B

blake7

Hi Al, tried the exclamation mark, it makes no difference?

Al Campagna said:
blake7,
I'm not sure, but try the exclamation "!" instead of period the "."
I've used the same many times.
Make sure the form stays open...
=[Forms]![weekly summary date select]![startdate]
=[Forms]![weekly summary date select]![enddate]
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks


.
 
B

blake7

Hi Gina, i owe you an appology, I was closing the form too early and the
dates do show if i don't
thanks for your help

Gina Whipp said:
blake7,

Do you close the form at any point?

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

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between" statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear? Thanks


.
 
Ad

Advertisements

G

Gina Whipp

blake7,

If you close the form it will never work. Is the form visible? I have a
report that pulls it's dates from a from and have never had this problem and
yes, the report is multiple pages.

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

blake7 said:
HI, thanks for replying, It does not make a difference if I close the form
or
leave it open, I cannot get the text boxes to show the dates on the other
pages of the report.

Gina Whipp said:
blake7,

Do you close the form at any point?

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

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between"
statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear?
Thanks


.
 
G

Gina Whipp

No problem... just glad we got that solved. As a suggestion, try making the
form Visible False and see if that causes the same issue. That way your
form can remain open but out of sight. Providing that works, don't forget
to close the form when the report closes.

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

blake7 said:
Hi Gina, i owe you an appology, I was closing the form too early and the
dates do show if i don't
thanks for your help

Gina Whipp said:
blake7,

Do you close the form at any point?

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

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between"
statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear?
Thanks


.
 
Ad

Advertisements

A

Al Campagna

As I said in my first post...The form must remain open if you are going to reference the
value/s of a control on that form.
So... while we shoot this bug, leave it open.
--
hth
Al Campagna
Microsoft Access MVP 2006-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

blake7 said:
HI, thanks for replying, It does not make a difference if I close the form
or
leave it open, I cannot get the text boxes to show the dates on the other
pages of the report.

Gina Whipp said:
blake7,

Do you close the form at any point?

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

blake7 said:
Hi All, I have created a report that is linked to a query, the query
criteria
is based on dates entered in a small form, using the "between"
statement.
On my report I have placed two text boxes in the PAGE HEADER with the
following code in them:
=[Forms]![weekly summary date select].[startdate]
=[Forms]![weekly summary date select].[enddate]
so that I can show the date range etc
The dates appear ok in the first page of the report, but on other pages
the
#Name? error shows in the boxes, how do I get the dates to appear?
Thanks


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top