Recent content by JohnF53

I think that having your code in the OnOpen event is causing the problem. The Access Help for the Form.Open event: "The Open event occurs when a form is opened, but before the first record is displayed." ... as I understand it that means that at the point where the OnOpen event is triggered...

Ok, I've found what is causing this problem, in my case at least. The forms that open in independent windows have OnOpen and OnCLose events with macros assigned. Once I removed those the forms stayed embedded into the Navigation form as expected. Thanks for the advice, which got me thinking...

I understand what you are saying, as I have fallen foul of that before. I don't think that's the situation with the Navigation forms though, as its more automated than building your own tabbed form and the 'activation' issue will not apply (as I understand it).

Well, I don't like Navigation forms either, but my colleague wanted to use them. Also, out of academic interest I'd like to understand why the thing I described happens.

Hi, I am helping some developing an Access application with a bit of help and advice. We have come across an odd situation. He had several forms, and then wanted to create a Navigation form. Ok, so far. When he dragged existing forms to the Nav. form all seemed ok. However when running the Nav...

Ok, problem now resolved, sort of.... I downloaded the problematic database file from the user's system to mine again, in order to examine it. Fired it up on my system and Access said "there's something wrong with module(s) in the database. The problem can be fixed." So, I said "go for it" and...

Also....... thanks for the advice so far. :-)

Hi, Ok, I checked the libraries and they are the same. In any event the problem occurs, and the weird fix works, entirely on the user's system. Re. permissions - again the whole thing happens while I'm logged in as me, so the permissions are constant. I do have error trapping in the little...

Hi, Ok, thanks, I will check that. However, things have worked up until now and I don't think anything has changed that should cause the issue you describe. The change I actually made was to add a couple more fields and correct a bug in a Dlookup, nothing fancy. Also, I can fix the problem...

Hi all, I have a strange problem I hope you might help me with. The situation is that I have developed a database application for a client. They run it on a Server 2003 machine via remote desktop. It is multi user so there is one back-end database with tables in it and multiple copies of the...