Search results for query: *

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

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

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

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

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

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

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)"

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