469,578 Members | 1,869 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,578 developers. It's quick & easy.

VB. Net Form Menu dynamically linked to SQL Table values

Hello,

I am trying to create a form in Visual Basic.Net with a dynamically
created Menu bar. I need the drop down part of a menu item (Reports)
to be dynamically generated according to the values of a SQL 200
table.

for Example, let's say I have this SQL table with the following fields:

Orders ReportName
_____ ______________
89BB BBReport_Order
89BB BBReport_Invoice
89BB BBReport_Customer
32NN NNReport_Order
32NN NNReport_Invoice
32NN NNReport_Customer
...

Now, let's assume my form is finished and working. The current user is
a 'NN' person. Therefore, I need to display the NN reports in my form
Menu toolbar. I need the Reports Menu Item to be '32NN' and underneath
show the name of the reports as submenus. The same would be for an
user that's a 'BB' but showing the 89BB field as the menu item and the
BB reports as submenus instead.
Here's a visual representation of my menu bar. (user's a NN)

File Reports Help
Exit 89NN About
NNReport_Order
NNReport_Invoice
NNReport_Customer
Does anyone know how to accomplish this? Is there an example similar
to this that I could use? What the user will do is to click a report
name and then either preview it in a Crystal report Viewer or send it
directly to the printer.

Thanks as always for all your help.

Jul 5 '06 #1
0 929

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by R. Rajesh Jeba Anbiah | last post: by
6 posts views Thread by Sandy | last post: by
26 posts views Thread by Jerim79 | last post: by
4 posts views Thread by greg | last post: by
3 posts views Thread by Robert McEuen | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.