G
Guest
.... does it work? I'm getting an error (type mismatch) and don'ty know if
I've used it incorrectly or if it simply doesn't work in VBS.
I've used it incorrectly or if it simply doesn't work in VBS.
Easy, Sue.Sue said:How would anyone be able to tell without seeing your code?
I have a custom form with a combo-box control. The Combo-box is populated
with data from an Access database using DAO. It works fine, but there's one
minor issue with remote users. If they aren't connected to the company
network, they obviously can't populate the combo-box and the form errors out,
which is fine, but r_e_a_l_l_y s_l_o_w_l_y, which is not fine.
The problem is that the error is generated by this line of code:
Set DatBase = DBEngine.OpenDatabase(strDBPath & strDBName)
I'm sure if I knew how to test whether strDBPath was a valid path before
calling the OpenDatabase object, it would be seconds quicker, but I don't
know how to do it. This must be easy, but I don't really know where to start
with it.
Can anyone advise?
Thanks in advance
Vaughan
---... does it work? I'm getting an error (type mismatch)
and don'ty know if I've used it incorrectly or if it
simply doesn't work in VBS. +++
Any other chance to get file/dir information?
Vaughan said:To make it work on my machine I had to add the
Scriting runtime Library to the list of references in Outlook.
Will I need to
do this for everyone who uses the form, or can I get the library to be added
by coding it in the form somehow?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.