Search results

I have a database held on a intranet which details staff training sessions. Is there a way in which other departments can access the *.mdb file as read-only, and cannot amend any of the data, just manipulate and statistically calculate its data.

I have a form which is used to display training courses, and which also contains a Combo box, from which one of 6 options can be chosen. The default option is 'Not Updated Yet', and the other options grade the success of the training. Once the training course is finished we change the status of...

I have a form which has 3 text boxes, which are used to enter a filter criteria, and also a triple state toggle button, so an inputter can type data which would filter a corresponding query. I want to have a button on the form which would clear the contents of the text boxes, and return the...

There are many previous messages relating to generating email messages from Access by using Outlook, but is there a more basic way in which emails can be generated where Outlook is not installed (like the corporate system where I work!!). I have written a db which identifies staff members who...

I have a query based upon 3 tables, and want to have a report which will calculate scenarios from the data. The query contains the fields 'date', 'incident' and 'void' (as well as some others). I want the report to include; the count of 'incident's where they are not 'void', and also the number...

I picked up a sample db from this forum which creates a security log-on for users to access databases, and although it can no doubt be easily overridden, it is ideal for what I need. Unfortunatly, the app has a bug which I cannot fix, and would appreciate help. The app creates a log of 'users'...

Have been looking at the excellent sample database - Database Security, but am unable to run it on the 'corporate' system at work as a reference is made to 'Microsoft DAO 3.6 Object Library' which is not available. Most of the database functions fine, except it does not record the 'log-off'...

I have tried the example db in the 'sample databases' for browsing to back end databases (by AccessKurzo), as it is exactly what I need, but can’t get it to work! If I load the test file (2K), the connection form automatically loads, and I click on browse. That is followed by a box asking me...

I have a query which comprises of [data1], [data2] and an expression [Percentage: ([data1]/[data2])], which formatted as 'percentage' gives me the percentage using the other two peices of data. This works fine, except I want to add a criteria in the criteria box - for example >0.2, to show only...

I have a report which gives detailed performance data for each department Manager. The report is grouped by Manager, giving an overall performance percentage for each Manager, and followed by a detailed breakdown of how that percentage is calculated. As the report is many pages long and with...

I have a query which includes amongst others the following fields; [ID] - the payroll number of the staff member [worksick] - a checkbox (yes/no) indicating if the staff member is either at work or on sick leave on this day. I need to create a report which lists [ID] numbers down the left...

I have a table, linked to another application whose format I cannot modify, which contains 5 fields containing data. Occasionally, data is recorded which is identical in fields 2, 3 & 4 (not bothered about 1 & 5). I would like to create a process where the duplicates are deleted, whilst leaving...