Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mmsbasd

    Computer reboots before login screen

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

    Access XP and Crystal Reports 8 - ODBC Issue

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

    Numbering "records" in a query

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

    filter on a form

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

    Numbering "records" in a query

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

    How to add records via a query

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

    Add fields in query!

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

    Converting SQL View into Access Query

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

    getting qry in 1 to many relationship..!!! Help Please~~

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

    Outlook 2002 display notification

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

    Outlook Calendar Locks Up After Specific Day-HELP

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

    Outlook 2000 - Increase calendar space for Sat and Sun

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

    Outlook vs. Outlook Express

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

    faxing problem

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

    Twain problem with scanner

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

    Outlook 2000 - "Can't Open Item"

    That could happen for several reasons. I've usually seen that if there is a problem with the original email or the PST file, where the email is corrupt. Also, in some cases, you can have Outlook configured to only download the headers and, so, you'd only be able to see the actual email when...
  17. mmsbasd

    Pinting an e-mail in Office XP

    I think that the header is only added after it has been successfully processed. Putting the header on BEFORE sending the message would basically be false information, because the action has not yet taken place. Michael BASD IS/IT Dept
  18. mmsbasd

    Access XP

    Microsoft Knowledgebase Article 238610 provides one solution to your error message. Depending on your computer and database setup, this error could occur. Hope it helps. Michael BASD IS/IT Dept
  19. mmsbasd

    Help with user management database (Access)

    I would just make the graphical interface as a set of ASP webpages, tapping the database for your information. Your database would have a table with Cubicle# and UserID. Make another table with UserID, UserName and your passwords. Then you can just access the database within the webpage. The...
  20. mmsbasd

    office 2000 crashing issues

    It has to be a security issue within Office. Perhaps, in the beginning, he unsuccessfully accessed one of the programs. From then on, Windows tagged his name as not having the proper rights and only by removing that limitation from the registry would resolve the problem. If you have a clone...

Part and Inventory Search

Back
Top