Re: Access form field won't allow data entry

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

anonymous_at_discussions.microsoft.com
Date: 03/25/04 

Date: Wed, 24 Mar 2004 17:50:01 -0800

OK.. I'll do some more checking... As you'be probably
figured out, I'm relatively new are creating DB's in
Access, a whole different game than simply being
a "user!" Thanks!
>-----Original Message-----
>"BearPair" <anonymous@discussions.microsoft.com> wrote
in message
>news:d8f801c41112$6dc00200$a001280a@phx.gbl
>> Dirk, thanks!
>> Control Source indicates "LAST USED" which is the title
>> of the column of data...?
>> Terry
>>
>>> -----Original Message-----
>>> "BearPair" <anonymous@discussions.microsoft.com>
wrote in message
>>> news:d12801c4107c$65d58e20$a001280a@phx.gbl
>>>> I have constructed a simple Access database for
keeping
>>>> track of quotations. One of the columns is set up for
>>>> entry of a "short date", and works fine in the TABLE
>>>> format. When I bring up the FORM I created form it,
all
>>>> of the fields in this column display: #Name? When
I try
>>>> to manually enter a new date, it doesn't allow me to
type
>>>> over the display. Can you help, please? Thanks!
>>>
>>> What's the Control Source property for that field on
the form, as
>>> shown on the Data tab of the field's property ***?
>
>Hmm. The #Name error means that Access doesn't
recognize the name of
>some control or field. Check the underlying table in
design view and
>make sure that "LAST USED" is really the name of the
field, and not just
>the Caption of the field. Then check the form's Record
Source property
>to see if it's really the table itself, or a query based
on the table
>(whether a stored query or a SQL SELECT statement). If
it's a query,
>make sure that the [LAST USED] field is in the list of
fields selected
>by the query.
>
>--
>Dirk Goldgar, MS Access MVP
>www.datagnostics.com
>
>(please reply to the newsgroup)
>
>
>
>--
>Dirk Goldgar, MS Access MVP
>www.datagnostics.com
>
>(please reply to the newsgroup)
>
>
>.
>

Quantcast