Search results for query: *

I am trying to use a combination of dsquery piped to dsget to determine which users in a specific OU have dialin permissions set to "Allow" on the DialIn tab in AD. I have the dsquery part down, but can't find any documentation on what parameters to use for the dialin tab options. If anyone...

http://www.partition-recovery.com/ Like I said. It worked like a charm (though I had not written any data to the deleted drive or created a partition over it / formatted it. I'm sure there's some sort of freeware util that does the same thing. I just didn't have time to look much. The...

I finally ended up downloading and paying for Active@'s utility. It worked well, though I wish I could have found a free util since this is probably the only time I'll use this one.

To make a long story short, I had 2 disks in a mirrored set on a SATA RAID chip. One drive went bad and I received a replacement drive. When I put it in and broke/recreated the mirror set (no "rebuild" option available), it mirrored the blank drive ove the drive full of data. No data has been...

I have no problem determining the error number on forms, but how to I determine the error number when the error is generated by a query? Also, if I want to put in an error trap to replace the default message the query error returns, where does that go?

I figured it out. It was one of those things you slam your head into a wall because of. I had forgotten to specify the format as a date format, so I think it was taking the data entered into the field as a string. That would explain why it would take = since the data entered (today's date)...

I want to throw an error if the date entered is a future date. The validation rule won't accept <=Date() When I enter that in the Data Validation field, it doesn't matter what date I enter, nothing happens. It will take =Date() just fine though. What am I doing wrong?

Their opinion is that we received a bad batch of power supplies, bud they don't know how many are bad. Basically, when we told them we were buying 450 PCs but would be receiving them over a period of time, they set aside the parts for 450 PCs. Apparently a bad batch of power supplies must have...

My friend has an Antec TRUE 330 power supply. He usually keeps his PC going at all times but turned it off the other day and just turned it on this morning. He immediately noticed that the PS fan was not going and turned it off within a matter of minutes. On most PSs, I'd say this was a...

Yes. So what happens if the PC tries to draw max on those two when the max indicated is 185W?

Do the numbers add up correctly for a 200W power supply? I'm not sure which cable colors to add together, etc. I keep getting somewhere in the high 260s, but I may be doing something wrong.

We ordered 450 or so identical desktop PCs (small form factor). The power supplies keep going out on them and I think that it is because they are underpowered, but am not knowledgeable enough to decipher the readings on the PS label to figure out what I need to know. Can anyone explain this to...

I have a macro (3 similar ones actually - all with the same problem) that worked fine until I installed SP3 for Office XP and now receives an error. There are about 5 of us in my office and we tested it on every machine and confirmed that it is SP3 that causes the problem. I have a form that...

Any idea what's wrong with this? It looks like it might work, but there is something wrong with the JOIN syntax. I'm fairly new to SQL, so I'm probably missing something obvious. SELECT tBranches.Branch, tDates.Dates FROM tBranches B, tDates D LEFT JOIN tTapesReceived T ON D.date = T.date AND...

I think this might work. Let me work on the SQL and see if I can get it to work in my situation. Do you happen to have the SQl for the query that you used? It might be easier for me to figure out how to set it up for my data if I see how you set it up.

I'm not sure if that will work. I also may not be explaining myself right. I need a query that prompts me for a date range (usually use &quot;between [from] and [to]&quot;). Once I've given it a date range (we'll say 02/01/04 - 02/04/04 for this example) it says, site A didn't receive a...

I have a database that tracks tape backups. We, like most people, have many sites (68) that do tape backups each night to a tape. There are 20 tapes - Mon-Fri in 4 different colors, one color for each week. Blue Monday, Pink Friday, etc. The sites then send the tapes to me for temporary...

I have a database that tracks tape backups. We, like most people, have many sites (68) that do tape backups each night to a tape. There are 20 tapes - Mon-Fri in 4 different colors, one color for each week. Blue Monday, Pink Friday, etc. The sites then send the tapes to me for temporary...

I forgot to mention how the items are stored in the records. Each time an item is shipped, there is a single field called &quot;ITEM&quot; that list the item shipped. They choose this from a drop down on a form. This is why 24 seperate queries are necessary. I have to have a query that pulls...

I have 24 seperate &quot;count&quot; queries totalling different thing in different ways. They all run off of the same table. There is no way to consolidate the queries into one, or even a few. How can I get these all onto one report? A little background info: this is a shipping database...