Concatenation problem (Access 2002)

Topic

New Reply

Hey gang!

Having some difficulty getting a concatenation to work properly. I’d really appreciate someone’s help.

In the attached gif, you will find some code, screenshoot of an access table and an error message. I’m trying to create a filename (complete with path) from data found in the table. I’m using DLookup to capture the information out of the table. I’ve trying playing with the placement of quotemarks, etc, but Access doesn’t seem to be concatenating it. I’m sure I just have a misplaced quotemark somewhere.

Reply | Quote

Replies

You have put an expression in the FileName field in the table. The DLookup to fill strFileName will retrieve the literal text of the expression, it won’t evaluate it. I suggest just putting FolderSize_ in the FileName field, and to use this:

strFileName = DLookup(“FileName”, “tblConfig”, “UseThisConfig = True”) & Format(Date, “yyyymmdd”) & “.xls”

By moving the variable part to the code itself, you allow Access to evaluate it.

Reply | Quote

Great sugguestion, Hans. Works like a charm.

Reply | Quote

Great sugguestion, Hans. Works like a charm.

Reply | Quote

You have put an expression in the FileName field in the table. The DLookup to fill strFileName will retrieve the literal text of the expression, it won’t evaluate it. I suggest just putting FolderSize_ in the FileName field, and to use this:

strFileName = DLookup(“FileName”, “tblConfig”, “UseThisConfig = True”) & Format(Date, “yyyymmdd”) & “.xls”

By moving the variable part to the code itself, you allow Access to evaluate it.

Reply | Quote