Recent content by dkmort

You got it exactly right. I googled it & found it in between my post & just now. Thanks!

I am looking for some VBA code that I can implement that will allow me to create an if then statement that would do something like this. if forms a, b, c, d, e and f are NOT open then LightboxForm.Hide end if Or maybe simpler, which would probably work would be: if OpenFormCount>1 then...

Hmm. That's an interesting idea. I'll keep it in mind. I may very well use it. But it will probably take me at least a few hours to implement it. I like the idea though. :-) Just when you think that you simply may not be able to do something, someone else points out a "different" way that it can...

Anybody know whether this is possible? I think I had tried it in the past, but it changed the height of EVERY record, rather than just the one I had selected. If you know an answer to this (whether it can or cannot be done), I would appreciate any input. Cheers! - Doug Mortensen

I don't know that I would call it a fix. But I posted my work-around in my initial post in this thread.

For others who may run into this problem, I thought I'd share this info to hopefully save you the 30-45 minutes it took me to figure it out :-) The short story is that I have a database with a form that opens in continuous forms view. I originally built the form in Access 2007. Then started...

The filter just took 49 seconds to apply. During this time the Access front-end is unresponsive, and on the SQL 2005 server, the CPU is at 100%, with the bulk of it being from sqlservr.exe. At the same time that MS Access becomes responsive, the CPU on the server also drops down to nearly idle...

There is no question that it is requerying my sql server. Any time I use docmd.apply filter in an action for a button, the cpu on my sql server goes to 100% until the data finally displays on my form on my front end. I will check into your other suggestions. Thanks.

I have a multiple items form that I'd like to be able to have the user click various buttons to apply different filters to form data. This is working via DoCmd.ApplyFilter However, every time that this action is taken, it is actually sending the filter as a query to the back-end Microsoft SQL...

Move to another form or table?

First off, let me say that I've read several threads that strongly discourage from using 1-1 relationships. I will give an explanation of my situation in this post, and you all can tell me if there would be something better for me. I am linking to several MS SQL 2005 tables from Microsoft...