Improve company productivity with a Business Account.Sign Up


Layout and control question

Posted on 2000-03-24
Medium Priority
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?

Question by:darenjackson
  • 2

Expert Comment

ID: 2656246
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,

LVL 14

Accepted Solution

wsh2 earned 200 total points
ID: 2656269
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>.
LVL 14

Expert Comment

ID: 2656284
"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>

Author Comment

ID: 2656342
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

589 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