Recent content by Slarti

Thanks bjd4jc/HydraNL that kinda negates the procedure I was trying to write which would have identified the sharenames on each server. cheers, S.

I'm trying to use the FileSystemObject to identify the names of folders on a server. I've tried various combination of Set fFAP = FSys.GetDrive("\\JDH00674") and get an invalid procedure call or argument, trying Set fFAP = FSys.GetFolder("\\JDH00664") I get path not found when I know the path is...

Thanks all.

Thanks mmilan. I'll persevere.

I've compiled a dll which compacts databases given the filepath, password etc of the DB and it works just fine, however I test for an ldb using FileExists and if this returns True the dll doesn't compact but reports back to the user via a MsgBox. The report only works in the design environment...

Thanks TysonLPrice that's certainly helped. However it only checks the printers set up on my base. I'm on a base on one server but have access to 15 or so servers that I'd like to search for a printer regardless of whether it's set up on my base or not.

I'm trying to confirm the presence of a printer on a server. I have an array of servers and intend looping through them using a function such as FileExists to identify where the printer is. Is there such a function as PrinterExists and if so what references do I need? TY.

The problem was that the workbook had been protected - Doh!

I'm getting an error message 1004 Unable to get to the Add property of the sheets class when trying to add a worksheet to a workbook. Any ideas as to what could be causing this. I don't get it with every workbook which makes it more annoying! TY.

Ask your Users what they'd like. Prototype your ideas and let them tell you what best suits them, they'll be using it.

Superb, thanks bjd4c.

Thanks bjd4c. I'll take a look tomorrow in work. Slarti.

Skip, This doesn't mke a difference. I'm using Access '97 is that why? Slarti.

Thanks Skip. I'm out of the office for a day or two but will try this on Friday. Slarti.

I'm using DAO to connect to an Access database and having trouble emptying a Date/Time field in my table. To begin with the field is empty and that's OK, when I enter a date that too is saved, my problems begin when I try to remove the Date. I've tried restting to Null, vbNull and vbNullChar...