Query Criteria

[Lstclair]

Hi,

I have lots of queries, 100 plus and some of them have Environ("Username") in them as the criteria.

Is there a way, other than going into each query to see if that criteria exists to update it from vba code to search that string in the queries one by one and replace with the modern version?

The reason I ask is that we are trying to upgrade our database from Access 2000 to 2013 and this might be the final bit we need to change, but don't look forward to looking for it and changing this in 100 + queries

 

[spikepl]

download the free v-tools

 

[Lstclair]

Thanks.

Just downloaded and won't install because it is version 2013 i am using.