Search results for query: *

I'm having this problem as well. If I find a solution, which means that you can cycle through the forms then I'll post it in the FAQ's section under a new heading. Give me some time though, because I'm going to have to code this one in VBA. Microsoft's help site mentioned above says its...

You can compile your project so that your users cannot change the structure of your forms... in design view. do this by creating an MDE file. The best way is probably to simply rename your database, because you can't design view a renamed database. I think. If that doesn't work, I'd go MDE.

Do your sub-forms start off open. If not, then you can set a variable, and as they activate, if the variable has been set by your button, then they can allowedits = true. If they are starting off open, then it may be an idea to close, and then open them without the user noticing, except for...

That gives me some ideas, hatching away. Thanks for the tip. I'll re-run my SQL code with some of your ideas incorporated. I can see it now...

ANSI style joins are the answer. Look em up. you never know.

I have a small/large/problem problem. Whatever. I would like to create a report with a list of primary keys which do not have information in a corresponding field i.e. SELECT tblBase1.[Primary] WHERE tblBase1.SECONDARY = "" FROM tblBase1... The problem being, that I want to select...