Recent content by greysquirl

Could you please give me a little more detail than that? I know how to use the "enabled" and "visibility" properties but not as they pertain to the users rights. Do you have any examples I could work by? Thanks

I am using a Tab Control on a form that I have in my database. On this Tab Control are 6 different tabs. I know there are ways to secure a database and make ir read only or give users read/write access, but what I am more interested in is how would I give certain users access to only tabs I...

I think the biggest dislike to the security that Access offers is the inability to select particular parts of a form and restrict access to them. The easiest way to take care of that problem is to create multiple tables for a database and restrict those individually. But since I didn't create...

I have tried that and was not satisfied with Access' ability to secure my database. What I am looking for is something I can build within Access and add to my database.

I am trying to ad some security to an Access database I have created. What I am looking for is something along the lines of an admin screen I can add in Access that will alow me to add/delete users and asign rights to users. If anyone knows where I could find information on this sort of thing...

I am using an SQL statement to return some values to a table for me. What I have is a Master table where the info is coming from and going to a table called Position Change. This happens on the Before Update Event of a command button. All of that aside, the problem I am having is that if you...

Explain to me exactly what information you might need from me to get the proper gist of the situation and I will try to provide you with all I can. I tried just simply putting this into the form and it did exactly what you said it would do. . . .add a year to the current date of the form, and...

I am going to try and explain this the besy way I know how. . . . . I have a form called Review. At the moment I have a bit of code running in the form (see below) which on January 1 of every year will clear out (4) text boxes and (3) check boxes. What I need to happen here is on January 1 of...

I have a report that when run it brings up a form that allows the user to select from a combo box what employee name; which each has thier own (EmpID: AutoNumber) they want viewed on the report. The whole thing is based off a query that when run has the criteria . . ...

The SQL below is what I am currently using. What I am wanting to do; if possible; is from the "Review" table I want to have a first name (FName) middle initial (MI) and last name (LName). When this query runs I want it to take the three and combine them into one column (Name) in the...

Works great. . . .I have another question if your up for it??? Now that I can type in qn Employee's Name to query for how can I make it look over typo's? In other words. . .if I typed Dave instead of David I would want it to list all the above. Or if I type in Bob, it should give me all the...

I have a table that I want to run a report off of. The table is called "Position Change" and the layout is as follows. Name Department Position DateStarted ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ John Maintenance Mower 5/3/00 Henry...

Thank you Kathryn, you have been a tremendous help. It worked beautifully after I changed it to this. . . I am adding this for anyone who has been following this post. . . .what was changed here is working great and without a hitch. INSERT INTO [Position Change] ( Position, DateStarted...

The macro is running the query when the position changes. When you say I can run this in code. . . .explain to me how you would actually go about this?

I finally got this to work right. The only problem now is that when the query runs its asking which "EmpID" to move over. What I originally wanted; if possible; was to simply move the record that had been changed without it asking any questions. INSERT INTO [Position Change] (...