A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Linking forms field and table field .



 
 
Thread Tools Display Modes
  #1  
Old April 23rd, 2010, 12:48 PM posted to microsoft.public.access.gettingstarted
aligahk06
external usenet poster
 
Posts: 9
Default Linking forms field and table field .

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
  #2  
Old April 23rd, 2010, 02:38 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Linking forms field and table field .

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" wrote in message
...
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



  #3  
Old April 23rd, 2010, 04:05 PM posted to microsoft.public.access.gettingstarted
Sanne[_2_]
external usenet poster
 
Posts: 1
Default Linking forms field and table field .

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" skrev i melding
...
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


  #4  
Old April 24th, 2010, 01:05 AM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default Linking forms field and table field .

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" wrote in message
...
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" skrev i melding
...
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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:05 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.