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...
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
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
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...
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
What is the Access SQL equivalent of Oracle's DECODE function?
Oracle's DECODE has a syntax something like this:
select
decode(Col1,'A','Active','I','Inactive','Other')
from SomeTable;
Translated into pseudo-code, the DECODE might read:
If Col1 = "A", then return...
Is there a simple way of displaying cell values in thousands? I don't want to create a new column with a formula such as "=A1/1000". I'd like to be able to visually see the value with the thousands removed, yet see the entire value when editing the cell. Is there a way to do...
Hello friends,
I've been out of the Oracle development world for some years now. My previous Oracle contract was in the early-to-mid 90s using Forms 3.0 and ReportWriter 1.1. The app still exists on a single PC with a single user (though the PC has been upgraded once or twice). I enjoyed...
Hello friends,
I've been out of the Oracle development world for some years now. My previous Oracle contract was in the early-to-mid 90s using Forms 3.0 and ReportWriter 1.1. The app exists on a single PC with a single user. I enjoyed developing in that environment, but I'm sure all of the...
I'm accustomed to large RDBMSs where you can write a script with many DDL commands (create table, drop index, etc). MS Access seems to only allow one DDL statement to be executed at a time, and it has to be submitted interactively. Please tell me how to feed a DDL script with many DDL...
I have read the POSE (Palm OS Emulator) documentation carefully. It says to have a directory called "Skins" in the POSE directory to enable the access to different skins. My Skins directory contains the various skins files. However, when in the emulator, and I right-click and then...
Does anybody know how to print an Excel spreadsheet so that the rows have alternating colors? e.g. First row, light blue. Second row, no color. Third row, light blue. etc.
Thanks!
Some weeks ago, I asked if anyone knows how to send e-mail using VBA regardless of the MAPI client (Outlook, Outlook Express, etc.). The reply I got give me an error. Does anyone know how to make this work?
The following code:
Dim strAttachmentPath As String
Dim iMsg, arrEmail
Set iMsg =...
Does anybody know of a way to suppress repeating values in Excel? Note: I don't want to change the actual values in the cells. I just want to suppress repeating values in specified columns from displaying. In the following example, all cells actually have data values. Repeating values in...
My app needs to send an Internet e-mail message to a single recipient and with one file attached.
I have found information about how to accomlish this with Outlook, but I need for this to work with Outlook Express.
SendObject won't work because it won't allow a file to be attached.
Can...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.