Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

save records from forms in tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Smoki - 02 Apr 2008 11:42 GMT
Hy, I have a problem with my form and saving records from forms in my table!
I have the same fields in tables, like in form and when I fill this fields
and enter command button Save on my form, it doesn't appear in my table.
How to connect my form with tables?
Dennis - 02 Apr 2008 13:56 GMT
You either need to write code behind your command button to write the data
from the boxes on your form into your table, or make sure the control source
property of the form is set to your table name in which case the data will go
into your table without the need of a save button.

> Hy, I have a problem with my form and saving records from forms in my table!
> I have the same fields in tables, like in form and when I fill this fields
> and enter command button Save on my form, it doesn't appear in my table.
> How to connect my form with tables?
Smoki - 02 Apr 2008 14:18 GMT
Control source was not set good, but I made it OK now, and it works. Thank you.
I have other qestion now: when I enter data in form and save this in table,
I want to open form to enter new data in fields, but I always open form with
my old data, and this fields are not blank. What to do? I tried with command
button Save record, after that Add new record, but I didn't get what I wanted!

> You either need to write code behind your command button to write the data
> from the boxes on your form into your table, or make sure the control source
[quoted text clipped - 5 lines]
> > and enter command button Save on my form, it doesn't appear in my table.
> > How to connect my form with tables?
Dennis - 02 Apr 2008 14:27 GMT
In the Load event of the form put this code
DoCmd.GoToRecord , , acNewRec

> Control source was not set good, but I made it OK now, and it works. Thank you.
> I have other qestion now: when I enter data in form and save this in table,
[quoted text clipped - 11 lines]
> > > and enter command button Save on my form, it doesn't appear in my table.
> > > How to connect my form with tables?
Smoki - 02 Apr 2008 14:51 GMT
Thanks!
More questions? I think I made some mistake at the beggining. I'm filling
fields, and I can save this records in table, but wneh I close my form, and
open it again, every time I see my first record, fields are not blank.
Where is the problem?

> In the Load event of the form put this code
> DoCmd.GoToRecord , , acNewRec
[quoted text clipped - 14 lines]
> > > > and enter command button Save on my form, it doesn't appear in my table.
> > > > How to connect my form with tables?
Mikal - 02 Apr 2008 19:40 GMT
>Hy, I have a problem with my form and saving records from forms in my table!
>I have the same fields in tables, like in form and when I fill this fields
>and enter command button Save on my form, it doesn't appear in my table.
>How to connect my form with tables?

You need to set the record source of the form to be the table.  to do this,
open the form in design view and open the properties window by right clicking
the little square in the top left hand corner of the form and selecting
properties from the menu that appears.  The properties window will open and
you need to click the Data tab.  The top text box is the record source.  When
you click in it, a dropdown arrow and a set of elipses will appear to the
right.  Click the dropdown arrow.  A list of all your tables and queries will
appear.  Choose the table you want from that list.  Save your changes by
typing CTRL+S and open the form normally.  Things ought to work like you
expect them to now.  However, you won't need the save button.  You will be
directly entering data into the table via the form and when you move to a new
record, the old one will be saved.

HTH

Mike

Signature

Mike Pippins

"We have met the enemy and he is us." -- Pogo Possum

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.