Macro wizard in access 2007

[Pusher]

Hi all,

How do I start a macro wizard in access 2007?

How do i make a macro for copying data from one form to another form?
Thanks

 

[Alansidman]

Here is some code to copy the values in four text boxes into a new record. Put this on a command button in the on click event.

[FONT=Arial Unicode MS][SIZE=2]Private Sub copyrecordbutton_Click()[/SIZE][/FONT]
 
[FONT=Arial Unicode MS][SIZE=2]On Error GoTo Err_copyrecordbutton_Click[/SIZE][/FONT]
 
[FONT=Arial Unicode MS][SIZE=2]Dim pown As Variant[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]Dim psource As Variant[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]Dim pclient As Variant[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]Dim ptax As Variant[/SIZE][/FONT]
 
[FONT=Arial Unicode MS][SIZE=2]pown = txtcurrent1.Value[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]psource = txtcurrent2.Value[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]pclient = txtcurrent3.Value[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]ptax = txtcurrent4.Value[/SIZE][/FONT]
 
[FONT=Arial Unicode MS][SIZE=2]RunCommand acCmdRecordsGoToNew[/SIZE][/FONT]
 
[FONT=Arial Unicode MS][SIZE=2]txtnew1.Value = pown[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]txt2[/SIZE][/FONT][FONT=Arial Unicode MS][SIZE=2]new.Value = psource[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]txt[/SIZE][/FONT][FONT=Arial Unicode MS][SIZE=2]new3.Value = pclient[/SIZE][/FONT]
[FONT=Arial Unicode MS][SIZE=2]txt[/SIZE][/FONT][FONT=Arial Unicode MS][SIZE=2]new4.Value = ptax[/SIZE][/FONT]
 
[FONT=Arial Unicode MS][SIZE=2]Exit_copyrecordbutton_Click:[/SIZE][/FONT]
[SIZE=2][FONT=Arial Unicode MS]Exit [/FONT][/SIZE][SIZE=2][FONT=Arial Unicode MS]Sub[/FONT][/SIZE]
[FONT=Arial Unicode MS][SIZE=2]Err_copyrecordbutton_Click:[/SIZE][/FONT]
[SIZE=2][FONT=Arial Unicode MS]MsgBox Err.Description[/FONT][/SIZE]
[SIZE=2][FONT=Arial Unicode MS]Resume Exit_copyrecordbutton_Click[/FONT][/SIZE]
[FONT=Arial Unicode MS][SIZE=2]End Sub[/SIZE][/FONT]

Perhaps this concept will get you started in the right direction. I do not use Macros in Access -- only VBA.

Alan