Solved Security for buttons in switchboard

[Uncle Gizmo]

If you are using the VBA version of the Microsoft Access Switchboard utility, then I don't think you should try and move the controls up to fill the gaps. The Microsoft Switchboard Builder Code is what is normally referred to as a "Data Driven" System.

It makes more sense to adjust the data, not the position of the text boxes. I think you should renumber the items to remove the gaps.

I did something similar with my own version of the Microsoft Switchboard Manager --- See this Video:-


Nifty Switchboard Builder - Fix Missing Row

The Nifty Switchboard Builder is HERE:-

https://www.niftyaccess.com/nifty-switchboard-builder/

If you would like a copy of the Nifty Switchboard Builder - Contact me and I will explain how you can get in for free...

 

[oxicottin]

@Uncle Gizmo Look at UpdateDesignOrder() in sfrm_MenuEditor which fixes the issue you show in your video.

@isladogs I know you want I just was explaining and wanted to give my appreciation for the advice!

 

[oxicottin]

Here's a slightly different take on a switchboard builder. It uses a subform so you only see rows for which there is data. There is rudimentary security in the app and you could use it to filter the rows shown by the switchboard although I'm not sure that I actually implemented that feature, it was something I considered.

@Pat Hartman You had given me that example before and that's where I had used some of it for what I have. In your frmSwitchboard example you are using TempVars is that how your achieving the buttons that only populate or is it just that your using a query to populate them? I also like the image for the button but I couldn't get it to work with I have, maybe you could explain both and i'll give her a shot!

 

[oxicottin]

@Pat Hartman I hadnt downloaded the example you posted I got mine working using the TempVars + my security ect but with the subform like you showed previously so only the buttons your allowed is visible and with no gaps... I will post a copy once I get the icons added in I haven't messed with that yet.

I do want to ask what images can I use? .bitmap, Jpg ??

Moving along now

 

[oxicottin]

OK, Here is a final version of a Switchboard "Well So Far" and I like how it turned out. Using Pat Hartmans idea with the TempVars and a subform I was able to only show button depending on what security AND it orders the buttons instead of leaving gaps like previous versions.

 

[oxicottin]

Please use the site methods to upload images.

Already deleted.... and it was a site method (Insert Image), not sure why they were so large