Recent content by mmsbasd

From the information you provided, it looks like some of your hardware drivers are failing during the boot. In many instances, this is due to an updated driver that has created a memory or IRQ conflict with the rest of the system. I've seen it happen often, especially when updating your...

I hope this is in the correct forum: We use a program called TrackIt! to process our repair issues. It's server-based, so I export my work orders into an Access database that's local and look at them through a custom interface. TrackIt! does not have an export feature built-in for this, so I...

If you go to Microsoft Knowledgebase Article 182568, there is a sample query file you can download that will show you exactly how the ranking works. You'll have to convert it to Access 2000 but I tried it and it works. Even though you don't need the system to 'calculate' a ranking, you should...

While the changes you made may have not been directly tied to the filter field, they may have been part of a relationship with another table or query. That would give you the same error message as a result. I would check the relationships with the form and the underlying queries and see if...

Microsoft Knowledgebase article 208946 describes how to rank records within a query. That should give you what you want. Michael BASD IS/IT Dept

I'm a little confused on the specifics but can start you on your way towards getting it done. What you want is an UPDATE query. This will allow you to specify which records need to be updated, along with what information needs to go into the appropriate fields. To make an UPDATE query, just...

Change your query to a CROSSTAB query and you can specify which fields should be GROUPED (ISBN) and where they should go in your final output. In your example, ISBN would be row data and the other fields would be column data. Michael BASD IS/IT Dept

It depends on the query. A JOIN query, for example, only works in SQL, so there is no 'Access Query' version. A regular Select or Crosstab query should be viewable in both formats. Michael BASD IS/IT Dept

I would just make a separate query for the test date and then make a JOIN query to show all the information in one place. In most cases, I find that this is the easiest (and sometime the ONLY) way to put this kind of information together. Hope this helps. Michael BASD IS/IT Dept

While I have not heard of this issue specifically, I have heard of things going wrong in Outlook after installing various critical updates in Windows. In the same way, newer updates may fix the problem again. Check the Service Pack level of the various machines and see if you can find a common...

I would agree that it's a corrupted entry in that day. Sounds like the sync with the Palm bypassed whatever was locking up Outlook and resolving the issue. Can you do the same thing with this user? Set up a Palm and tell it to remove all entries for that day? It could also be a 2GB size...

Under Outlook 2002, if you edit your Weekly Style, you can change the order from "Top to Bottom" to "Left to Right". This change will make all days in the week evenly spaced. Hope this helps. Michael BASD IS/IT Dept

I would try downloading the latest WIN2K service pack. This will include a control panel called SET PROGRAM ACCESS AND DEFAULTS. Among other settings, you can choose which is your default email package from there. That might kick in the right one. Hope this helps. Michael BASD IS/IT Dept

Check out this website for information on a fax program for Windows 2000. It says it'll handle up to 32 modems! http://www.gfisoftware.com/ffn/index.html Michael BASD IS/IT Dept

I have a Memorex MEM48U scanner. Windows 2000 sees the device and loads the driver. If I go into Scanners and Cameras, it sees the scanner and the test passes successfully. When I try to access the scanner from the included ScanPanel program or from Imaging, I get an error saying 'Twain not...