Updating from Form to Table (Mulitple fields)

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

Guest

Hi
I have a table with following fields
-Currency
-Currency code
-Action date
26 currencies are added to the table, and Action date field is empty.
I need to update all the 26 fields (in Action date) with a date, from a form
(user input)
Form Name : Currency Input
Field Name : COB (DATE FORMAT)
By inputing COB need to update all the fields of the currecy table
*Actiondate*
In other words Action date = Form!COB

Please help

Thanks
 
in the after update event of the COB field add the following code

DoCmd.RunSQL "UPDATE [Currency Table] SET [Action Date] = #" & Form!COB & "#"
 
Thanks Dennis, helped me lot of time, by the by please suggest me a book
where i can have this do cmd sql examples.

Thanks
rony

Dennis said:
in the after update event of the COB field add the following code

DoCmd.RunSQL "UPDATE [Currency Table] SET [Action Date] = #" & Form!COB & "#"

Rony said:
Hi
I have a table with following fields
-Currency
-Currency code
-Action date
26 currencies are added to the table, and Action date field is empty.
I need to update all the 26 fields (in Action date) with a date, from a form
(user input)
Form Name : Currency Input
Field Name : COB (DATE FORMAT)
By inputing COB need to update all the fields of the currecy table
*Actiondate*
In other words Action date = Form!COB

Please help

Thanks
Click to expand...
Click to expand...
 
This is in the normal Access Help. Look under DoCmd or RunSQL

Rony said:
Thanks Dennis, helped me lot of time, by the by please suggest me a book
where i can have this do cmd sql examples.

Thanks
rony

Dennis said:
in the after update event of the COB field add the following code

DoCmd.RunSQL "UPDATE [Currency Table] SET [Action Date] = #" & Form!COB & "#"

Rony said:
Hi
I have a table with following fields
-Currency
-Currency code
-Action date
26 currencies are added to the table, and Action date field is empty.
I need to update all the 26 fields (in Action date) with a date, from a form
(user input)
Form Name : Currency Input
Field Name : COB (DATE FORMAT)
By inputing COB need to update all the fields of the currecy table
*Actiondate*
In other words Action date = Form!COB

Please help

Thanks
Click to expand...
Click to expand...
Click to expand...
 
Back
Top