Search results

Hi all, I have been asked to create a pilot database to use for Student Placements within our department at our University. My main criteria is that it has to be as user-friendly as possible, so I'm hoping to build something with a bit of automation in it. One of the things I am trying to...

Hi All, I have a problem, as those that find their way here often do. I have been in charge of administrative systems within a counselling service that I work for, and as part of that have developed a fairly complex database around confidential information, appointment diaries, statistics...

Hi Guys! Having a bit of a problem trying to figure out how to do this :/ Currently I'm amending a database I have built that over the last few weeks has gotten more complicated that I had originally envisioned, but isn't that always the case :rolleyes: I'm building a database for a...

Hi Guys! I've created a database used for Researching in a Counselling Environment. Our clients are asked to fill out forms. My question is: Is there a way so that Access automatically knows, by date, the order of which the form the client has filled out by numbering it. For example...

Hey! I've built a database that is for both research and administrative purposes. Due to Data Protection, it is important (due to these reasons) to have identifiable information unavailable to the researchers (such as name and contact details). As such, I have split the database - the core of...

Hey! I wondering if it is possible at all to manipulate the 'Total' function in a form either through VBA or, preferably, through the query itself. What I'm trying to create is a form that shows figurative data about attendance at a Clinic. There are a few categories that I want it split up by...

Hey guys! I'm trying to create a form that forces the user to input data before they are allowed to do a variety of functions. Now, the most obvious way to do this is to control the Visible variable and I want to manipulate this function to achieve what I want to do. My problem is that in...

Hey guys! Usually I start writing out my problem that I'm stuck on when I get an epiphany towards the end of the post and solve it myself. I think sometimes all you really need to do is talk it out aloud to think of something new. But this has got me beat :/ I'm writing a database for a...

Due to reasons beyond my understanding, I have compiled a Diary-type database for a Counselling clinic. As such, they need to record what the current session number is when that session is booked. However, because this number is pulled from a collated query (where all Attendance records are...

Hey! Having a spot of bother with my calculations, wondering if anyone can offer a quick solution! The clients in the database occasionally have a different type of session, called a "Change Interview". I've created a query which counts the total number of Change Interviews a client has had and...

Hello! Have been writing a database for the clinic where I work over the last few days, and have completed everything that I need to except for this, which is the biggest, and I haven't a clue how to tackle it. I want a Form that across the top has a List of Counsellors (4-6 in total...

Hello from the south wales valleys! Over the last week I've found many a solution on these forums whilst trying to create a somewhat complex database for a Counselling service I work for. So, thought I may as well sign up and whatnot as unfortunately, I have a problem that is far beyond my line...