Appending date to filename

[mp3909]

I'm looking into this database that someone had created.


There is a table called tblImportFiles.
I need to change the Filename for the second record in this table to a filename that appends the date. You get the date from a table called tblCDate that has a field calld COBDate.

There is a function built inside the VBA editor called fDateInString that taks 2 parameters.
A query called qsel_ImportFiles uses all of this to create this final output.

Everytime I close and open the database the first thing I get is a message box saying Enter Parameter Value for qsel_ImportFiles.Filename.
I don't get it because it doesn't ask this for the field called qsel_ImportFiles.Folder and that makes use of the VBA function fDateInString

What is wrong please?

[Micron]

Everytime I close and open the database the first thing

you get that prompt when opening, and again when closing? Opening makes some sense; not so much closing, unless code on form closing is involved.

Possibly a particular form is set to open by default when the db opens and it is directly or indirectly causing your query to run - and that query is looking for a form field on a form that isn't open at the time.

[isladogs]

I wonder whether the code is having trouble with using # as part of your filename and filepath fields.
Try editing those paths so there are no special characters and see if the code runs without asking for a parameter

[Gina Maylone]

I agree with Colin, ampersands can cause havoc when used in file names, commas are a problem too.

[Micron]

I agree with Colin, ampersands can cause havoc when used in file names, commas are a problem too.

Ampersand is &
Maybe you meant the hash or octothorpe?

[Gina Maylone]

Well, duh. Pound sign? ## :-)

[isladogs]

Hi Gina
Of course in the UK a pound sign is a £....
Any special character such as & ' - will all cause difficulties but perhaps the # sign is the worst due to its use in dates.
Having files or folders with #yyyymmdd# or similar as part of the name is asking for trouble.
In fact I'm surprised its allowed but a quick check shows it can be done

[Gina Maylone]

LOL! How confusing its all become :-)