Recent content by klm2klm2

We're designing an enteprise application. Some of our team members who are experienced with DB2 want to merge all of our lookup (i.e. reference) tables into one table. I normally let every logical lookup table be its own physical table. When using the Oracle database, is there any material...

I'd like to be able to display Excel cells with calculations with different formatting than other cells. e.g. If the cell contents begin with the equal sign, let the displayed value be in blue instead of black. Is there a way to do this? Thanks, Kim

There is a theory that the cost of creating, implementing, and maintaining a dimensional DW is less than that of the relational model because the dimensional model is simpler. Does anybody have any knowledge (or even ideas) about how much the dimensional approach saves over the relational...

kishleo, To find support for dimensional modeling in ERwin 4.1, click on Model | Model Properties | General tab | Dimensional. Then Model | Model Properties | Notation tab | Dimensional Modeling. Thanks, Kim

I'm using ERwin 4.1.

In ERwin, a popular data modeling tool, the three basic modes are Logical, Physical, and Dimensional. In the dimensional mode, there is no logical and physical. The dimensional mode stands by itself. In other words, in a dimensional model, a column can't have both a logical and a physical...

Hello All, I'm looking for a Cobol IDE/compiler that: 1. Runs and has developer environment on Windows 2. Creates Windows GUI apps 3. Uses MS Access (or ODBC) database 4. Is reasonably priced 5. Has no run-time fees Does such an animal exist? Any suggestions? Thanks, Kim

Is Forms 3.0 still supported?

If I'm using VBA to access the currently open Access database, how can I concurrently open a 2nd Access database such that I can process both databases in the same procedure? Thanks, Kim

The preference is to use VB because the app is currently written in VB. How would we get started, using VB, to import data from an external source into Access?

How can data from an external source (e.g. XLS, CSV, etc.) be imported into an Access database in an unattended manner? This will be used as part of a software revision update deployment. Perhaps a VB program could kick off such a routine. But how would we go about doing it? Thanks, Kim

I have a DDL statement similar to this: alter table blah_table add column blah_column char(20); The statement *does* add the new column. However, I want the "Allow zero length" column property to be set affirmatively. How can this be done in a DDL statement? If it can't be...

JoyInOK, I'd like for the solution to not include VB. Please elaborate on how to open and run Access with the visible property set to false. Or at least provide key words to look up in the help files. Thanks! Kim

Interesting idea, Ian. Unfortunately, I don't have an Access application. I have a VB application that uses an Access database. Is there some way to trigger the running of the report when the database closes?

I want users to have the ability to run a pre-defined Access report, but I don't want them entering the Access IDE (the database is password protected). How can I give users the ability to run an Access report yet keep them out of the Access IDE? Thanks, Kim