Search results for query: *

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...

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...

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.

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.

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...

I'm saving Registry Setings using the following code SaveSetting App.Title, "User Settings", vObject, sValue and can see via regedit that these are saved. My problem is retrieving them. I'm using GetSetting App.Title, "User Settings", "Highlight State", g_bButtonHighlight to try to get the value...

Using the code below I retrieve a Recordset from the Excel file and can run and run this code and it works each time. My problem lies in freeing up the Excel file to be read by other users following import of the recordset. Once I've run this, trying to access the file via Excel reports that the...

Is there away to identify whether a User has an Excel file opened before attempting to import into VB allowing me to inform the user of the VB App to try at a later time?Effectively has the Workbook object got an InUse property? thanks, Slarti.

I'm using some code to identify the Users name based on their unique UserID (courtesy of DrJavaJoe) and need to identify which Domain a User is set up in. Is there a way to identify the Domain from the log on script? (The Application that I am writing will be used by the User whose Domain needs...

I'm using Outlook Express v6 to access fsmail and hotmail. I can look at all the local folders except the Inbox for either account which show Not Responding. I can access both accounts via the Internet. If I try to receive email then any new email can get into my Inbox but I still can't view it.

Hi, I support 30 or so distributed Access databases and often only find out one needs a repair when a User calls after 2 to 3 days. Is there a method I can use to detect when a dB has crashed? I can use the OpenDatabase method and loop through the dBs but I run into password problems if...

I'm using VB to connect to an Access database. I have table of customer records and need to search for a customer by name. I'm having trouble searching for names with an apostrophe in such as O'Leary, O'Donnell etc. The SQL I'm using is SELECT * FROM tblCustomer WHERE sName LIKE '*" &amp...

I need to identify the UserName of a person logged onto an NT network. Not the unique identifier that GetUserName finds but resolve that to find the actual name associated with that UserName ie if Arthur Butler logs using 645873 I want my Application to be able to identify that it is Arthur...