Sign in to follow this  
Followers 0
raquien

Form Design

8 posts in this topic

Hi Guys, I am designing a form that fetches information from a database and display it in a grid-like form with controls in each row. Can somebody point me to a right direction on how to get this? I've attached a sample screenshot of the design that i am planning to do.

Thanks guys..

Share this post


Link to post
Share on other sites



if your just needing information on how to create a form? i would use the koda builder.

Share this post


Link to post
Share on other sites

Thanks for the reply. Yes, I am aware that Koda can help me make the GUI, but this is not a simple GUI, the number of crontols depends on the number of entries that is fetched from the database. Say, if I have 20 entries in the database, then the GUI would display 20 combo boxes, 20 buttons and 20 sets of each labels.. Plus it will have the option to use vertical scroll bar if number of entries exceeds a predefined number.

Share this post


Link to post
Share on other sites

Hi there, I have no problem pulling out the data because i already tried using MySQL UDF. My only problem is how to dynamically design the controls. Or is it possible if I'll design the form in VB then just call autoit script on every event?

Please help, thanks..

Share this post


Link to post
Share on other sites

Hi there, I have no problem pulling out the data because i already tried using MySQL UDF. My only problem is how to dynamically design the controls. Or is it possible if I'll design the form in VB then just call autoit script on every event?

Please help, thanks..

Something like..

(get number of entrys first)

Dim $Entrys[N]
For 1 to N
$Entrys[N] = GUICtrlCreateButton ( "Button " &N,  $Left,$Top,$Width,$Height )
next

You would need to update the $left and $top depending on the size of the buttons and where you want them to be.


2015 - Still no flying cars, instead blankets with sleeves.

Share this post


Link to post
Share on other sites

Hi, thanks for the reply.. What about the alternating colors on the backcround and the use of vertical scrollbar if say, number of entries exceeds 15. Thanks..

Share this post


Link to post
Share on other sites

#8 ·  Posted (edited)

as far as alternating colors is concerned...u cud put a check on the loop variable...if it's odd dont put any color...if it's even then put a color in bground....

and for vertical scroll bar...set the limit of ur GUI to someting, if the data exceeds the limit...I guess scrollbars would come automatically....

Just some thoughts...not tested

Will try to come up with a working solution as soon as possible..

Edited by kclteam

I believe we should all pay our tax with a smile. I tried - but they wanted cash!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0