Search results

Hello. The hospital asks us to do a 6 months diary exercise in order to improve and balance our job plans. Every day we will need to record our activities and time spent on each activity. I think I will do it with the help of MS Access. I wonder if there is anything already created for this...

Hi all. Sorry if this already exist. I couldn't find a simple solution without VBA. My problem is I have a main form which has just a few fields and should be quite small in height. The subform however has multiple related records and it should be in the form of dataset and occupy the most of...

Hello I would appreciate any advice. I have a form showing dates and within it several subforms showing data from other child tables all related by dates. When I write a rota, I am struggling with errors like I allocate someone for an activity when they are already are allocated to another...

Hello! I have been using my database for quite a long time. BTW I constructed it with a great help of experts on this forum. So, today, out of the blue, each time I move to the next record on one of the forms, I started receiving a message: Expression too complex in query expression...

Is anyone experiencing the same issue as I am? When I create a button to open a form with filter, access creates a macro for that. I don’t like macros and I then convert macro to vba by clicking appropriate button on ribbon. Then the button would not work because during the process access puts &...

Hello, I came across a task which I can't resolve. As it is shown in a table attached I have three fields, namely Cutup 1, Cutup 2 and Cutup 3. These fields contain values (allocated consultants) related to the same table. I need now to calculate how may cutups in total each consultant has...

Hello experts I've got a difficult question) I have these tables: table_Consultants which has a field Cons_id. This table contains all consultants. table_Dates. This table contains all dates for departmental rotas table_absentees. This table has a field Date which is related one-to many to...

Hello experts I have a form which has a subform. At the bottom of the main form I have a button for opening a report. I want that report to be filtered according to the value showing in one filed of the subform. Is it possible to achieve? How to write a where condition in the Open report...

Hi I am searching this thread for a sample/template database for small business accounting. Does anyone know if it’s possible at all?

Hi guys I am trying to build an expression for an unbound field in a report. I want to show a ratio of number of particular meetings for each consultant. For example, the total number of meetings = 5 These meetings were done by three consultants. So I should have the number of meetings done...

Hello I have a good report containing data from several queries. I want now to include to the report my final piece so that it was as a subreport. Unfortunately I can't do this because that piece of data is in the form of a crosstab query. Is there a possibility to solve this? Probably I can...

Hi I am back with my bizarre questions. What I want now is to create a query which would include fields from two Tables. The problem is as follows. Table 1 has fields: Date_abs as date; Cons_abs as string It returns datasheet: 06/01/2019 LS, NC, AW am, EK 07/01/2019 TW, CK, AW am, EK...

Hi I am developing a departmental rota database. I posted a few questions in other places. Now I have a question regarding reports. I am going to have several reports. Unfortunately I can't see a way to create one report because some reports require cross tab queries and some are not. I need in...

Hi, I was asked to take over departmental rota in a hospital. My predecessor did it in Excel, I want to do in in access. I posted a question about this project in another thread and received suggestions that prompted me that my approach to the database itself may be wrong. Our rota is done for 6...

Hi I am developing a database for departmental rota of a hospital. There are going to be many many problems and challenges ahead. At the moment I've this one. I need to go and register meetings day by day and week by week. I was thinking if it is possible to duplicate one or preferably multiple...

Hi, Just now joined this forum. I am not a professional in IT. I am a medical doctor, but I have some good experience (I think) in access. I created lots of databases for various purposes mainly for auditing my work. Now I am facing quite a challenge. I was asked by my department to take over...