File Finding Demo

[Fizzio]

Just created this for a friend (With a teensy weensy bit of code ripping) so I thought I'd post it here. Improvements and modifications always appreciated.

*fixed* version

 

[Shep]

I get a 'Type Mismatch' after selecting the folder to search in, and clicking 'Ok'.

I used the '97 version.

Shep

P.S. I compiled it and tried again, same thing.

 

[Fizzio]

I wasn't sure if it would work in 97. I only have A2k and just converted down. A fix would be most welcome..........

Sorted (I Think) *fixed version above*
The Type mismatch is due to the DAO reference. and the recordset not being explicitly declared as DAO.Recordset.

 

[expublish]

Like it!

Not trying to be a clever dick or anything, but when would you need to use this?

 

[ColinEssex]

It was me that got Fiz to help out.

I was using the "remote" shift key disabler that Hayley posted, then I thought it would be a good idea to have a list of all my Db's so that I can just click on one from the list, use the shift key enabler/disabler or open the Db from there without having to open Access again.

With Hayleys shift key disabler you can enable or disable it without going into the database itself.

So one thing led to another really.

I think that linked to the shift key jobbie it is really brill.

Thanks Fiz

Col

 

[Fizzio]

Col, How about combining the two and posting that (or just send it to me and we'll charge for it )