Copy field to neighboring fields in datasheet

  • Thread starter Thread starter Jeff S via AccessMonster.com
  • Start date Start date
J

Jeff S via AccessMonster.com

I have a subform (datasheet view) that collects information about different
products. The left part of the data sheet has columns concerning the first
part of a process. The Right part has fields concenring the second part of
the process.
Usually when a new record is entered, only the left part is filled. After
that, the records are pulled and the 2nd par of the record is finished. Which
means that for a while the right part of the sheet is left blank. When it is
time to update these blank fields, there is a lot of data entry to complete
all the records.
I would like to automate the data entry in the columns on the right. I would
like to be able by dble clicking on a field to automatically fill the record
on the line below with the same information without adding a new record.
My coding skills are weak and any help is welcome.
 
Jeff,

You would probably be able to do this with an Update Query.

However, are you implying that you have multiple records with exactly
the same information repeated in the "right columns"? If so, it could
indicate that a revision of your table design would help. Can you post
back with some more details about the data in this form, and the two
processes, and some examples?
 
Steve,

Thanks for responding.
This suform contains information about products placed on hold. Each record
of the main form is 1 day of production. The subform captures the hold events.

To the left of the datasheet I have the hold # (autonumber) and information
about the product on hold (product name, UPC#, Production line) and the
reason why it was placed on hold. For each of the product listed a
disposition is issued several days after entering the product information and
documented on the same line. So for a certain amount of time, the disposition
is left blank. When I need to populate the blank field some of the
dispositions might be the same from one line to the next.
So instead of type each disposition for each line or even taking the time to
copy and paste the cells I would like to be able to dble clic on 1 cell and
it would copy the same information on the cell below. I even would like to
copy 3 cells at the same time.

To complicate matters, I have a filter on my subform that takes the value of
a combo box in the main form to sort records by line. This means that my
displayed records on the subforms are not necessarily sequential (some
records are skipped when the filter is on).

The double clicking would have to copy info from one field to the field below
without using the sequence given by the record number

Do I make more sense?

Let me know

Thanks

Jeff





Steve said:
Jeff,

You would probably be able to do this with an Update Query.

However, are you implying that you have multiple records with exactly
the same information repeated in the "right columns"? If so, it could
indicate that a revision of your table design would help. Can you post
back with some more details about the data in this form, and the two
processes, and some examples?
I have a subform (datasheet view) that collects information about different
products. The left part of the data sheet has columns concerning the first
Click to expand...
[quoted text clipped - 9 lines]
on the line below with the same information without adding a new record.
My coding skills are weak and any help is welcome.
Click to expand...
Click to expand...
 
Jeff,

Access has a built-in keyboard shortcut for doing this sort of
functionality: Ctrl+' (hold Ctrl key and press apostrophe key). Does
that suit your purpose?
 
I know... but it would be faster to be able tto dble clic. In fact if I was
able to write the code for the fonction that does the ctrl " I could tweak it
to have 3 fields filled out with one dble clic

Steve said:
Jeff,

Access has a built-in keyboard shortcut for doing this sort of
functionality: Ctrl+' (hold Ctrl key and press apostrophe key). Does
that suit your purpose?
Steve,
Click to expand...
[quoted text clipped - 29 lines]
Jeff
Click to expand...
Click to expand...
 
Jeff,

Fair enough. I would personally find a keystroke quicker than a mouse
click, but obviously that's a personal habits thing.

So, therefore we go back to my original suggestion. Make an Update
Query which will update the Disposition for the required record(s), and
then use an OpenQuery action in your Dbl Click macro to run the update.
 
Back
Top