Recent content by Jamesremec

Hey all, I learned Access and created a database last summer but haven't touched the thing myself since then. When I did it, I set up user-level security for it. Turns out the company doesn't have much use for it so I wanted to get rid of the user-level security to make things easier...

I'm about to set up user-level security on a database using the wizard. I was just wondering if you guys knew how to remove it in case something goes wrong or if we eventually don't need it. Thanks in advance.

Hi everyone. What I'm trying to do is set up a query so that a user can see only the query and not the table it is extracting data from. I tried using the security wizard and setting the permissions so that the user has access to the query but not to the table. Problem is, when I try to...

Well, I tried fooling around with it and that line of code just doesn't want to work. "Saleen #" is what I was putting in the brackets. It's the primary key, used for both forms. Like I said, when I put that into the primary key brackets, I get an error, "Expected: End of Statement" Any ideas?

I'm actually doing this for two tables. In one the primary key is a serial number. The other has two primary keys, a serial number and an owner number.

DBL, I tried using the code you gave me and got an error on the second form's code. Where you said, "Set rs = Me.RecordsetCloners.FindFirst "[PrimaryKeyField] = " &Val(Right(Me.OpenArgs,Len(Me.OpenArgs)-2)) I get an error that highlights "[Saleen #] = " Saying "Expected: End of statement"...

DBL Thanks for the quick reply. Only problem is, I am extremely new at Access (taught myself how to use it 5 weeks ago, thats why I was trying to use a macro) and have never done VBS code. Could you explain a little bit about what your wrote above? I'm pretty confused with all the...

I'd like to make it so that when viewing a particular datasheet form, you can double-click on one of the records and open a form that has all the data from that record summarized for easy viewing and editing (so you don't have to scroll to the right on the table.) I understand how to start the...