PC Review


Reply
Thread Tools Rate Thread

VB. Net Form Menu dynamically linked to SQL Table values

 
 
ILCSP@NETZERO.NET
Guest
Posts: n/a
 
      5th Jul 2006
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.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Save Linked tables values in form based table Microsoft Access Forms 0 29th Dec 2009 06:38 AM
Re: Save Linked tables values in form based table Arvin Meyer [MVP] Microsoft Access Forms 0 12th Dec 2009 04:19 AM
prompt need to locate missing linked table necessary to open main menu form Mark Kubicki Microsoft Access Form Coding 2 15th Jul 2009 01:35 AM
How to dynamically change path for a linked table? John Microsoft Access 3 5th May 2005 09:26 AM
Access to onclick events of button controls within dynamically created table + adding linked image to table cell Hrvoje Vrbanc Microsoft ASP .NET 0 11th Mar 2004 04:00 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:18 PM.