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

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

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

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

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

I have a form called fRMALookup that people will be using to browse/edit existing records. I have the form set to not allow edits by default. I also have a &quot;Save Changes&quot; button that will set Me.AllowEdits=False after saving the record so that they will go back to read-only mode...

I have a form where I need to enter name, address, phone number, gender, age, etc. of people. That wouldn't be a problem except that I need the form to have fields where I can enter 20 people into the form and then, with the click of a button, have it create a SEPARATE record for each person...

I have a table that tracks tape backups for multiple locations. There are 65 locations. The table consists of a single [Date] field, a single [EnteredBy] field, and 130 fields (2 per site). We'll start with the first site, whose site name is &quot;001&quot;. It's two fields are [001a] and...

I need to figure out how to do this in SQL each record in my table has the following fields: Date, EnteredBy, 001a, 001b, 002a, 002b,...,065a, 065b. (yes, that's a LOT of fields - but it's necessary) Each number (001, 002, etc) corresponds to an employee The &quot;a&quot; fields have a value...

I have a form that needs two things to happen. First, it needs to run the following code: Dim blRet As Boolean blRet = MouseWheelOFF I usually do this by simply starting expression builder from the &quot;OnLoad&quot; section of the form's properties sheet. It does the trick. The second...

I have a single form that has a vertical scroll bar on it because it is about 3 screens in length. When I try to use the wheel on my mouse to scroll down the form, it instead scroll forward and backward through the records. Is there any way to make a wheel mouse scroll the screen rather than...

I should probably start off by saying that I don't know VBA yet (but will be learning soon) and I'm not great with SQL, but I can usually find my way along with it. The easiest way for me to understand things is with generalities such as &quot;first, create a make-table query...then...&quot...

I am trying to name a field &quot;001&quot; (no parenths), but it keeps renaming the field &quot;1&quot; because it sees it as a number. Is there any way for me to get Access to accept &quot;001&quot; as the field name?

I have 66 fields on my form (I know I know, that's far too many, but I'll have to deal with that at a later time). Anyway, we're going to call the first field PrimaryField and the rest of the fields will be names sequentially as 001, 002,...,064, 065. They are all combo boxes. When I select...

I am trying to make a form that, with the click of a button, creates multiple records from the data that I just entered. I need a date box at the top where I can enter a date. Below that, I need to have 10 rows of names and 3 check boxes for each. I will try to demonstrate below. <cb> means...