Recent content by cowspotter

First of all, I need the actual key values in the results as well so I added that to the select statement (and the group by since it has to be there as well). I removed ToServer and FromServer from the select and group by because I don't need those. The problem is that this tells me that a key...

I have a table with the following columns: Key - SSH Key value FromAcct - Account that uses the SSH key FromSever - Server that uses the SSH key ToAcct - Account that is accessed using SSH key ToServer - Server that is accessed using SSH key We are finding that one key is being used by...

I am trying to parse though a table which contains user activity for a week. I am running a query against the table which returns the unique user ids that i will generate reports for. These results fill idRS (recordset). I then loop through each one filling activityRS with just that IDs...

Alright, I ran into a new problem using that previous method (VBA code) so I went back and used the query code. That worked. Unless I'm missing something, since I'm using a radio button to select the platform (and that has option values associated with it), I am using a hidden text control where...

This is a setup that we are using until we can get a web front end built. I know its not ideal but its not permanent. The tables aren't linked, they exist locally in the database. By "Platform" I mean Windows, Unix, Network, etc. Its just a classification for each case we open. I didn't test...

Thanks CyberLynx! That did it. I couldn't add the reference to DAO3.x because it appears you can't have Office 12.0 Object Library as well as DAO3.x Object Library. Does the 12.0 replace DAO? Either way, I didn't need it. Worked fine. The only thing I changed was because we have multiple users...

That still doesn't address my problem of integrating the input from the form into the stored query

I need some help with a query that I'm trying to run on an Access 2007 database. I have a query that returns a list of records (date, user, index number, platform, etc) and that query works fine. My issue is that I want the user to be able to use a form to select either a specific platform or...