RE: mid function

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi, Dan,

First of all, rename your column - call it a field, which is it's correct
name. 'Control' is an Access reserved word, which means it has special
meaning to Access, and you may not use a reserved word as any object,
function, or variable name. This alone would probably account for all your
trouble.

Besides this, however, where is this field, is it in a table, a query, or
what? Also, where are you putting this code, in a query, or in a form's event?
Are you trying to rename a field at run time (it's impossible - in any object!
) or are you just trying to get data from "choose your field here" and
populate another field?

Help us help you. Copy and paste all your code (or SQL) so we can have a
better idea of your needs.

Hope this is helpful,

Sam

--
Sam

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/200603/1
.

Relevant Pages

  • Re: dlookup
    ... using an Access reserved word as the name of a ... field *will* give you grief at some point. ... It's best to rename it as early ... i have date field in query and i use this statment for report which is bring ...
    (microsoft.public.access.forms)
  • Re: IIf in a report
    ... using an Access reserved word, in a query that's bound to a form or report. ...
    (microsoft.public.access.reports)
  • Questions!
    ... Click the Event tab, click in the ... >Access reserved word. ...
    (microsoft.public.access.forms)
  • Questions!
    ... In form design mode, right click your combobox, and select ... Click the Event tab, click in the AfterUpdate ... Access reserved word. ...
    (microsoft.public.access.forms)
  • Re: calculate headcount
    ... First, rename your field. ... Date is a reserved word, ... shiftstart and shiftend. ...
    (microsoft.public.access.queries)