Search results

Hi DocMan, thanks for your reply. The link you posted to fmsinc is one of the first things I read when I Googled the issue so I've already read that, but thanks all the same. Your last paragraph includes some good tips, but I can't see how any of those apply to the issue I have unfortunately...

Hi all, I have a simple query involving 2 tables with an inner join and the resulting recordset is updateable. But when I add another table to the query which is inner joined to both of the other 2 tables then the resulting recordset is now not updateable. Can anyone explain why? My query...

But using my own code to resize the form is irrelevant. Even without any Resize event code running (as in my sample DB attached to this thread), the subform gets unloaded regardless. I think you're missing the point. As I said originally, the user probably won't resize it so drastically small...

When I said I had "plenty going on" in my Resize event, I was referring to the code in my live applications, where I reposition/resize various controls. The sample DB that I attached to this thread in post #1 was deliberately an extremely simple example in order to highlight and demonstrate the...

Colin, I don't know why, but this forum refused to let me reply to your comment about your AFR link while quoting the URL. But thanks for that link. I haven't had chance to go through it thoroughly yet (as it includes a couple of hour-long YT videos) but it certainly looks interesting...

The implication from this is that you don't have user-resizable forms at all in your apps - is that correct? Maybe I'm so old that I miss the days of MDI forms which all Office applications used to use and no longer do. I prefer to make my forms user-resizable if at all possible. Many controls...

I find it bizarre that you are the second person to say that they had no problem and your focus did not revert to the first row. In my actual code, I do indeed have plenty going on in the Resize event, including changing the size of the subform in a similar way to the code you suggested. But as...

Hi The_Doc_Man, I agree the answer lies in the fact that these events are occurring, as I said in my OP. The question is, why on Earth are they occurring? I don't want the Unload/Close events etc to occur at all. They don't happen if there are no headers/footers AND they also don't happen if the...

Hi, I'm fairly new to Access programming and, despite being very familiar with the syntax of VB/VBA, the behaviour of the Access data-bound forms can sometimes be quite alien to me. I can go into the details of my particular coding "challenge" if asked, but I think my problem can be brought...