Search results

Yeah, but it's simple. Some databases don't need complicated switchboards. Not enough information. :)

alktrigger, It works great! Thanks again! I def. like the tab control.

Is there anyway you could save that as a .mdb file. I would greatly appreciate it. Thanks

That's what I thought but it's not updating after clicking on another field. Bob, I have a thread for Switchboard examples, would you be willing to share some examples. I don't want to use the switchboard manager and can't seem to find a good starting point.

Correct, It's working great Bob! But I have to scroll to the next record to save the text and then scroll back to the previous record to edit the option group. Is there another event that will make the option group unlocked right after text is entered without scrolling back and forth?

Is there anyway to make the option group unlocked right after the text is entered into the textbox. Right now I have scroll to another record and then back to enter the option group? Thanks

So for the On Current: Call SetLockedEnabled(Me, "YourOptionGroupName", "YourTextBoxName") Call SetLockedEnabled(Me, "YourOptionGroupName", "YourTextBoxName") Call SetLockedEnabled(Me, "YourOptionGroupName", "YourTextBoxName") Call SetLockedEnabled(Me, "YourOptionGroupName", "YourTextBoxName")...

Sorry Bob! I need to place a call function in the On Current and AfterUpdate correct? Like Call SetLockedEnabled (Me, True)

alktrigger, would you be willing to save your switchboard in a new database so I could see the code. How did you get the tabs? Thanks

Hi, Would anyone be willing to share their switchboard designs? I don't want to use the actual switchboard manager but create a form and use it as my switchboard. I'm having a hard time getting a good start and making it look organized. Thanks so much!

Ok, so the Afterupdate/OnCurrent calls the module then. Gotcha. Thanks for your time Bob!

Thanks so much guys! So modules run automatically right? Gizmo I can't get to your link. Blocked. Thanks though.

Where do I put the top code? So I place the bottom code in both afterupdate and oncurrent correct? Is there anything else that I need to change in these codes. Don't I need to change the strTextBox and strOptionGroup with exact text box and option group? Sorry for the noob question. Thanks Bob!

Any ideas? If I have to copy this code for each set than that's fine.

Haha our company won't be upgrading to 2007 until.....ever! Thanks Alisa for your time.

Ok, so I figured it out. When I would open the BE using the shortcut it would override my permissions and give the Users group all the permissions because the owner was still Admin. So I opened the BE using my .mdw and created a new database as the owner and imported the tables. After that I...

So open the BE using the shortcut and then apply permissions? But I already have permissions set for tables already from the FE. What do you think?

Here is the guide I'm using. I'll check the admin rights again but I'm sure there aren't any. Do I have set permissions just like I did for the FE? I shouldn't have to since I am using the same .mdw correct? The FE works just fine and so does the BE when opened with the shortcut. I just can't...

I have no idea what i did. I have tried logging in with .mdw and then creating a new database and then importing the tables so the owner is no longer the Admin. After that when I open the BE using the shortcut everything works fine and the owner is the Super User but when I open it by itself it...

Hi, There have been plenty of threads on having a field unlock after another field has been updated. I have 5 sets of an option group and text box. I want the option group locked/disabled when the text box is empty. Maybe one might sufficient. Here is the code I'm using in both in AfterUpdate...