Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Datasheet form has #NAME? in field

Discussion in 'Information Technology' started by Marc, Jul 28, 2006.

  1. Marc

    Marc
    Expand Collapse
    Guest

    I can't seem to figure this one out. I have a form that is built on a
    query. One of the fields is a calculated IIF statement. When I view
    the form as a "single form," this field is correct for each record.
    However, when I switch to "datasheet" the column for this field becomes
    filled with #NAME?.

    Any thoughts?
     
  2. Loading...


  3. G. Vaught

    G. Vaught
    Expand Collapse
    Guest

    My guess is that when in datasheet view, the code behind the form can not
    execute as it does when in single form. What happens when you go into
    Continuous Form?

    "Marc" <vermutmb@gmail.com> wrote in message
    news:1153528004.000553.152370@b28g2000cwb.googlegroups.com...
    >I can't seem to figure this one out. I have a form that is built on a
    > query. One of the fields is a calculated IIF statement. When I view
    > the form as a "single form," this field is correct for each record.
    > However, when I switch to "datasheet" the column for this field becomes
    > filled with #NAME?.
    >
    > Any thoughts?
    >
     
  4. Tom Wickerath

    Tom Wickerath
    Expand Collapse
    Guest

    Hi Marc,

    This sounds strange, indeed. Here is a KB article that may be helpful:

    ACC2000: Troubleshooting Tips for Error Values
    http://support.microsoft.com/?id=209132

    Note: Applies to Access 2002 and 2003 as well.

    You might want to verify that you are not using any reserved words for the
    names of fields, objects or controls. Try downloading Access MVP Allen
    Browne's "Database Issue Checker Utility" or consult his list of reserved
    words here:

    http://allenbrowne.com/AppIssueBadWord.html

    Are you using the IIF statement in your query, or in the control source of a
    textbox on your form?


    Tom Wickerath
    Microsoft Access MVP

    http://www.access.qbuilt.com/html/expert_contributors.html
    http://www.access.qbuilt.com/html/search.html
    __________________________________________

    "Marc" wrote:

    > I can't seem to figure this one out. I have a form that is built on a
    > query. One of the fields is a calculated IIF statement. When I view
    > the form as a "single form," this field is correct for each record.
    > However, when I switch to "datasheet" the column for this field becomes
    > filled with #NAME?.
    >
    > Any thoughts?
     
  5. Marc

    Marc
    Expand Collapse
    Guest

    Thank you both for the quick response. Don't ask me how, or why, but
    when I went into the database to check on the questions you had raised,
    it works just fine now.

    Should this problem arise again, I will take a look at these links.

    Thanks so much.

    Tom Wickerath wrote:
    > Hi Marc,
    >
    > This sounds strange, indeed. Here is a KB article that may be helpful:
    >
    > ACC2000: Troubleshooting Tips for Error Values
    > http://support.microsoft.com/?id=209132
    >
    > Note: Applies to Access 2002 and 2003 as well.
    >
    > You might want to verify that you are not using any reserved words for the
    > names of fields, objects or controls. Try downloading Access MVP Allen
    > Browne's "Database Issue Checker Utility" or consult his list of reserved
    > words here:
    >
    > http://allenbrowne.com/AppIssueBadWord.html
    >
    > Are you using the IIF statement in your query, or in the control source of a
    > textbox on your form?
    >
    >
    > Tom Wickerath
    > Microsoft Access MVP
    >
    > http://www.access.qbuilt.com/html/expert_contributors.html
    > http://www.access.qbuilt.com/html/search.html
    > __________________________________________
    >
    > "Marc" wrote:
    >
    > > I can't seem to figure this one out. I have a form that is built on a
    > > query. One of the fields is a calculated IIF statement. When I view
    > > the form as a "single form," this field is correct for each record.
    > > However, when I switch to "datasheet" the column for this field becomes
    > > filled with #NAME?.
    > >
    > > Any thoughts?
     

Share This Page