Search results

Thank you very much this is helpful. I think the query explains the ghost values. And I think youre right with it being a compacting bug as it only happens 10% of the time. For now I'll just switch the combo box to a text box instead. Thanks!

Default value? There is nothing. To clarify the database works perfectly fine until I compact the backend. 90% of the time it compacts without problem but sometimes it will have this issue where the combo box acts differently despite having the same properties. I think for now I'll change it...

Hello, When I want to compact my backend I will open and close it. I sometimes then have issues with the field in my table that is a combo box. It for some reason becomes a required field despite it saying Required Value = “No” . So when any new record is created it will input a value on its...

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.