Edit Records by Form

[colvind]

I had a question that may seem simple but I'm having some problems.
I'm kind of learning Access 2003 by the seat of my pants, though I'm
fairly tech saavy and in IT, it's just not something I've worked with
a lot.

I have an Access DB.
One table: "QA Form"
Two forms: Short Audit Form "QA Form QC" and Long Audit Form "QA
Form"
(only difference between the forms is there are some fields on
the long that don't appear on the short)
Both forms enter data onto the "QA Form" table. (If using the short
form, the fields that don't appear on the short form are simply blank
on the table)


Two reports: Short Form report "QA Form QC" and Long Form Report "QA
Form Reg"
There's a button on each form that saves the record then dumps the
form info onto the appropriate report that looks good for printing.


I have a Query-by-Form style form/query setup to find previous records
and display them within a Datasheet view or the appropriate report
view.

One functionality I am unable to figure out is how to be able to
reopen a table record in the appropriate form to edit that record in
form view. I can edit the table or in datasheet view. But my users
will not want to use either method;
they'll simply want to be able to bring up the previous record in the
appropriate form for editting and saving.

Is this possible?
To give users the capability to search out a previous record, have
that record populate the appropriate form, be editted, and then save
the editted record's changes to the table?

 

[Clifford Bass]

Hi,

I imagine that you should be able to use the same appropriate forms to
do that. Do they only allow for adding new records? If so, you can change
each form's "Allow Edits" property to "Yes". Then the person can navigate
through all of the records, searching (use the binoculars button) and
modifying as needed. You may wish to use a filter of some sort to limit the
appropriate rows to the appropriate forms. So, if you have a field named
Version that holds "L" for Long and "S" for Short, you could make the filter
for the long version form [Version] = "L". Likewise for the short one.

If that does not help, please post additional details.

Clifford Bass

 

[colvind]

Hi,

     I imagine that you should be able to use the same appropriate forms to
do that.  Do they only allow for adding new records?  If so, you can change
each form's "Allow Edits" property to "Yes".  Then the person can navigate
through all of the records, searching (use the binoculars button) and
modifying as needed.  You may wish to use a filter of some sort to limit the
appropriate rows to the appropriate forms.  So, if you have a field named
Version that holds "L" for Long and "S" for Short, you could make the filter
for the long version form [Version] = "L".  Likewise for the short one.

     If that does not help, please post additional details.

                   Clifford Bass

I had a question that may seem simple but I'm having some problems.
I'm kind of learning Access 2003 by the seat of my pants, though I'm
fairly tech saavy and in IT, it's just not something I've worked with
a lot.

I have an Access DB.
One table: "QA Form"
Two forms: Short Audit Form "QA Form QC" and Long Audit Form "QA
Form"
       (only difference between the forms is there are some fields on
the long that don't appear on the short)
Both forms enter data onto the "QA Form" table.  (If using the short
form, the fields that don't appear on the short form are simply blank
on the table)

Two reports:  Short Form report "QA Form QC" and Long Form Report "QA
Form Reg"
 There's a button on each form that saves the record then dumps the
form info onto the appropriate report that looks good for printing.

I have a Query-by-Form style form/query setup to find previous records
and display them within a Datasheet view or the appropriate report
view.

One functionality I am unable to figure out is how to be able to
reopen a table record in the appropriate form to edit that record in
form view.  I can edit the table or in datasheet view.  But my users
will not want to use either method;
they'll simply want to be able to bring up the previous record in the
appropriate form for editting and saving.

Is this possible?
To give users the capability to search out a previous record, have
that record populate the appropriate form, be editted, and then save
the editted record's changes to the table?- Hide quoted text -

- Show quoted text -

The users cannot cycle through records. This has been disabled. The
users enter their audits, save them and print them. If they want to
reprint an old audit, they use the QBF to query and open a record in
the appropriate report. What I'd like is to be able to search for,
find, and open a record in form view to edit and save it.

Differentiation between the forms is through an invisible check box
called QC. On the Long form, the check is by default unchecked and
since it's invisible, can't be checked. On the short form, this
checkbox is checked and can't be unchecked.

 

[Clifford Bass]

Hi,

I don't understand why you disable browsing through existing records if
you then plan to let the users edit them in some other fashion. However that
is not that important. How about this: An "Edit" button on your
query-by-form form. Its on click event containing something like:

DoCmd.OpenForm "QA Form QC", , , "[MyPrimaryKeyField] = " & _
[txtMyPrimaryKeyField].Value, acFormEdit

Where MyPrimaryKeyField is the name of your primary field (assuming
numeric) and txtMyPrimaryKeyField is the field on the query-by-form form that
contains the resulting primary key of the row the user wants. You would
obviouly need to check your QC value to determine which form to open.

Hope that helps,

Clifford Bass

Hi,

I imagine that you should be able to use the same appropriate forms to
do that. Do they only allow for adding new records? If so, you can change
each form's "Allow Edits" property to "Yes". Then the person can navigate
through all of the records, searching (use the binoculars button) and
modifying as needed. You may wish to use a filter of some sort to limit the
appropriate rows to the appropriate forms. So, if you have a field named
Version that holds "L" for Long and "S" for Short, you could make the filter
for the long version form [Version] = "L". Likewise for the short one.

If that does not help, please post additional details.

Clifford Bass

I had a question that may seem simple but I'm having some problems.
I'm kind of learning Access 2003 by the seat of my pants, though I'm
fairly tech saavy and in IT, it's just not something I've worked with
a lot.

I have an Access DB.
One table: "QA Form"
Two forms: Short Audit Form "QA Form QC" and Long Audit Form "QA
Form"
(only difference between the forms is there are some fields on
the long that don't appear on the short)
Both forms enter data onto the "QA Form" table. (If using the short
form, the fields that don't appear on the short form are simply blank
on the table)

Two reports: Short Form report "QA Form QC" and Long Form Report "QA
Form Reg"
There's a button on each form that saves the record then dumps the
form info onto the appropriate report that looks good for printing.

I have a Query-by-Form style form/query setup to find previous records
and display them within a Datasheet view or the appropriate report
view.

One functionality I am unable to figure out is how to be able to
reopen a table record in the appropriate form to edit that record in
form view. I can edit the table or in datasheet view. But my users
will not want to use either method;
they'll simply want to be able to bring up the previous record in the
appropriate form for editting and saving.

Is this possible?
To give users the capability to search out a previous record, have
that record populate the appropriate form, be editted, and then save
the editted record's changes to the table?- Hide quoted text -

- Show quoted text -

The users cannot cycle through records. This has been disabled. The
users enter their audits, save them and print them. If they want to
reprint an old audit, they use the QBF to query and open a record in
the appropriate report. What I'd like is to be able to search for,
find, and open a record in form view to edit and save it.

Differentiation between the forms is through an invisible check box
called QC. On the Long form, the check is by default unchecked and
since it's invisible, can't be checked. On the short form, this
checkbox is checked and can't be unchecked.

 

[colvind]

Hi,

     I don't understand why you disable browsing through existing records if
you then plan to let the users edit them in some other fashion.  However that
is not that important.  How about this:  An "Edit" button on your
query-by-form form.  Its on click event containing something like:

    DoCmd.OpenForm "QA Form QC", , , "[MyPrimaryKeyField] = " & _
        [txtMyPrimaryKeyField].Value, acFormEdit

     Where MyPrimaryKeyField is the name of your primary field (assuming
numeric) and txtMyPrimaryKeyField is the field on the query-by-form form that
contains the resulting primary key of the row the user wants.  You would
obviouly need to check your QC value to determine which form to open.

              Hope that helps,

                    Clifford Bass

Hi,
     I imagine that you should be able to use the same appropriate forms to
do that.  Do they only allow for adding new records?  If so, you can change
each form's "Allow Edits" property to "Yes".  Then the person can navigate
through all of the records, searching (use the binoculars button) and
modifying as needed.  You may wish to use a filter of some sort to limit the
appropriate rows to the appropriate forms.  So, if you have a fieldnamed
Version that holds "L" for Long and "S" for Short, you could make thefilter
for the long version form [Version] = "L".  Likewise for the short one.
     If that does not help, please post additional details.
                   Clifford Bass
:
I had a question that may seem simple but I'm having some problems.
I'm kind of learning Access 2003 by the seat of my pants, though I'm
fairly tech saavy and in IT, it's just not something I've worked with
a lot.
I have an Access DB.
One table: "QA Form"
Two forms: Short Audit Form "QA Form QC" and Long Audit Form "QA
Form"
       (only difference between the forms is there are somefields on
the long that don't appear on the short)
Both forms enter data onto the "QA Form" table.  (If using the short
form, the fields that don't appear on the short form are simply blank
on the table)
Two reports:  Short Form report "QA Form QC" and Long Form Report"QA
Form Reg"
 There's a button on each form that saves the record then dumps the
form info onto the appropriate report that looks good for printing.
I have a Query-by-Form style form/query setup to find previous records
and display them within a Datasheet view or the appropriate report
view.
One functionality I am unable to figure out is how to be able to
reopen a table record in the appropriate form to edit that record in
form view.  I can edit the table or in datasheet view.  But my users
will not want to use either method;
they'll simply want to be able to bring up the previous record in the
appropriate form for editting and saving.
Is this possible?
To give users the capability to search out a previous record, have
that record populate the appropriate form, be editted, and then save
the editted record's changes to the table?- Hide quoted text -
- Show quoted text -

The users cannot cycle through records.  This has been disabled.  The
users enter their audits, save them and print them.  If they want to
reprint an old audit, they use the QBF to query and open a record in
the appropriate report.  What I'd like is to be able to search for,
find, and open a record in form view to edit and save it.

Differentiation between the forms is through an invisible check box
called QC.  On the Long form, the check is by default unchecked and
since it's invisible, can't be checked.  On the short form, this
checkbox is checked and can't be unchecked.- Hide quoted text -

- Show quoted text -

Wish I could paste a screenshot.
The QBF form shows the fields as well as the QC flag checkbox. The
user fills in the search/query criteria and clicks one of two buttons:
Search and View as Datasheet
Search and View as Audit Report

Clicking on the first opens a datasheet view of records that meet the
search criteria entered
Clicking on the second opens the the records returned that meet the
search criteria in the appropriate report view. There they can cycle
from record to record amongst the results.

I'd like a third button to be able to open the resultant records in
form view for editing.

 

[Clifford Bass]

Hi,

Okay, I think I may be understanding a bit better. Is the
query-by-form something you created or are you using Access's "Filter By
Form" option? How do the datasheet and the report know which records to
display?

Clifford Bass

 

[blubman]

Hi,

I imagine that you should be able to use the same appropriate forms to
do that. Do they only allow for adding new records? If so, you can change
each form's "Allow Edits" property to "Yes". Then the person can navigate
through all of the records, searching (use the binoculars button) and
modifying as needed. You may wish to use a filter of some sort to limit the
appropriate rows to the appropriate forms. So, if you have a field named
Version that holds "L" for Long and "S" for Short, you could make the filter
for the long version form [Version] = "L". Likewise for the short one.

If that does not help, please post additional details.

Clifford Bass

I had a question that may seem simple but I'm having some problems.
I'm kind of learning Access 2003 by the seat of my pants, though I'm
fairly tech saavy and in IT, it's just not something I've worked with
a lot.

I have an Access DB.
One table: "QA Form"
Two forms: Short Audit Form "QA Form QC" and Long Audit Form "QA
Form"
(only difference between the forms is there are some fields on
the long that don't appear on the short)
Both forms enter data onto the "QA Form" table. (If using the short
form, the fields that don't appear on the short form are simply blank
on the table)


Two reports: Short Form report "QA Form QC" and Long Form Report "QA
Form Reg"
There's a button on each form that saves the record then dumps the
form info onto the appropriate report that looks good for printing.


I have a Query-by-Form style form/query setup to find previous records
and display them within a Datasheet view or the appropriate report
view.

One functionality I am unable to figure out is how to be able to
reopen a table record in the appropriate form to edit that record in
form view. I can edit the table or in datasheet view. But my users
will not want to use either method;
they'll simply want to be able to bring up the previous record in the
appropriate form for editting and saving.

Is this possible?
To give users the capability to search out a previous record, have
that record populate the appropriate form, be editted, and then save
the editted record's changes to the table?