Printable View
Hi guys,
Attach is my form (in excel) that I want to create. This is my first program so I guess is a long way to go. I had a rough idea on how to use vb6 but still I will not call my self programmer now. Here is my query:
1. How to create those drop down MENU?
2. My combo box will get data from an access database, any fine tutorial on this?
Anticipating your guidance.
Regards...
Welcome to the Forums. :)
I dont have winrar but if you made a form in Excel then your doing VBA programming which is very similar to VB6. You are doing this all in Excel, correct? We have a Office Development Forum just for this type of questions. ;)
Welcome to the Forums.
just to inform you that more ppl will help you if you change the title to your question. titles like the one you wrote makes ppl not go to your thread rother then go.
ppl that might have had the same question as yours in the past could help you with yours now.
No no.The excel is just a picture of what my form would look like. Sorry for the confusion.
Yes, perhaps ill re-phrase my question next time.
Ill post a jpeg on it.
Ok, here is a good tutorial thread on Databases and ADO.
http://www.vbforums.com/showthread.php?t=81916
You can create a "dropdown menu" or Menu by viewing your form in design view and clicking the Menu Editor icon or by going to Tools > Menu Editor (Ctl+E). Then you can build your menu in there and it will appear on the form. ;)
Thanks RobDog,
As I say it's gonna be a long way, but hey no guts no glory,right? Anyway my question is gonna be poppong in the days to come.
Thank you.
since you just started vb i would sugest that you will stat will comman codes and then look at menus. as you show you app need to have a database and that some complex codes. i sugest that you start off easy
Yes, that is a good suggestion. Hard code in some values for populating your combo box. Once you get the "feel" you will better understand the tutorial. ;)
Ask any and all questions as we are here to help. I remember what it was like starting out and I sure wish I had found this site back then but it wasnt running back then. :( :)
I had some time so i made a little help making menu since i sow that RobDog gave you a good link for a database:
1)
http://www.scriptsorcodes.com/images...u_making/1.GIF
2)
http://www.scriptsorcodes.com/images...u_making/2.GIF
3)
http://www.scriptsorcodes.com/images...u_making/3.GIF
4)
http://www.scriptsorcodes.com/images...u_making/4.GIF
Nice wiz126. Just to add, the left and right arrow buttons either indent or outdent, making submenus and sub-submenus, etc. ;)
You may find some useful things on my site as well. Below is a link for a tutorials on menus:
http://www.thevbprogrammer.com/index...ter=10&Topic=1
It's always best to learn programming concepts before jumping into the OOP (object oriented programming) approach. That'll give you a good feel on how to program.