ThaiByThai
Registered User.
- Local time
- Today, 08:46
- Joined
- Aug 12, 2009
- Messages
- 21
Hello -
I'm tying to do a mass update adding notes to our Access 2007 database, but I'm running into an issue -
I am matching an empyee ID worksheets up with our master table in access 2007. i would like to add a note that say:
Date: Batch update: subj is part of upgrade project. subj has close "type of duties" (this is a field in the form that i want it to auto populate with matching ID) of "COMPLETION_DATE " (again part of the form that i would like to auto populate)
I try update it using this
but this just udpate the raw format:
this is what it's updating
=( its not auto populating the information from the table... is there away i can do this?
I'm tying to do a mass update adding notes to our Access 2007 database, but I'm running into an issue -
I am matching an empyee ID worksheets up with our master table in access 2007. i would like to add a note that say:
Date: Batch update: subj is part of upgrade project. subj has close "type of duties" (this is a field in the form that i want it to auto populate with matching ID) of "COMPLETION_DATE " (again part of the form that i would like to auto populate)
I try update it using this
Code:
[ConfirmationComment] & Chr(13) & Chr(10) & "8/05/2011: Batch update- Subj is part of UPGRADE project. Subj has close " & "[dbo_MASTER DATABASE].[type of duties]" & " of " & "[COMPLETION_DATE]"but this just udpate the raw format:
this is what it's updating
Code:
8/05/2011: Batch update- Subj is part of UPGRADE project. Subj has close [dbo_Master DATABASE].[TYPE_OF_DUT] of [txtCOMPLETION_DATE]=( its not auto populating the information from the table... is there away i can do this?
