Recent content by mcarlin

Ha! Alot shorter than I was going for - thanks!

Hi - Given a string which contains spaces and special characters - i.e. @, #, $, %, ^, ., etc. - I want to convert the string from, say, "TEMP. HOT WATER #2" to "TEMP_HOT_WATER_2", for example. Essentially, I want to replace all spaces and special characters with "_". However, I do not want...

Thanks very much!

Try using x = "NE1220904" y = Left(x, 5) 'keep 5 left-most chars z = Right(y, 3) 'keep 3 right-most chars z should contain "122" Hope this helps!

Figured it out, thanks!

Hi - I've searched the forms for any solutions/ideas but I'm still not sure. I want to pass a search parameter from a form to a query then use the query results to populate a multi-column list box. So far, I can pass the parameter to the query and generate results, however, I want the query...

Hi - I've searched the forms for any solutions/ideas but I'm still not sure. I want to pass a search parameter from a form to a query then use the query results to populate a multi-column list box. So far, I can pass the parameter to the query and generate results, however, I want the query...

Hi - This is my first time posting, so please bear with me. I appreciate anyone who reads and has any advice they can offer :) Two years ago, I created a database (~3700 records) of original construction drawings for a company as part of a digital archiving project. Earlier this year, the...