Search results

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

Yes, I can now see the problem. I'll better leave it and just do copy multiple records then paste them and them change the dates manually Thanks

How I wanted to design is to have multiple tables. In the rota there will be MDT meetings scheduled with dates, times and consultants attending them (just one consultant each for meeting). There will be also register of other activities. Register of absentees. Register of trainee supervision So...

Thanks o lot. And yes please can I have that code? I, however, probably don't have those skills to through data from one table to another. You need to create and run query or some kind of sql may be. I thought a simple code run by a button would do the job. The thing is, on Mondays there are...

I am sorry I was not clear. So, I am registering MDT meetings. The fields are: Date; Time; Week number (calculated); Consultant who covers meeting. Consultants and Meetings have parent tables for further references. There are several meetings per day. If I duplicate each meeting for the next...

The thing is yes I will need to change one filed in each record - the consultants who are doing the meetings will be varying. So I cant create a parent table, although I do have parent tables for Types of meetings and Consultants. The only thing I want that duplicating a record I already had the...

Thanks theDBguy. Unfortunately I am not that good to get how to do this. I also was not clear to explain what I need. I am registering meetings which have pretty similar pattern. For example each Monday there is the same meeting at the same time. I wanted to make my life easy and set a button...

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