Results 1 to 7 of 7
  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2K text Box (2000)

    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

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2K text Box (2000)

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

  3. #3
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2K text Box (2000)

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

  4. #4
    Lounger
    Join Date
    Jan 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2K text Box (2000)

    <P ID="edit" class=small>(Edited by charlotte on 09-Sep-04 19:41. to add link to MSKB)</P>Article 209653 <!mskb=209653>Microsoft Knowledge Base Article 209653<!/mskb>
    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

  5. #5
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access 2K text Box (2000)

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

  6. #6
    Lounger
    Join Date
    Jan 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2K text Box (2000)

    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

  7. #7
    Lounger
    Join Date
    Jan 2001
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2K text Box (2000)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •