Search results for query: *

I have two domain controllers in my windows 2000 Active Directory domain which was set up before I started working for my current employer. I'm retiring one of them. I was previously told it is the "main" domain controller? What does that mean? Is there a "primary domain controller" in...

In my workplace we just recently stripped all our users of administrative rights. Of course we get the usual complaints of "I can't install my [insert ad-ware bundle programs] anymore". But we also have gotten some legitimate complaints as well. One complaint is that some users leave their...

Hello, I've written a macro that compares two excel files (fileA and fileB) row by row to look for rows that are duplicates (that are in both file). Each row in each file has a patient ID (ie. A4522335) and a visit number (ie. 3). If two rows in both files have the same patient ID and visit...

I'm writing a macro in excel to search through a worksheet of data and find similar rows of data in a different worksheet. One of the items I'm comparing in each row is a field called "Visit Number". They are entered slightly differently in each worksheet. For instance in one worksheet the...

Hi, I'm a fairly new mac user (actually, I'm supporting them along with PC's now at my job). I've got an older G3 powerbook I just installed Mac OS 9 on. (It had OS 8 on it. It's too old to take OS X). I inserted the OS 9.2.2 CD, restarted the computer, and held the "c" key down on the...

Hello, I've got thousands of tab-delimited text files in one folder and its 20 or so subfolders (which themselves have subfolders) that look like the following: #################### PROTOCOL LABID ASSAYID SPECID PTID VISITNO... 045 XG CF30-07 W004406 124050034 06... 045 XG CF30-07 R021603...

Hi there, I've written a macro that opens a tab-delimited text file in excel that looks like: ---------- PTIDS Unknowns[Dilution] Un01 1 Dilution Factor 100 PTIDS Unknowns[Dilution] Un02 1 Dilution Factor 100 PTIDS Unknowns[Dilution] Un03 1 Dilution Factor 100 PTIDS Unknowns[Dilution]...

Hello, I'm writing a macro that collects data from one workbook (the source) and writes it row by row to another (the destination). I'd like for it to be able to be run when data already exists in the destination, and automatically find the first empty row and start appending data there...

I know that in windows xp, to print to a printer on the network you just click on "add printer" in the printers/faxes area of the control panel, select "local printer", and select "create TCP/IP port". How can one print over TCP/IP from Windows 98? I have a few...

Hi all, I'm trying fix a broken append query in an access database, which has been tossed to me at my new job. I'm relatively new to using Access, so I read through the book "Microsoft Access 97" by microsoft press from front to back over the holidays (I'm using Access 2002, but the...

Hi folks, I would like to write or record a macro in excel that will first check and see how many rows are 'occupied' in Sheet1 of a workbook, and then, in Sheet2 of the same workbook, delete all rows under that and write '~End' in the first row under that. So for example, if 8 rows are...

Hi folks, In an excel workbook (in excel 2002), I need to conatinate three columns from an excel one worksheet (Sheet1) into one column in another worksheet (Sheet2). The columns are PatientID (such as A04100108), VisitNumber (such as 06), and VisitDate (such as 7/23/2002). I'm using the...

Slashdot reports (http://slashdot.org/articles/04/01/04/2158233.shtml?tid=109&tid=185&tid=187&tid=190&tid=201) that Microsoft is ending extended support for windows 98. Does this mean windows updates won't supply updates if I need to re-install my copy of windows 98 on my machine? Should I...

I'm working with two tables, one called the "log" table and one called the "data" table. I have a command button set up to do an append querry. I want the append querry to append all the records from the log table that aren't already in the data table. Right now, I have...