Solved

VB 6.0 enterprise "DIAGRAM MENU"

Posted on 1998-11-13
5
594 Views
Last Modified: 2008-02-01
Can anyone tell me what the "Diagram" menu option on the main menu bar of VB 6.0 enterprise is for.  It appears on my installation, but all the options are inactive.  I even uninstalled and reinstalled VB, thinking that I had an install problem.  I have installed VB 6.0 SP1.  I can't find any information on this thing in any of the MS documentation, not even searching through the online knowledgebase.  I guess I must not need it, since I am working without it, but I sure would like to know why it is there....
0
Comment
Question by:rwallis1
  • 3
  • 2
5 Comments
 
LVL 1

Accepted Solution

by:
tjp earned 100 total points
ID: 1444794
It's for creating/editing MS Access-style relationship diagrams.
To use it in an existing project:

1.  On the Project menu, click "Add Data Environment" (if you don't already have one; if you do, skip to 3.)
2.  Connect to whatever database you want to use.
3.  Now that you have a successful connection to a DB, go to the View menu and click "Data View Window"
4.  Expand "Data Environment Connections" and "Connection1" or whatever you named it.
5.  Right click on Database diagrams, and select "New Diagram..."

A window will open now for you to create the diagram in, but you might get a warning if you are not logged in to the database as sa or the db owner.  The Diagram menu's items will now be active as well.

There's info in the MSDN Library included with VS6, too.  Look in the contents under:
Visual Studio Documentation\Data Access Tools and Techniques\Microsoft Visual Database Tools\The Visual Database Tools in Visual Studio\Database Designer\Working in Database Diagrams
0
 

Author Comment

by:rwallis1
ID: 1444795
Well, I know how to create database diagrams as described here, however, I still don't know what that has to do with the "Diagram" option on the main menu bar.  I have created diagrams and tried every way I can think of to "activate" the main menu bar "Daigram" option.  I agree that the documentation makes it sound as if "Diagram" has to do with "database diagrams", but, you gonna have to show me someting I can do by clicking on "Diagram" or one of it's options.
0
 
LVL 1

Expert Comment

by:tjp
ID: 1444796
When the Database Diagram is the active window, the items on the Diagram menu will be available...  at least, that's the way my VB 6 Enterprise works.

Make sure you don't click on any of the tool windows in VB before you check the Diagrams menu.  If the Toolbox, Project, or Properties windows has the focus, your Diagram menu items will be disabled again.
0
 

Author Comment

by:rwallis1
ID: 1444797
Thanks for the reply.  I'll try again.  I figured it should work as you describe, but, so far, I haven't ever seen anything in "Diagram" active.  I am using ADO exclusively.  Would that have any bearing on "Diagram" being active?
0
 

Author Comment

by:rwallis1
ID: 1444798
Well, I tried again based on the following comment:

"When the Database Diagram is the active window, the items on the Diagram menu will be available...  at least, that's the way my VB 6 Enterprise works."

My VB 6.0 Enterprise doesn't work this way.  There has got to be more to this.  I have heard that the Diagram menu is active only for SQL Server, can anyone confirm this?  I am not using SQL server, I am using Progress via ADO/ODBC and Access.
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
vb6 programatically bring window to front 8 72
Visual Basic Excel Formatting error 4 107
Macro Excel - Multiple If conditions 2 72
Added a column screws up code 5 57
There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question