Recent content by pradeepiyer

:cool::):):):cool:

Anybody to help??

Sorry, I meant this....create the field with type "Calculated Field" and provide the formula in the expression.

Welcome Darwin. I also registered in this site today since I'm an Access user these days and I'm getting solution for all the problems right here. Have a nice time here :)

You wont be able to update the description field "automatically". For that, you would have to declare the field as calculated field and provide the formula (as you mentioned). To handle this through VB code, you need to have a triggering event and upon that, you can use this code: Code...

Try this: CurrentDb.Execute "DELETE FROM Type WHERE Project_ID = " & Me.Project_ID & " AND [Type] = '" & Me.Txt_Type & "'"

I have a table in my Access 2010 Database with few date/time fields. I have set different formats like Short Time, Medium Time etc. But when I link this table to Sharepoint list, all the date/time fields have been modified to their default format (General Date). Is there a way we can keep the...