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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Link form to table
hello all,
i am using ms access 2007 and im still learning it, i want to create a customer database (table) and i want to create a form that i can use to enter a new customer into the database. i am able to create the customer table however i need help regarding how to link the form to the table in order to insert the customer Name,Number,Adress etc in the form and to be directly sent to the table. How is it done? thnx |
#2
|
|||
|
|||
Link form to table
Select the table in the navigation pane. Now go to the ribbon and click on
the Tab [Create] and choose Form. This will create an automatic form based on your table. The table is linked to your form. Anything you enter in the for will be stored in the table automatically. -- Maurice Ausum "bretta" wrote: hello all, i am using ms access 2007 and im still learning it, i want to create a customer database (table) and i want to create a form that i can use to enter a new customer into the database. i am able to create the customer table however i need help regarding how to link the form to the table in order to insert the customer Name,Number,Adress etc in the form and to be directly sent to the table. How is it done? thnx . |
#3
|
|||
|
|||
Link form to table
On Fri, 09 Apr 2010 15:22:52 GMT, "bretta" u59251@uwe wrote:
hello all, i am using ms access 2007 and im still learning it, i want to create a customer database (table) and i want to create a form that i can use to enter a new customer into the database. i am able to create the customer table however i need help regarding how to link the form to the table in order to insert the customer Name,Number,Adress etc in the form and to be directly sent to the table. How is it done? thnx Use the table - or, better, a query based on the table - as the form's Recordsource. There is an "Auto Form" wizard if you open the table in design view, it should give you a starting point. You might want to look at some of these resources; Crystal's tutorial video would be a good start: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- John W. Vinson [MVP] |
#4
|
|||
|
|||
Link form to table
hi Maurice, i tried what u said and it didnt work . it gave me three text
boxes without any button and when i changed the text in the textboxed and pressed enter nothing was added to the table. Maurice wrote: Select the table in the navigation pane. Now go to the ribbon and click on the Tab [Create] and choose Form. This will create an automatic form based on your table. The table is linked to your form. Anything you enter in the for will be stored in the table automatically. hello all, [quoted text clipped - 8 lines] . -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
#5
|
|||
|
|||
Link form to table
HI John thnx for all the resources but i still wasn't able to do it :S i was
able to create a form in design form with adding text boxes and a button however i wasn't able to give the action( needs coding i think) to the button so that when pressed would insert the texts in the text boxes to the table. John W. Vinson wrote: hello all, [quoted text clipped - 6 lines] thnx Use the table - or, better, a query based on the table - as the form's Recordsource. There is an "Auto Form" wizard if you open the table in design view, it should give you a starting point. You might want to look at some of these resources; Crystal's tutorial video would be a good start: Jeff Conrad's resources page: http://www.accessmvp.com/JConrad/acc...resources.html The Access Web resources page: http://www.mvps.org/access/resources/index.html Roger Carlson's tutorials, samples and tips: http://www.rogersaccesslibrary.com/ A free tutorial written by Crystal: http://allenbrowne.com/casu-22.html A video how-to series by Crystal: http://www.YouTube.com/user/LearnAccessByCrystal MVP Allen Browne's tutorials: http://allenbrowne.com/links.html#Tutorials -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
#6
|
|||
|
|||
Link form to table
On Fri, 09 Apr 2010 15:22:52 GMT, "bretta" u59251@uwe wrote:
i am using ms access 2007 and im still learning it, i want to create a customer database (table) and i want to create a form that i can use to enter a new customer into the database. i am able to create the customer table however i need help regarding how to link the form to the table in order to insert the customer Name,Number,Adress etc in the form and to be directly sent to the table. How is it done? This is builtin, automatic, no code, no effort functionality. Select the table in design view. Click the AutoForm button on the toolbar. Bang. You have a form that will let you add data to the table. Of course you can customize and improve the form but - for what you ask - this does it for you. -- John W. Vinson [MVP] |
#7
|
|||
|
|||
Link form to table
On Sun, 11 Apr 2010 14:08:35 GMT, "bretta via AccessMonster.com" u59251@uwe
wrote: HI John thnx for all the resources but i still wasn't able to do it :S i was able to create a form in design form with adding text boxes and a button however i wasn't able to give the action( needs coding i think) to the button so that when pressed would insert the texts in the text boxes to the table. John W. Vinson wrote: Why do you need a button????? What do you want the button to do? -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Link form to table
I need the button to make the form more user friendly because it will be used
by inexperienced users who do not know access so i want to make each function with a button. How can i add buttons that do different things when clicked example add new record? thnx John W. Vinson wrote: HI John thnx for all the resources but i still wasn't able to do it :S i was able to create a form in design form with adding text boxes and a button however i wasn't able to give the action( needs coding i think) to the button so that when pressed would insert the texts in the text boxes to the table. Why do you need a button????? What do you want the button to do? -- Message posted via http://www.accessmonster.com |
#9
|
|||
|
|||
Link form to table
On Mon, 12 Apr 2010 09:14:35 GMT, "bretta via AccessMonster.com" u59251@uwe
wrote: I need the button to make the form more user friendly because it will be used by inexperienced users who do not know access so i want to make each function with a button. How can i add buttons that do different things when clicked example add new record? Open the Form in design view. Make sure the Toolbox is visible (it normally will be in design view, and it's on the ribbon in 2007/2010). Use the Command Button tool. The toolbox wizard has some common choices (move to new record) available, or you can write your own Macro or VBA code in the button's Click event. -- John W. Vinson [MVP] |
#10
|
|||
|
|||
Link form to table
thnx again john, i was able to do ti. i found the form wizard button which
made it way to easy and simple to do it. John W. Vinson wrote: I need the button to make the form more user friendly because it will be used by inexperienced users who do not know access so i want to make each function with a button. How can i add buttons that do different things when clicked example add new record? Open the Form in design view. Make sure the Toolbox is visible (it normally will be in design view, and it's on the ribbon in 2007/2010). Use the Command Button tool. The toolbox wizard has some common choices (move to new record) available, or you can write your own Macro or VBA code in the button's Click event. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/201004/1 |
Thread Tools | |
Display Modes | |
|
|