Search results

Ah sorry that is my bad. I relinked the backend to the frontend and made some other parts visible and opened it myself from a different computer to see if it worked okay but as it was on a trusted computer i think that's why I was mistaken. I am not an active user with forums like these. I...

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

Are you able to give an example of the script that would copy the front end to the users profile?

Does uploading the backend to an SQL server mean I need to install extra software? Unfortunately I can't do that if so. What would happen if the user doesn't exit the front end when the code shows? Is it able to kick them out?

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 tried it under the form timer event which requerys the form every minute and it worked perfectly there. I do not want it there tho as it would work when the form refreshes every minute. I need it somewhere that it would work instantly when the recordcount changes

Thank you for first half. Current doesn't work. Nothing happens. My code is If me.recordset.recordcount < 1 then Me.formfooter.visible = true End if I've tried putting it under a few form events and none seem to work.

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

Thank you for giving a precise reply. But let's say the system is stable and does not crash? And also does not require any new features?

Thank you for your replies. I guess I may be out of my depth if the problems and changes you mentioned occur to the database in the future. But no action would be taken by anyone until it crashes unfortunately. I don't think it will for a few months at least. But that's just how it is in some...

Well as I am not a veteran to handling an active access database I am not sure what "Maintaining" a database would entail. I have not supervised one over a lengthy amount of time to know what would need to fixed or "maintained". Assuming that my database is stable and won't crash then I...

I don't really understand the first part about controls. What I have right now is a field called "Assign Porter" and in the form it is a combo box where the porter clicks their name on the list. I turned allow additions off so that when there are no records to display then the screen is...

This seems to have worked. Thank you very much.

That was just a copy and paste I used to show the code. I have the same code in other places where the form does a requery

I turned allow additions off so when there are no records to display then the form is completely empty and so the assign.porter field is not at all there. Do you know if this Will this work for that?

The form refreshes every minute with the VBA. If someone is writing some notes then the refresh will push them to another field and they will continue writing in the wrong field and they may not realise. The assign focus helps to block them from writing. I know there's code to put them back...

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

thank you. I will look into teaching someone who will likely be here long term on how to maintain it. Does maintaining it mean just compacting and repairing the database from time to time?

definitely. I am not a programmer and am very new to access so I wouldnt be surprised if behind the scenes the VBA code is a mess. How would i be able to tell and how to improve it?

if i worked here full time permanently i could set that up but unfortunately i am leaving to go and study. Not many other staff members will have a clue on how to repair the database and Staff also come and go very often. I am not apart of the IT team as well so they wont help.