Search results

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

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

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

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

I have a form which contains one subform. On the subform I have a command button which saves the record just entered. On the main form I have a "refresh form data" button which updates the main form so that the calculated controls can show the correct results based on the data just entered...

I have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for. How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory...

I have a course booking form comprising of a main form which holds the person details, and a sub form which holds the details of each course they book. I want to be able to produce a report/ letter from the current form (ie once a person have booked a course) confirming that the course has...

I have a main form which shows customer personal details including their budget and a subform which shows the costs for each course they book. The sub form has 4 boxes which I use to capture course fee, travel fees,subsistance and other expenses (along with other details such as course code...