Update date

[BorisGomel]

Hello,


I am new in Access so help will be graetly appreciated. I have failry large Access database on my job which consists two large tables- CapOneRemit and CapOneWireShedule. The table are populated from Excel via macros.Sometimes, I need to update dates (the filed is-"remitdate" teh same in both tables) and to do so I have created two update queries-CapOneDateUpdate and CaponeWiredateupdtae to update f.e 09/16/2001 t 09/15/2011 .I would like to create a form(frmupdatesupdate) with two text boxes on it and with command button .So , if I would like to update dates I type in form update date and criteria and by cliking command buton make update. Can I link text boxes on the form to updates oueries via vb code.
Thank youi for help.
Best Reagrds,

Boris

[pbaldy]

You don't need VBA code; this should work:

UPDATE CapOneRemit
SET remitdate = Forms!FormName.TextboxName
WHERE remitdate = Forms!FormName.AnotherTextbox

[BorisGomel]

Thank vey much pbaldy!!!

Just one small questins -I need to type this
"UPDATE CapOneRemit
SET remitdate = Forms!FormName.TextboxName
WHERE remitdate = Forms!FormName.AnotherTextbox "
in the command button even click ?
Thank you in advance,
Best Reagrds,

bORISgomel

[pbaldy]

No, that's a query. You can execute it from code, but not directly in the property like that. First you'd get into the VBA editor for that event:

http://www.baldyweb.com/FirstVBA.htm

The code would look like:

  Dim strSQL                  As String

  strSQL = "UPDATE CapOneRemit " _
         & "SET remitdate = #" & Forms!FormName.TextboxName & "# " _
         & "WHERE remitdate = #" & Forms!FormName.AnotherTextbox & "#"

  CurrentDb.Execute strSQL

Correcting all the names of course.

[BorisGomel]

Thank you very much pbaldy,

I did as you showed me and it is working nicely .

Thank you again,

the Best regards,

BorisGomel

[pbaldy]

Happy to help!