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

    Out of Slack Space VB6 to Access 2000

    I found the error, I had some irregular data in my form. Once I cleared out all the garbage it started working.
  2. whipper

    Out of Slack Space VB6 to Access 2000

    I have setup all the DAO connections for VB6 to connect to Access 200 Db just fine. Everything was working ok, then I started getting the following error when I try and create a new record: "Out of Slack Space" to me this sounds like something with the harddrive, yet when I place this on a...
  3. whipper

    Query based upon table exclusions and inclusions.

    This works fine until I have and another row to table 2 so it looks like this: Table2 - field1, field2, field3 row1 - "Y", "table1", "field2" row2 - "N", "table1", "field2" row3 - "N", "table4", "field2" I need to set criteria to only look at table2 - field2 and match the text "table1". I...
  4. whipper

    Query based upon table exclusions and inclusions.

    Ok lets see if I can explain. I want to make a query that will set criteria based upon entries in a table. So, let me give you some data to play with. Table1 - field1, field2 row1 - l2a1234, Y row2 - l2a2345, Y row3 - l2a3456, M row4 - l2a4567, N Table2 - field1, field2, field3 row1 - "Y"...
  5. whipper

    Authenticate with Microsoft Access

    I have a Microsoft Access database and I wanted to set up authorization based upon our LDAP server, so I don't have to add everyone to the security file as default. From what I have found I need to install ADSI on my computer to use the IDSOObjects. Is this possible? Thanks
  6. whipper

    Make Subquery show records

    Ok, I got it to work it just takes a really long time with all the data that I'm using (65000 rows) This works faster when I limit the search to the HW and then even faster with SN too. Thanks for your help that is what I wanted. :)
  7. whipper

    Make Subquery show records

    swampBoogie, Thanks, but for some reason the Sum value is not showing up. I also noticed that there is ")" missing from the second SELECT so I placed it after the "datetime> h.datetime)"
  8. whipper

    Make Subquery show records

    Ok, I have one table that lists activities of hardware. I want to sum the count between activities. Here is my table: History: HW | SN | DateTime | Activity | count -------------------------------------------------- 101 | 2 | 5/3/03 11:45:04 PM | 1 | 0 101 | 2 |...

Part and Inventory Search

Back
Top