Search results

Hi, I am creating a report and need to count the number of clients that are within the first 48 hours of the service, and also count clients that are above 48 hours. I also need to count clients whose service has ended, but count those that ended within 48 hours and those that ended after...

Hi all I am trying to create a simple database to keep track of employee Car Insurances and MOT information. I am trying to create a query that will show me the following: When the field "motexpiry" is Empty OR has a date within 30 days from todays date (including if today's date is in the...

Hi, I have a database that was created by a colleague. They have created a form for adding client records onto the database. This is done via a button that, when pressed, checks mandatory fields for correct entries and then saves the record. However, when we do this, it is creating two...

Hi, We have a database that has around 30 queries that are ran on a monthly basis. They all have unique criteria (but there is a crossover of fields that are used), and are all set up so they show only the previous month's data (the date is taken from one date field for some queries, and...

Hi all, A colleague of mine is creating a database (attached), but is getting run-time errors. When it opens, a menu box opens for the user. Click on "Add Client" on this and it opens the 'AddClientInfo' form. As you can guess, this is where the user will input client details. There seems...

Hi, I need some help writing a query in Access 2010 if anybody is able to help me. There are two tables "Clients" and "Calls". This is a one-to-many relationship whereby there can be many calls attached to each client record. I need a query that: 1) Finds all records from the 'Calls' table...

Hi, I have an access database that is going to require around 30 different reports running off it on a regular basis. A lot of the reports are similar with slight changes. Is it possible to create a form where a user inputs all the filters they wish to apply and then it runs a report? I need...

Hi, I used some code I found here: http://allenbrowne.com/casu-08.html to try and run my report based on a date range. I have modified it only to customise the report name/field name. However, when I run this (with a date range of 01/01/2012 to 30/01/2012) I get an error with this line of...

Hi I have a database with two forms. The Clients form is for client name/address etc. It has a one-to-many relationship with a Visits form, for recording multiple visits attended by our care staff for each client. Each form has an auto-sum 'Log No' which is linked. I have a report set up...

Hi, I have a form which has a subform within it. I have set the tab order, and when tabbing through the main form, it jumps to the sub form at the correct time, and then tabs through the subform correctly. My issue is if I click into a field in the subform, and then press tab, it tabs to the...

Hi, I am quite new to access but have been tasked with creating a database. With the massive help of Severin on this forum, I now have a working database with forms, subforms and reports. What I wanted to do next was create an easy to use record finder. I found one here...

Hi, I have a database (attached with dummy data in it), which has two tables. The first table 'Crisis Calls Attended' is for recording client information such as contact details and details of thier health and the care they need. Our staff then go out on visits to care for the client, so I...

Hi, I am quite new to Access, so would like some help if you wouldn't mind. I have converted an Excel spreadsheet into an Access database. The part I don't know how to do is adding up hours/minutes. My form looks like this: img189.imageshack.us/img189/3387/totalhoursfields.png But there are...