mytfein
asked on
Access 2010: continuous forms - what am typing on one row is showing on remaining row(s)
Hi EE,
With Access 2010/Continuous forms:
Is there a way to only modify the row that I typed into, without Access placing it in rest of rows on the continuous form?
Please see screen shots below. Uploaded a test MDB with the continous form.
tx for your help, sandra
1) I typed into first row only
2) The second row is showing the value
3) The table behind the scenes only updated the 1st row which is good....
2015-06-02-EE-ARG-Jun-ClearingHouse-Veri
With Access 2010/Continuous forms:
Is there a way to only modify the row that I typed into, without Access placing it in rest of rows on the continuous form?
Please see screen shots below. Uploaded a test MDB with the continous form.
tx for your help, sandra
1) I typed into first row only
2) The second row is showing the value
3) The table behind the scenes only updated the 1st row which is good....
2015-06-02-EE-ARG-Jun-ClearingHouse-Veri
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Pat,
Thx so much for writing,
You are right the txtBox is unbound.
Just wanted user to type in a value, and the after update event massages it and places it in another form field that ** is bound**, essentially updating the record with the massaged value
row:
Me.txtStudentName Me.txtMatricTerm Me.txtMatricDate
User would enter into Me.txtMatricTerm (unbound)
and place the revised value into:
Me.txtMatricDate (bound)
Should I create a bogus field in the table, and bind Me.txtMatricTerm to get around this problem?
tx, sandra
Thx so much for writing,
You are right the txtBox is unbound.
Just wanted user to type in a value, and the after update event massages it and places it in another form field that ** is bound**, essentially updating the record with the massaged value
row:
Me.txtStudentName Me.txtMatricTerm Me.txtMatricDate
User would enter into Me.txtMatricTerm (unbound)
and place the revised value into:
Me.txtMatricDate (bound)
Should I create a bogus field in the table, and bind Me.txtMatricTerm to get around this problem?
tx, sandra
ASKER
Just some extra info:
It's possible for students not to supply their SSN for privacy reasons.
So this no ssn students will not successfully join to another table that DOES have the matric term.
So I want to create a screen that shows the no SSN students, and the user should type in the info manually.
The table will be output to a text file to send to another organization.
Our system carries the Matric info as a semester code for ex: 201410, 201420, 201430
The receiving organization wants a date, so that's why I massage the Matric Term that the user types in.
tx! sandra
It's possible for students not to supply their SSN for privacy reasons.
So this no ssn students will not successfully join to another table that DOES have the matric term.
So I want to create a screen that shows the no SSN students, and the user should type in the info manually.
The table will be output to a text file to send to another organization.
Our system carries the Matric info as a semester code for ex: 201410, 201420, 201430
The receiving organization wants a date, so that's why I massage the Matric Term that the user types in.
tx! sandra
ASKER
Hi Pat,
Was trying a few diff ideas that did not work and then found this:
https://www.experts-exchange.com/articles/6692/Overcoming-unbound-continuous-forms-limitations-by-staging-data.html
will create a temporary staging table to edit, and then apply the updates to the "main" table
tx for your help,
sandra
Was trying a few diff ideas that did not work and then found this:
https://www.experts-exchange.com/articles/6692/Overcoming-unbound-continuous-forms-limitations-by-staging-data.html
will create a temporary staging table to edit, and then apply the updates to the "main" table
tx for your help,
sandra
ASKER
off a text file that is imported into the Access mdb. The file does not come with a header row.
Below is documentation as fyi
tx, sandra
2015-06-02-DV-ProgrammingandTestingGuide