willjx
asked on
MS ACCESS 2007 Linked to SQL Subform disallowing new data entry
For over a month I have been using a form/subform to enter new data into a data history table.
I then decided I wanted to have my tables reside in an SQL db, and link ACCESS to the SQL tables. All the queries, forms, etc remained exactly the same. Information typed into the linked tables does immediately show in the SQL tables.
My problem:
The subform only displays already entered info, it does not bring up a new fresh row for data entry.
Opening the table itself does show a row at the bottom for entering new data, and doing a simple select Query on the table likewise displays a new row for data entry.
The subform has its “Build” query which when run does not display a new data-entry row in my SQL linked ACCESS db, while the same “Build” query in the ACCESS db where the tables are not linked, does display a new row for data entry.
Assistance please.
I then decided I wanted to have my tables reside in an SQL db, and link ACCESS to the SQL tables. All the queries, forms, etc remained exactly the same. Information typed into the linked tables does immediately show in the SQL tables.
My problem:
The subform only displays already entered info, it does not bring up a new fresh row for data entry.
Opening the table itself does show a row at the bottom for entering new data, and doing a simple select Query on the table likewise displays a new row for data entry.
The subform has its “Build” query which when run does not display a new data-entry row in my SQL linked ACCESS db, while the same “Build” query in the ACCESS db where the tables are not linked, does display a new row for data entry.
Assistance please.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Wow!
That is all that was needed.
Thank you.
That is all that was needed.
Thank you.
Glad to help.
Personally, I would have split the points. You still can by clicking the "Request Attention" at the bottom right of your original post. Then just ask the moderators to reopen so you can reallocate points.
Personally, I would have split the points. You still can by clicking the "Request Attention" at the bottom right of your original post. Then just ask the moderators to reopen so you can reallocate points.
Dale, you know how I roll,...
enjoy buddy...
;-)
Jeff
enjoy buddy...
;-)
Jeff
Jeff, you need to slow down. You've been on a roll lately!
;-)
Dale
;-)
Dale
ASKER
Please allocate 250 of 500 to: fyed and
Please allocate 250 of 500 to: boag2000.
Thank you.
Please allocate 250 of 500 to: boag2000.
Thank you.
wiljx,
The way you do that is find the solution that you want to be your primary answer. Then click the "Accept Multiple Solutions" on that answer. You will be taken to another window to assign points to that solution and any other solution in the thread.
When you check the box for those other Expert Comments that you want to accept, a textbox will become visible for you to assign points.
Then go to the bottom of the page to grade the response and add any comments.
The way you do that is find the solution that you want to be your primary answer. Then click the "Accept Multiple Solutions" on that answer. You will be taken to another window to assign points to that solution and any other solution in the thread.
When you check the box for those other Expert Comments that you want to accept, a textbox will become visible for you to assign points.
Then go to the bottom of the page to grade the response and add any comments.
ASKER
However, I do not detect the presence of a "unique Primary key in the Child (subform) table. ".
Furthermore, I do not select the tables' primary key field as one of the fields in the subform.