Search results

unfortunately this is very likely part of the problem. I work in the A&E department of a very busy hospital with hundreds of different staff using the database. The database will be open for days non stop and is open on at least 20 different computers at once. what do you mean by Left open in...

yes. It is a booking system for them to log job requests for Hospital porters.

i plan to do this but also want to not have to resort to this as much as possible. I want to have the database be as independent as it can be.

this sounds very complicated and i am quite new to access. I also do not have adminstration control over the computers so installing new software will be quite hard if not impossible. i dont think SQL servers will be an option for me

thank you for your in depth reply it has been very insightful!

Maintenance schedule isn't really possible as I will be leaving the workplace and no one else is really knowledgable enough to maintain it. They may be able to compact and repair but I need to do anything else I can beforehand

When I compress the front end it goes down to 3mb so is that size increase up to 400mb normal? And how much will it keep on going up to? And no the whole database isn't closing after the crash. What I meant by that is that the front end crashes on 1 computer but will still be opened on other...

Hello, So I've created a database that is used in a hospital. It is used 24/7 so closing the database to make changes isnt really an option. After every few weeks the database slows down and sometimes crashes. After deleting all the records in the tables it becomes better. The backend has...

site doesnt seem to work for me unfortunately, even on my phone

honestly it gave some very good and different suggestions and one that almost worked.

I have set the Form Record lock type to "Edited Records" only. When a user tries to edit a record which is locked by another user they will hear a Windows error ding sound but I want a message box to pop up too. I have tried searching it up and even asking Chat GPT to create some code but...

updated

just to refresh the page automatically so new jobs appear. I have found a decent fix for it which is just to set focus to a text box that cant be edited so no text will be entered anywhere after requery if that makes sense

It half worked. In most cases it works but if a new job is booked and all the records shift down by 1 row then it will edit the row that has moved down in to its place. I have found a fix though and just made it that setfocus after requery goes to a locked textbox. Thank you :) I was looking...

i tried that. It keeps it on the same record instead of going to the top one but it will still select all the data in the field. i need some code for it to go to the end of the field. I tried to do the sel start and length but couldnt get far

Currently in My database there is an area for Staff to add some notes. Problem is that when the form does a Requery the cursor will move to a field in the top Record and also selects all the data in that record. Is it possible to keep the Cursor in the exact same spot after query so Staff can...

still the same :/ once you book a job and wait over 30 seconds to add a name it doesn't let you change the time. lets leave it. I dont want to take more of your time and you have been very helpful already. I might come back to it in a few days and see if anyone else is able to figure it out...

It is the same. I have explained it int he video. Thanks again for your time and if you cant do it thats fine. You have made the start time connected to when a new job is created when instead it needs to be connected to when a Porter name is assigned.

i have tried that version but it works less effectively than the one i attached in #18. When you create a new job it allows maybe 15 seconds for the time to be changed. Not sure why. Thats why it worked in the video as you were quick to add a name. Create a job and wait a minute or so and then...

Thank you once again for ur time but unfortunately this hasnt worked either. ive tried to explain in my video verbally this time what my request is. If you cant do it thats completely fine. You have done more than enough which I am very thankful for :) If you are still confused about what i...