Recent content by scottm91

I'm not using any code. Just simple references. To reference the value of the combo box which selects the salesperson I'm just using the control name [SalesOpt]. But I figured something out yesterday - when I open the form on my PC it never works. What I have to do is create a text box that...

I can reference the combo box directly - sometimes. And when that doesn't work I create a mirror text box to do it. And when that doesn't work, I go back to referencing it directly. It's nuts. And it's only in the mdb - not the executable. It makes NO sense!

I have a form (a switchboard) that has a combo-box from which the user selects a salesperson. Other controls then reference that form to generate the appropriate filter. Well, that didn't work consistently, so I created a text box that references the combo box. Then had all the controls...

Ok, figured part of it out. Apparently my computer thinks that the database that *I* created isn't trusted (only Microsoft.... AUGH!). I went in to Trust Settings and told it to trust my computer and my network, and I'm still getting the little error symbols in my macros. Why does Microsoft...

I have a simple macro (well, should be anyway) where I have a combo box that sets the value of an unbound text box that is then referenced by other controls in that and other forms. It worked fine last night. Choose an option, it sets the value, and all the references are fine. Now - after...

Thanks, but that didn't seem to work. I had some error messages and the mere presence of a module seemed to interfere with the MDE file being saved properly. I've noticed that Access 2007 is a very different beast than its predecessors. Don't know why they took away the Startup Options window...

Well that explains that. I was under a wrong assumption, apparently. I've sent her the link to download the runtime version so we'll see if that fixes the problem. Much thanks!

I know how to create the MDE file, and it opens fine on my PC when accessed via our network and on our Exchange server. But my colleague, for whom this was created, in large part, cannot open it. The icon doesn't even really show up. What needs to be done on the server or on her machine to...

I'm creating an MDE and have it all worked out, but I want it to open ONLY my switchbard, like a popup - not the Access window. I've got it so that it opens the switchboard in a dialog window but the Access window opens behind it. I don't want it. I know how to turn off the navigation pane...