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 / Queries / March 2008

Tip: Looking for answers? Try searching our database.

Append/Update Query to add multiple records to Table?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
DougW - 24 Mar 2008 14:06 GMT
Hi - I am not very proficient in Access so please bear with me.
I have a table where very often I will have many identical records in a row
(maybe 24 or 36).
All fields in a given set of records are identical (except for the primary
index).  Later on one
of the fields in the duplicate records will be changed.

For my initial data entry, I have created a form that will let me create
individual records in
my table.  I have an "add record" icon that will create one record.  That
works okay so far.
I have also set default values so the fields in the form will default to the
previous entry.
That works okay too.  But I have to go in and edit one field before the form
will let me add
another duplicate record.  In other words I can't just click my "add record"
icon 24 times -
I have to edit - "add" - edit - "add" - etc, 24 times.

As an alternative, I was wondering if I could add a field to my form with the
number of repeat entries desired.  Then an "add repeat records" icon that
would run an update query or append query that would add the required number
of duplicate records.  Might this work?  If so, how could I set it up?
I would appreciate any advice - thanks!
-- Doug
DougW - 24 Mar 2008 21:09 GMT
Update - I've got it working (sort of) by using an append query.
My problem now is the append query won't run while the data entry form is
open.
I'm attempting to run the append query from an action button on the form.
The query also looks for the number of duplicate records selected on the form.

But since the form is bound to the same table as the append query is trying
to add
records to, I get the "table is already open..." error.

Is there any way I can run the append query while the form is still open?

thanks

>Hi - I am not very proficient in Access so please bear with me.
>I have a table where very often I will have many identical records in a row
[quoted text clipped - 21 lines]
>I would appreciate any advice - thanks!
>-- Doug
 
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.