Search results for query: *

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

This bit of code isn't running in code. I have it running in a query. It all starts when the "Position" in the form is changed, on the Before Update event. When it is changed there is a macro called Backup that is run, which runs the query.

I literally mean nothing happens. When I added that WHERE clause in, the EmpID in to the table, and then ran the query nothing happend. It doesn't give an error but at the same time it doesn't post an info either. Even when I go to the form and add a new employee or change the current...

After adding an ID field as you suggested and changing my SQL per your directions; I am at a loss. . . . It still doesn't work??? Thank you for the help though, I am one step closer to figuring it out. Are there any other ideas? INSERT INTO [Position Change] ( Position, DateChgd, Name...

I am using the following basically as a backup. It is triggered by a macro that is set to run on the "Before Update" of the "Position" text box. When a person changes positions the information about thier old job, date they started etc. is dumped into another table for...

I need some help using SQL. I have two tables, Review & PositionChg. What I want to do here is take two columns of information from Review (position and position start) and move them to the positionchg table under (position & datechg). Review PositionChg Department - - - -...