Search results

Hello, I hope everyone is doing well. I have a form that has 2 seperate combo boxes. One is the Start location of a transport job and the other is the end location of it. So the user selects the locations from the drop down list. Instead I want it to be so that the location names are all...

Hello, I have a database which gives me the error "Undefined function "FnElapsed" in Expression" whenever i open the file from a new computer for the first time. It does not affect the performance of the database. I did not make the module which includes the expression but I have tried seeing...

Whenever i open my access frontend i get an error that there is an undefined expression called "fnElapsed". this is the module code. can anyone see where the error is coming from? Public Function fnElapsed(ByVal start_time As Variant, ByVal end_time As Variant, ByVal job_is_finished As...

I have code which currently reads something like: If Me.Priority = "Urgent" Then Me.command200.visible = false Me.command201.visible = false Me.command202.visible = false End if Is it possible to group the command boxes together under a bracket and then have then all = false rather than write...

Currently I have a line of code that is: Private Sub Form_Open(Cancel As Integer) Me.Assign_Porter.SetFocus End Sub I have now changed the form design a bit so that the field "Assign.porter" is not always present (I turned allow additions off) whereas before it was. Now i get errors when the...

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

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

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

I have this job booking system where the start time and end time is recorded. Only problem is that if the user takes their name off and puts it back on then the timer resets to the current time. Is it possible to allow only one time entry and then to lock after that and not change at all? I...

Hi , I really need some help as I'm struggling on this. I want to create a stopwatch timer that is on a form for each record. The form displays a list of jobs which users add their name to. I know how to show the start time but I need a counter next to it in the format 00:00 that shows how...