Multiple field copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to copy a series of unbound controls (up to 6, actual data
value from Table A) from one control to another field on the same form.
Instead doing this one at a time copy and pasting, i would like to do this
through a command button (or better automation) when pressed will copy
contents of all controls on left side of form from (Table A) to like
controls/fields on left side of form (Table B). The two tables are not
linked and dont have any relationship. Not great at using VBA so other
solutions preferred.
 
Chuck hi,

You would need to program Access in some way to accomplish that. If you
don't wish to use VBA, the only other way is to write macros - use the
"SetValue" command in this case.

Regards/JK



|I would like to copy a series of unbound controls (up to 6, actual data
| value from Table A) from one control to another field on the same form.
| Instead doing this one at a time copy and pasting, i would like to do this
| through a command button (or better automation) when pressed will copy
| contents of all controls on left side of form from (Table A) to like
| controls/fields on left side of form (Table B). The two tables are not
| linked and dont have any relationship. Not great at using VBA so other
| solutions preferred.
 
any suggestions on VBA code example?
I guess i would set value of the field in table B = to value in table A and
keep repeating this in the macro?
 
Hi Chuck,

Assuming all contros are on the one form you would use the OnClick event of
the Command button to attach a macro with consecutive SetValue.

in VBA you attach an event procedure:

Private Sub YourButtonName_Click()
Me.BoundControlName1=something1
Me.BoundControlName2=something2
Me.BoundControlName3=something3
Me.BoundControlName4=something4
'etc
End Sub

Apology for the late reply

Regards/Jacob



| any suggestions on VBA code example?
| I guess i would set value of the field in table B = to value in table A
and
| keep repeating this in the macro?
|
| "JK" wrote:
|
| > Chuck hi,
| >
| > You would need to program Access in some way to accomplish that. If you
| > don't wish to use VBA, the only other way is to write macros - use the
| > "SetValue" command in this case.
| >
| > Regards/JK
| >
| >
| >
| > | > |I would like to copy a series of unbound controls (up to 6, actual
data
| > | value from Table A) from one control to another field on the same
form.
| > | Instead doing this one at a time copy and pasting, i would like to do
this
| > | through a command button (or better automation) when pressed will copy
| > | contents of all controls on left side of form from (Table A) to like
| > | controls/fields on left side of form (Table B). The two tables are
not
| > | linked and dont have any relationship. Not great at using VBA so other
| > | solutions preferred.
| >
| >
| >
 
Back
Top