Search results

Many thanks. I will investigate further. Regards Peter

I have set an application which I have stored on a local server. It is set to compact on closure. I have done this many times before without problems, but in this case compaction leaves a copy of the database on the server. Can anyone please advise me as to why this happens and what to do about...

I want to print different versions of a report (ie different signatures)depending on on the user login id "quserid" which I have on a login form "authorise". As a simple example I have tried using a single user with the syntax shown below but get an error message "Object required". I suspect...

I want to print different versions of a report depending on on the user login id "quserid" which I have on a login form "authorise". As a simple example I have tried using a single user with the syntax shown below but get an error message "Object required". I suspect the problem is in the way...

I want to print different versions of a report depending on on the user login id "quserid" which I have on a login form "authorise". As a simple example I have tried using a single user with the syntax shown below but get an error message "Object required". I suspect the problem is in the way...

I have a table which stores meeting room booking information in half hour slots. If someone books a 2 hour meeting then 4 records would be produced – one for each half hour. I want to produce a query which will group the data by room (ScheduleID) showing the max and min times (ie the initial...

Thanks Paul. Unfortunately it didn't work! The query requests the name to be put in rather than seeing the actual login name! Any other suggestion? Peter

I have a two level security system to protect my date. The first uses the MS Access security, the second is a simple login system wherby a user enters their name and personal password to gain a customised view of the data eg if the user is me, I can see all tool bars, other users cannot. What I...

I want to build a room scheduler. Before I get too far in to my first attempts, does anyone know if there any examples out there I can use to give me ideas? If not I wonder can anyone advise me as to a difficulty I currently can see with what my attempts so far. I have built a very basic...

When I try to use the wizard to set User Level Security It fails to show me any objects to secure. I have created a secure work group info file and set user name for me and password so that I have full admin permissions. When I open the unsecured database (using my user name and password) I...

I have a database of customers for which I want to print address labels depending on what group I have entered them in. There are about 30 different groups that they could be a member of. I have entered them in to groups by using "yes/no" fields on the customer table to indicate who is a...

I have a query which I want to based on a group selected on a form using a selector button. EG if a person is a member of the accounts team that button would be selected. I could then just run the query to get members of the accounts team. I am using the following SQL, but find when I run it...

Can anyone tell me why - when I cannot set up User-level security from the wizard. I tried setting up a fresh test database (with a tables,queriy, form and report), then going to TOOLS - SECURITY - USER-LEVEL SECURITY WIZARD. This works ok so far. I am then asked if I want to create...

I have built a login form which shows or hides all tool bars depending on the user name and password. Can I also control the other permissons like being able to edit forms and tables? I know I can do this using the MS Access built in functionality, but can I do it programatically from my...

Forgot to say it is in the code for a LogIn button which checks the user name and password on an entry form then opens the next form if both are correct. Peter

I thought it needed quotes, but thought maybe something else as well. Yes it is testing for a string. Peter

Can anyone please tell me what I am doing wrong with the following statement? If Me.qpwd.Value = BROWN THEN ... ... ETC. I have tried putting "BROWN" in quotes / parenthesis etc but cannot find the correct syntax. Thanks in advance. Peter

Thanks for this. My problem is now more simple than this!! How to I put the user name in to the system. Do I build a front end login form which has a control "username" on it , or can I do it from the tools menu in the main database window? Regards Peter

Thanks for this. My problem is now more simple than this!! How to I put the user name in to the system. Do I build a front end login form which has a control "username" on it , or can I do it from the tools menu in the main database window?

I came across a script which should enable me to hide tool bars from users of the database. The code is as follows Dim vUser As String vUser = Environ$("UserName") If vUser = YOURUSERNAME Then Dim i As Integer For i = 1 To CommandBars.Count CommandBars(i).Enabled = False Next i Else...