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 / October 2005

Tip: Looking for answers? Try searching our database.

data doesn't commit when pasted into subform datasheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
David Mueller - 14 Oct 2005 21:40 GMT
The paste works, but the data doesn't commit until some sort of action is
taken - I don't know exactly what type of action commits the data, but a
"remove filter" will do it.

When the data commits, it "falls" out of view, and the subform returns to an
"empty" waiting to add a record state.  I suspect this is because there are
no master/child links.

The query behind the subform is CUSTOMERS table (PK autonumber) and a
sub-class SPOUSE table (FK, no PK) with a one-to-one relationship.  

The subform has no master/child links because the user will be pasting in
new customers, not data related to a specific customer.

Can anyone explain what I'm seeing here?  and how do I get the data to
commit immediately after the paste?  

Thanks.
David Mueller
[MVP] S.Clark - 14 Oct 2005 21:59 GMT
The actions that you can take are the following:
Press F9
Click the Save Icon
Choose Save from the Menu
Resort the data
Apply a filter
Remove a filter
Close the Form
Close Access
Click on a subform
Press the Page Down Key
Press the down arrow from the last control
Press the tab key from the last control
Ctrl+home
Ctrl+End
Home
End
Look at Access funny
Sneeze

I wonder if I forgot any??

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

> The paste works, but the data doesn't commit until some sort of action is
> taken - I don't know exactly what type of action commits the data, but a
[quoted text clipped - 17 lines]
> Thanks.
> David Mueller
David Mueller - 15 Oct 2005 01:45 GMT
Thanks.  I've been looking funny at this all day, and I'm the one that will
get committed! :)

Seriously, those are a lot of options, but none are transparent to the user.
Is there some code I can place behind an event?

Also, I just noticed that when I paste records, the last of the records is
never populated with the data that should be there... the last pasted record
is always blank.  Something screwy is going on.

Any additional thoughts?

> The actions that you can take are the following:
> Press F9
[quoted text clipped - 39 lines]
> > Thanks.
> > David Mueller
 
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.