Search results

The vba you suggested was just what I was looking for. It works exactly how I wanted. thank you very much for your help you were the only one to suggest it! :) I used another set of buttons to assign focus back to the appropriate fields if they wanted to amend the location

Sorry for the late reply. I apologise that you see it that way. I tend to start off by answering the smaller replies first and then the bigger, more important ones. Otherwise I wouldn't be bothered to reply to the small ones after. Unfortunately I don't get paid for any of this work on the...

I have just seen yours too but I wanted to try to implement it first before replying. It looks great thank you very much for sharing the file. I am just struggling to do it with my database. Instead of hovering over locations on an image could it work with hovering over text boxes? So the...

Sorry I have just seen it now. Thank you :) it looks like exactly what I'm after. I will try to implement it and see how it works out :)

The question is how to make it go to either the Start/End location text box that the user wants it to.

Is there nothing to say which field was last dirty?

Maybe don't be so quick to judge. I've obviously thought about that which is why I mentioned the "last dirty field". If possible, that could be used in the vba to say that the location button that is clicked is added to the text box that is dirty. This would allow users to change the...

That is my point. Which is why I mentioned the last dirty field. Maybe that could be used in the vba to say that the location that is clicked is added to the field that is last made dirty. This would allow users to change the locations.

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

Sorry what do you mean from immediate window?

I tried that and it makes things worse. There is a module in the form (that I didn't make) which shows the Elapsed time once a button has been clicked. When I remove the fnElapsed part from the recordsource like you suggested the timer says "#Name?" Instead of showing how many minutes Elapsed...

Do you know how I would fix this issue? I thought I had fixed it but I was wrong and it still shows up.

Thank you very much. That seems to be the origin of the problem. It was driving me mad looking everywhere. Thank you :)

No worries haha. Thanks for trying

I work on the database whilst I'm at work on a shared computer so it's quicker to keep them invisible as I only work on the forms mostly. Thank you for your advice. I did not create the database from scratch so I didn't teach myself much about those things. I will take a look at them.

they are greyed as they are hidden but the option "display hidden items" is on. Clicking on them should still open them. Thank you for the screenshot. That is very weird that i dont get that error. Ill try to upload a better version tomorrow. This database is driving me crazy

please let me know if this is better. Its a bit hard for me to tell.

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?