A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I fix error #name? in acc2003 page numbering



 
 
Thread Tools Display Modes
  #1  
Old June 21st, 2006, 10:41 AM posted to microsoft.public.access.forms
Nick @ Oxford
external usenet poster
 
Posts: 1
Default How do I fix error #name? in acc2003 page numbering

I am trying to Insert page numbers on a Access Form, however I get the error
#name? on the form, I have tried searching for a solution, but found nothing
relivent, I am using the standard expression/control source - ="Page " &
[Page] & " of " & [Pages] - Can Anyone Help
  #4  
Old June 21st, 2006, 12:48 PM posted to microsoft.public.access.forms
Keith Wilby
external usenet poster
 
Posts: 812
Default How do I fix error #name? in acc2003 page numbering

"Nick @ Oxford" wrote in message
...
I added the text boxes and hid them ...
Unfortunaly I Still Get the Same error #Name?


Try replacing the text box with a new one from the *toolbox*. I've noticed
that if you modify the control source of a text box that was created by
dragging from the query/table field names that this can sometimes happen,
although I don't know why.

Regards,
Keith.


  #5  
Old June 21st, 2006, 01:20 PM posted to microsoft.public.access.forms
Nick @ Oxford
external usenet poster
 
Posts: 2
Default How do I fix error #name? in acc2003 page numbering

Unfortunatly I am still getting the same error, even with new text boxes...
Have you any other ideas ???

"Keith Wilby" wrote:

"Nick @ Oxford" wrote in message
...
I added the text boxes and hid them ...
Unfortunaly I Still Get the Same error #Name?


Try replacing the text box with a new one from the *toolbox*. I've noticed
that if you modify the control source of a text box that was created by
dragging from the query/table field names that this can sometimes happen,
although I don't know why.

Regards,
Keith.



  #6  
Old June 21st, 2006, 01:22 PM posted to microsoft.public.access.forms
Keith Wilby
external usenet poster
 
Posts: 812
Default How do I fix error #name? in acc2003 page numbering

"Keith Wilby" wrote in message
...
I've noticed that if you modify the control source of a text box that was
created by dragging from the query/table field names that this can
sometimes happen, although I don't know why.


Actually I think I've just sussed it. It appears to be a problem if a text
box has the same name as its data source. Try prefixing your text box names
with "txt".

Keith.


  #8  
Old June 21st, 2006, 01:55 PM posted to microsoft.public.access.forms
Keith Wilby
external usenet poster
 
Posts: 812
Default How do I fix error #name? in acc2003 page numbering

"Nick @ Oxford" wrote in message
...
Unfortunatly I am still getting the same error, even with new text
boxes...
Have you any other ideas ???


Are you sure you've got the text box in the *page* footer? You can't number
a form in the form footer AFAIK. You'd see the page number in print preview
mode with the text box in the page footer.

Keith.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.