Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: klm2klm2
  • Content: Threads
  • Order by date
  1. klm2klm2

    One or many lookup tables

    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...
  2. klm2klm2

    How to highlight Excel cells with calculations?

    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
  3. klm2klm2

    Cost of Dimensional vs. Relational approaches

    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...
  4. klm2klm2

    Does dimensional data modeling have a logical component?

    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...
  5. klm2klm2

    Cobol for Windows with no run-time fees

    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
  6. klm2klm2

    Open 2nd Access database

    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
  7. klm2klm2

    Unattended data import

    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
  8. klm2klm2

    How to allow zero length strings with DDL statement

    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...
  9. klm2klm2

    Run a report without starting Access first

    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
  10. klm2klm2

    Access SQL equivalent of Oracle DECODE

    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...
  11. klm2klm2

    Displaying 10,000 as 10

    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...
  12. klm2klm2

    The "right" development tools

    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...
  13. klm2klm2

    Windows development - moderate complexity

    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...
  14. klm2klm2

    Wireless modem HotSync with Treo

    Can I perform a wireless modem HotSync with my Handspring Treo 300? If so, how? Thanks, Kim
  15. klm2klm2

    DDL script in Access

    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...
  16. klm2klm2

    How to access different skins with POSE

    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...
  17. klm2klm2

    How to print Excel spreadsheet with alternating row colors

    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!
  18. klm2klm2

    How to send e-mail from VBA regardless of MAPI client

    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 =...
  19. klm2klm2

    Suppress repeating cell values in Excel

    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...
  20. klm2klm2

    Send Internet e-mail from Access VBA

    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...

Part and Inventory Search

Back
Top