Errors opening Excel file from within Access

[wilkisa]

My user has created a small switchboard in Access. He has a dropdown box that contains, for example, 1ST GRADE, 2ND GRADE, 3RD GRADE. He then has a command button that is designed to search his file folders for any filenames that contain the string that is selected in the dropdown box. The problem is the space in the string causes an error.

Example: suppose he selects 1ST GRADE. It should search for all files with 1ST GRADE in the name. He gets an error that says the file 1ST.XLS can't be found; then he gets an error that says the file GRADE.XLS can't be found. Any way to make the two words stay together?

Thanks for any help we can get!!!

 

[anvil19]

Hi wilkisa

User Emily had a similar question on the Excel board a short while back.

See http://www.mrexcel.com/board2/viewtopic.php?t=89630

anvil19

 

[wilkisa]

Thanks, Anvil19, that is the answer I was looking for. I had searched for this topic but didn't find this response.

I appreciate the help.