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 Programming / May 2008

Tip: Looking for answers? Try searching our database.

Add new Records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Gsurfdude - 14 May 2008 12:13 GMT
Hello,

I have a continuous form that is a subform who's record source is a query
based on 3 Oracle linked tables.
I have the record set type as Dynaset inconsistant updates. It will not
allow me to insert or
add new records. I have allow additions = yes, allow edits = yes.

How do I allow a user to add new records to this?

Thanks in Advance!
Golfinray - 14 May 2008 15:20 GMT
Dynaset inconsistant updates will not usually allow modifications or adding
new records. Look back at the query or table you are using for the source of
the form. Is it editable, or have the arrow and asterisk at the bottom. If
not, it is not editable and you need to fix that first. Make sure all your
keys are set correctly, all your tables and queries are updateable, then set
your form to dynaset only.

> Hello,
>
[quoted text clipped - 7 lines]
>
> Thanks in Advance!
Klatuu - 14 May 2008 15:22 GMT
It is most likely the query produces an uneditable recordset.  This will for
certain happen if the query is a Total query or a Union query.  It can also
happen when multiple records are created from one table are created because
of a many to one join.  Most likely, you will need to restructure you query
to create an editable recordset.

You can tell if the recordset is editiable by opening the query in datasheet
view.  If the add record nav button (with the * on it) is greyed out, it
can't be edited.
Signature

Dave Hargis, Microsoft Access MVP

> Hello,
>
[quoted text clipped - 7 lines]
>
> Thanks in Advance!
 
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.