Solved

Layout and control question

Posted on 2000-03-24
4
173 Views
Last Modified: 2010-05-02
Hello all.

I need some help in the design and/or layout of a program I wish to write.  What I need to do is connect to multiple Oracle databases, from 1 to x.

I then need to run a handful of queries against each db, query 1 to n, compute the returned data and return the values as pass/fail values.

The connection and computations are not a problem. My quandry lies in the fact I am unsure how to properly display the results. A primary goal is flexibility and a good graphical presentation.

I do not want to stack all the data into a grid, but would rather have a seperate form for each databases' results held within an MDI form. Am I heading in the right direction in thinking that building a template form that can be reused x amount of times is acheivable? How would you go about creating this "template" form?

TIA,
Daren
0
Comment
Question by:darenjackson
  • 2
4 Comments
 

Expert Comment

by:sljbaqga
Comment Utility
I can't understand the purpose of your prog.
:)
but i think what you thought was correct. My opinion is to create a new instance of the same form with different set of parameters for database and query stuff.

so create a form which can display and retrive date from the database.
create a public sub or function inside the form so you can pass database name and the Query set to the form.

in the MDI form use Load method to load a new instance of the form for a particular DB and Query set. so it'll create a forms array.

hope this will be helpfull,
regards

Prasad
0
 
LVL 14

Accepted Solution

by:
wsh2 earned 50 total points
Comment Utility
As your results are going to be 1 to x.. and the data presentation is all going to be sililar..using a MDI form is a GREAT choice.. <smile>

The quickest way to get started is to open a NEW project.. and in the New Project window.. select the APPLICATION WIZARD (instead of the Standard Exe you are accustomed to). The first screen will ask you for a custom predefined profile (ie. one of your own creation).. as you probably don't have any yet.. press the Next radio button on the screen.. and there you will get to choose a MDI interface. From there it will ask you what other options would you like and you may pick and choose as you go (for now.. you may want to keep it simple and go with the defaults). At the end of the Wizard.. VB will build you a MDI programming shell.. that you can modify as you like.. <smile>.

The frmDocument that it makes.. is the template that you desire. The frmMain is the MDI container (that is limited to only the controls that are placed there.. a toolbar, menu, and status bar are the only VISIBLE controls allowed on an MDI form). With each NEW frmDocument statement that is executed in the frmMain code.. a new frmDocument will be added to the container.. and each will be indexed. If I may make a suggestion here.. store something unique in each new frmDocument's Tag property.. you will be able to use it as a kinda key if you will be looking for a specific form after everything is loaded. The best way to search for a frmDocument is by using For Each frmVariable in Forms and testing the Tag statement.. for a unique identifier.

In coding your frmDocuments.. you want to make use of the Me keyword. As all the frmDocuments are going to be using the same code the Me. prefix delineates to VB that the code applies to the current child form with focus. If you need to reference the current child form with focus from outside of the frmDocument code.. you can use the Active. prefix to accomplish this.

Another thing you want to look at is the snippet of code used with the Window menu item. In there you will see methodology to tile all the windows at once on the screen symetrically. as you are going to have 1 to x forms.. this little bit of code is a real time saver.

Welp.. datz it for now. If this is all new to you.. I suggest you review your MSDN examples.. or perhaps get a VB book. MDIs are not that hard if you have examples to follow. And the Application wizard will give you just that.. <smile>.
0
 
LVL 14

Expert Comment

by:wsh2
Comment Utility
sljbagga:
"I can't understand the purpose of your prog.".. How do you call that an answer? You just locked this question down.. making it very difficult for anyone else to help darenjackson!!!

An answer on EE is supposed to be something definitive.. and that there is no other possible solution to the question. Your response hardly qualifies as that.. and for that you are rude.

If you will notice on your screen there are TWO buttons.. one is for COMMENT and the other for answer. By commenting, you let the questioner choose which is the best answer.. and if the questioner picks yours as being most appropriate.. then you will certainly receive the points that you are well deserved of.

If you can in the future, try and behave professionally, and comment on the question, and let the questioner be the judge of the winner.. <smile>
0
 

Author Comment

by:darenjackson
Comment Utility
Thanks alot....

I appreciate your help. I only have 130 points remaining or I would have given you more. It sure is hard for a newbie VBer to get points here :P

Thanks again
Daren
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Introduction I needed to skip over some file processing within a For...Next loop in some old production code and wished that VB (classic) had a statement that would drop down to the end of the current iteration, bypassing the statements that were c…
Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now