Search results

I have it as such: Public UserID As Long in a module

If you could please tell me how to make that shortcut with the workgroup parameter sent. Also, is there a way to track what the users do with the workgroup? Like to keep a log file?

I tried making my own security for a databse of mine, and I have a recurring problem. In order to keep the state of security, I use a variable to hold what security level this user has. For some odd reason every so often the variable will sort of lose this value, and in essence log a person out...

Thank you so much, that worked perfectly.

But now, how do I get only the people who are not in that other query?

I have two tables, One holds people going to an event (Participants), and another that holds the peoples information (Individuals). I need a query that holds all of the Individuals that are not going to a particular event, where a field in the Participants table is EventID (which event they are...

I have a query which I am generating form code, and that query is the source of a Report that I have. My problem is that when the Report tries to open, I get an error like this: The database engine could not lock table 'Events' because it is already in use by another person. Now it's not only...

I saw something on here once before similar to what I'm trying to do, but it was only a mention of it in a more genral term. I'm trying to allow certain permissions through code, as I don't want to use Access' security, b/c that affects all acces databases. I have got most of the permissions...

Is there a way to do this this (prevent viewing of design) through code?

I have a query that I'm trying to make. I two tables that I need to connect. One of the tables has a field with a 4 digit number (Table1), while the other table has a field with a 5 digit number (Table2). These two I need to join. I made a query with all of the original data from the latter...

Well, I tried putting in chkaddress=-1 and I tried =1 b/c I'm checking if the check box chkaddress is checked (that's why I was trying to evalute it if it was true), however, now I'm getting an empty resultset, when I know for a fact there shoulc be something there, b/c I get this result...

alright, I have a bit of a problem. I've been writting a few queries of mine through VBA b/c of a wealth of criteria, however for the sake of clarity, as well as the users requesting the quesries themselves, I want to use expressions in the criteria of the query. Now, here's what I'm trying to...

I would suggest that you shck over your SQL statement, that's usually the clincher. I'd have to see the SQL statement to find out for sure what it is that is bugging out. bauer

I was wondering if anybody ever heard of this book, it's one of the sponsers on this board. I was wondering if anybody heard of this, tried it, is it worth it? Anybody, anything. Thanks bauer

I am having trouble deleteing records in a table. It is a table of people, that has a relationship with addresses as a 1 to many, as well thee people is also related to a table of participants, also as a 1 to many. The relationships don't make a difference, as I've delted themtried, and...

Never mind, I got it. However, I now I have another problem. I am trying to import a csv file into a table. I first want to transfer the old data into a new table, and then delete the table contents, and then import the csv file into the old empty table. There's one catch, the csv file has no...

One thing, how do I run the query from code?

I am trying to figure out how to delete all of a tables contents without haveing to delete each record individually. My other option is to use a transferText but overwrite the table contents. Thank you all, Eric

BuxHix, I would be very interested in that script. I mean the one that send a confirmatione-mail and then they have to click the link. It is just what I've been looking for. Thank you Eric

Ok, here's my problem, I've been racking (sp?) my brain and the internet for a solution, or at least an explanation. I have a database written in Access 2000 on windows 2000. I then without thinking, saved it on Access 2002. Now I continue getting this error on search combo boxes, with the...