Search results for query: *

mainly looking to put in a VB script that will return all the names, logonid's for a specified domain. regards

looking to run a script to return user names on a Domain either in dos or VB. Can anyone help.. many thanks

Tony yes agreed Len is does return the length of the field, my code ; par = "Select * from core1 order by idnumb" Set db = OpenDatabase("x:\??_PEN\EXXXX\Ex201.mdb") Set rst = db.OpenRecordset(par) If Left(rst.Fields(1).Value, 2) = "DJ" Then On Error GoTo goose ads1 =...

Tony It may be that the "," is causing the recorset to think it is another feild. the following; "DJ020040201GN EXXXX 712 QUEENS GARDENS 13 OLD PEAK ROAD, MID LEVELS HONG KONG "...

I am writing a sql statement in VBA access using recordets, where the table only has one text column. the select statement used is as follows; par = "Select * from core1 order by idnumb" Set rst = db.OpenRecordset(par) ads1 = Len(rst.Fields(1).Value) the text in the table in one column in...

Many thanks michaelbr55 I will give it a go.

I am looking to read some information from a fixed width text file. Using VBA in Access i want to put an if statement depending on the first two characters. Then I want to change one of the characters. can anyone point me in teh right direction and perhaps supply me with some sample code.