O
owp^3
I've been searching all over and I see little bits and pieces of answers to
the issue I am trying to resolve but I can't seem to put it all together.
I am replicating an Excel application to Access as we are outgrowing the
Excel environment.
In Excel I have a worksheet that houses the data and a data entry worksheet
that displays all the fields for a single record. As the user makes changes
those fields become highlighted. Then the user can press a save button or a
cancel button to write/notwrite all of the changes to the data worksheet.
I have the tables and the forms and the queries all built in Access. My
data entry form is populated by a query reading the data table. All of the
fields are bound.
Any time I make a change it writes directly to the data table.
What do I need to do to replicate the highlighting and the command button
functionality I built in Excel?
If there are several ways which one is easiest?
Which one is the cleanest/best way?
Thanks,
the issue I am trying to resolve but I can't seem to put it all together.
I am replicating an Excel application to Access as we are outgrowing the
Excel environment.
In Excel I have a worksheet that houses the data and a data entry worksheet
that displays all the fields for a single record. As the user makes changes
those fields become highlighted. Then the user can press a save button or a
cancel button to write/notwrite all of the changes to the data worksheet.
I have the tables and the forms and the queries all built in Access. My
data entry form is populated by a query reading the data table. All of the
fields are bound.
Any time I make a change it writes directly to the data table.
What do I need to do to replicate the highlighting and the command button
functionality I built in Excel?
If there are several ways which one is easiest?
Which one is the cleanest/best way?
Thanks,