Access 2K text Box (2000)

Topic

New Reply

I have a working mdb for contacts which I have used for several years. I wanted to add a text box for labels and get rid of blank lines in the address. I am using the MSKB article, have used it in the past when it worked fine. Now on any form, if I add a text box control and name it e.g txtFullName I get a #Name? error. What has changed, what is going on.
Thankss for any help.
Mike Trotter

Reply | Quote

Replies

What KB article ?
What is the Control Source of the textbox txtFullName, a field or an expression ?
What is the record source of the form, a table or a query ?

Reply | Quote

(Edited by charlotte on 09-Sep-04 19:41. to add link to MSKB)

Article 209653 Microsoft Knowledge Base Article 209653
Record source a table.
Originally an expression as per the KB example applied throught the control source.
However the error repeated without any data other than the text box name on the form. I repeate I have had the whole thing work properly on an earlier db which has been deleted
Clearly this is something to do with the form (I’ve tried a virgin form-same result) and not with the sample code.
Mike

Reply | Quote

(Edited by charlotte on 09-Sep-04 19:41. to add link to MSKB)

Article 209653 Microsoft Knowledge Base Article 209653
Record source a table.
Originally an expression as per the KB example applied throught the control source.
However the error repeated without any data other than the text box name on the form. I repeate I have had the whole thing work properly on an earlier db which has been deleted
Clearly this is something to do with the form (I’ve tried a virgin form-same result) and not with the sample code.
Mike

Reply | Quote

I just test the function in my contact database and have no problem.
Try different things to get the ?#Name error but no success.
Can you attach a sample db with the problem?

Reply | Quote

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was staill giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike
I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Reply | Quote

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was staill giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike
I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Reply | Quote

I just test the function in my contact database and have no problem.
Try different things to get the ?#Name error but no success.
Can you attach a sample db with the problem?

Reply | Quote

One cause for the #Name? error is a circular reference. Does your expression refer to the control name rather than the field name? Is the control bound to a field that exists? Is the form bound to the table?

Reply | Quote

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was still giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Reply | Quote

Many thanks to Francois & Charlotte. I managed to sort it in the end.
Access was giving misleading errors of at least two different types.
On the empty text box control it was still giving the #Name? error. By deleting the box and starting over I got round that.
I was confused by the ‘code continues’ character (_) the underscore. This is shown on the KB article 209653 but should NOT be entered.
Access, just in case things were getting too easy for me, threw in a ‘String too long’ error. Fortunately I had got this code to work about 2 years ago, so I knew that that was a misleading error.
Is it too much to dream that Microsoft might clean up some of the code that people actually use instead of developing more bug ridden versions?

I have a query in the Word forum about max lenght (characters) for a hyperlink between folders on my computer.
I have a page of hyperlinks which work until the M/c is rebooted. Then they fail. Inspection shows that the parser has discarded at least the absolute part of the link and some of the relative part. I suspect that it is throwing out excess characters beyond the Max (64?) .
This is a pity because some of my paths are quite deep and I’m getting very forgetful. My idea was if I put all my main folders on a single, auti opening page of hyperlinks I could find anything fast and without being bothered by my memory loss.
Again many thanks for your help.

Mike

Reply | Quote

One cause for the #Name? error is a circular reference. Does your expression refer to the control name rather than the field name? Is the control bound to a field that exists? Is the form bound to the table?

Reply | Quote