add notes to our textbox

[cthai]

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)

but each time i try to do this, it gives me an error message
" The specified field '[TYPE_OF_DUT]' could refer to more than one table listed in the FROM clause of your SQL statement."

[ConfirmationComment] & Chr(13) & Chr(10) & "8/05/2011: Batch update- Subj is part of UPGRADE project.  Subj has close " & [TYPE_OF_DUT] & " of " & [COMPLETION_DATE] & ". & Chr(13) & Chr(10)

 

[randy700]

Does this not work?

[ConfirmationComment] & Chr(13) & Chr(10) & "8/05/2011: Batch update- Subj is part of UPGRADE project.  Subj has close " & [b][red][YourTableName].[/red][/b][TYPE_OF_DUT] & " of " & [COMPLETION_DATE] & ". & Chr(13) & Chr(10)

Randy

 

[cthai]

Hi Randy -

that didnt work... it actually populate the table name in the raw format...

this is out it populated:

8/05/2011: Batch update- Subj is part of UPGRADE project.  Subj has close [dbo_Master DATABASE].[TYPE_OF_DUT] of [txtCOMPLETION_DATE]

is there away i can have it pull the data from the master database.type of dut and completiondate to be fill in?

 

[Andrzejek]

If [TYPE_OF_DUT] and [COMPLETION_DATE] are Fields on your Form

"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)

Do you want to put the data into those fields from your database, or you already have values in those fields and you want to use them in your string?

What does it show in Immediate Window if you do this:
[tt]
Debug.Print "Type of Duty is: " & [TYPE_OF_DUT]
Debug.Print "Compl Date is: " & [COMPLETION_DATE]
[/tt]

Have fun.

---- Andy

 

[cthai]

Hi Andy -

I already have values in those fields and would like to use them in my string.

I try to run the debug.print in access 2007 and it's giving me an error message..

 

[Andrzejek]

What error message are you getting?

Have fun.

---- Andy

 

[cthai]

Hi Andy -

i'm getting an 'Invalid SQL statement; expected ' delete,' insert', procedure, select or update.

 

[Andrzejek]

That's a weird error message ('Invalid SQL statement; expected ' delete,' insert', procedure, select or update) on the Debug line:

I try to run the debug.print in access 2007 and it's giving me an error message

And that's what you get on those lines:[tt]
Debug.Print "Type of Duty is: " & Me.[TYPE_OF_DUT]
Debug.Print "Compl Date is: " & Me.[COMPLETION_DATE]
[/tt]
???

Have fun.

---- Andy

 

[cthai]

yes that was the error message that i get when i try to run the debug print

 

[cthai]

OK i totally apologize for the miscommunication... i am running this in SQL access 2007 not the vb.

 

[Andrzejek]

So where do you have this code:

[ConfirmationComment] & Chr(13) & Chr(10) & "8/05/2011: Batch update- Subj is part of UPGRADE project.  Subj has close " & [TYPE_OF_DUT] & " of " & [COMPLETION_DATE] & ". & Chr(13) & Chr(10)

If it is NOT in VBA?

Have fun.

---- Andy

 

[cthai]

Hi Andy -

I have it in my UPDATE query in Access 2007-

 

[Andrzejek]

But your [TYPE_OF_DUT] and [COMPLETION_DATE] are Fields on your UserForm, right? If so, what's the name of your UserForm?

Because this may work:

[ConfirmationComment] & Chr(13) & Chr(10) & "8/05/2011: Batch update- Subj is part of UPGRADE project.  Subj has close " & 
[blue]UserFormName.[/blue][TYPE_OF_DUT] & " of " & [blue]UserFormName.[/blue][COMPLETION_DATE] & "." & Chr(13) & Chr(10)

Have fun.

---- Andy