Prev: open report
Next: Beginner with ComboBox
From: aligahk06 on 23 Apr 2010 07:48
Dear All,

I have a form but i could not move to the next record and even i could n't
save the records to the table.
How can a table and a form fields can be linked.I'm encountering #Name error.
Can anybody look out the form and advise me.

Help is deeply welcome.


Rgds,
Aligahk06
From: Al Campagna on 23 Apr 2010 09:38
aligahk06,
>> How can a table and a form fields can be linked.
A form can have, as it's RecordSource, a table, or a query
Most times, it's a query.
Place your cursor in your form's RecordSource textbox, and click
the arrow that appears on the right. Using this query grid set up the table
and fields for the query that will be delivered to the form.

The data controls on your form will each be bound to one of those
fields from that query (using the Field List)

>>I'm encountering #Name error.
On your form, one of the controls is bound to a field
that Access can not find.
For example if you have a field in your table named ItemPrice,
but on the form, one of your controls ControlSource is set to
Contol Name: ItemRetailPrice
ControlSource: ItemPricce (misspelled)
will cause a #Name error.
Also, any calculated text control, that references a table field
incorrectly,
or the name of a control on the form incorrectly...
= ItemRetaiPrice * 10 (misspelled)
will cause a #Name error.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."



"aligahk06" <abdulhakimkhan(a)hotmail.com> wrote in message
news:55A12B8A-CD08-4FBE-BBA9-6775A9AA5930(a)microsoft.com...
> Dear All,
>
> I have a form but i could not move to the next record and even i could n't
> save the records to the table.
> How can a table and a form fields can be linked.I'm encountering #Name
> error.
> Can anybody look out the form and advise me.
>
> Help is deeply welcome.
>
>
> Rgds,
> Aligahk06


From: Sanne on 23 Apr 2010 11:05
i have lots of problem too yousing this e amil pleas send one e amil to may
acount and let me no how i fin and do things so i can sending mails pleas
"aligahk06" <abdulhakimkhan(a)hotmail.com> skrev i melding
news:55A12B8A-CD08-4FBE-BBA9-6775A9AA5930(a)microsoft.com...
> Dear All,
>
> I have a form but i could not move to the next record and even i could n't
> save the records to the table.
> How can a table and a form fields can be linked.I'm encountering #Name
> error.
> Can anybody look out the form and advise me.
>
> Help is deeply welcome.
>
>
> Rgds,
> Aligahk06

From: Al Campagna on 23 Apr 2010 20:05
Aligahk06,
Sorry, but responders are generally respond within
these newgroups.
If your uncertain about how to ask questions, read responses,
and reply to newsgroups, try using Google groups.
Find the microsoft.public.access.gettingstarted group and use that
to continue with your original post. You can find your post, read our
responses, and respond back... all without using an email program.
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
"Sanne" <sannetorsvik(a)hotmail.com> wrote in message
news:O3TVwZv4KHA.5464(a)TK2MSFTNGP05.phx.gbl...
>i have lots of problem too yousing this e amil pleas send one e amil to may
>acount and let me no how i fin and do things so i can sending mails pleas
> "aligahk06" <abdulhakimkhan(a)hotmail.com> skrev i melding
> news:55A12B8A-CD08-4FBE-BBA9-6775A9AA5930(a)microsoft.com...
>> Dear All,
>>
>> I have a form but i could not move to the next record and even i could
>> n't
>> save the records to the table.
>> How can a table and a form fields can be linked.I'm encountering #Name
>> error.
>> Can anybody look out the form and advise me.
>>
>> Help is deeply welcome.
>>
>>
>> Rgds,
>> Aligahk06
>


 | 
Pages: 1
Prev: open report
Next: Beginner with ComboBox