Search:

Type: Posts; User: epic60sman; Keyword(s):

Page 1 of 11 1 2 3 4

Search: Search took 0.01 seconds.

  1. external floppy for OMNIBOOK XE4100 LAPTOP

    I have been in-putting files into an HP Omnibook xe4100 and the floppy drive has failed. A disk got stuck in it and I may have sprung something while I attempted to get it out. At anyrate, it seems...
  2. Replies
    1
    Views
    295

    Hyperlinks (2002-SP2)

    Hi:
    I keep a Worksheet with hyperlinks to other workbooks. Is there anyway to prevent these hyperlinks from being wiped out each time Windows crashes. I tried keeping a copy of the hyperlinks in...
  3. Format data copy from Web Site (Office XP Windows XP)

    Hi Everyone:
    I have a problem getting EXCEL to recognize that what look to be numbers as numbers. The istext function returns "TRUE" but the VALUE function will not convert the cell values to a...
  4. Replies
    1
    Views
    330

    XP Crashes (WindowsXP )

    I am having problems with WindowsXP. It will freeze and then reboot within about 1 minute. When it reboots, it will continue to freeze until I pull the plug and start over fresh. Then, I get the...
  5. Re: Countif forcomparing values in 2 columns (XL 97 SR2)

    Hi John:
    Thanks so much. This is exactly what I need.
  6. Countif forcomparing values in 2 columns (XL 97 SR2)

    Hi Gang:
    I am sure that I had this one down but it seems that the model for it was in some files that I lost. Anyway, I have 2 columns of numbers and I want to count the number of rows where the...
  7. Replies
    5
    Views
    490

    Re: MONTE CARLO SIMULATIONS

    Hi:
    Unless you have need complex queueing and/or flow models with lots of hierachical relationships and branching, building your own System in EXCEL(with VBA) has always been the best bet for me. ...
  8. Re: Outlook and Outlook Express (Outlook 2000)

    They use both.
  9. Outlook and Outlook Express (Outlook 2000)

    Hi:
    I am taking some online training and it is set up through Outlook Express. I need the capability to post some notes to myself whic I can do with Outlook but not Outlook Express. Can the two...
  10. Re: Using a Union Query to combine Tables (OFFICE 97)

    Thank you. This will do fine.
  11. Using a Union Query to combine Tables (OFFICE 97)

    Hi Everyone:
    I had 5 tables that I wanted to merge into 1 to make it easier to query. So I attempted a union query:
    SELECT RCOARRTM_ANS.* INTO RCOARRTM_ALL
    FROM RCOARRTM_ANS
    union all
    SELECT...
  12. Re: Auto Append Monthly Tables to a Master (Office97 sr2)

    Hi Charlotte:
    By "deposited", I meant that that people from another office would be simply exporting these tables to my database each month (currently I import the new tables, manually append them...
  13. Re: Appending Access tables prior to a parameterQuery (OFFICE 97 SR2)

    You asked: "Do you have a client application which you built which is the sole entry point". Answer: YES

    You commented: "you could build something into your application which looks for the...
  14. Appending Access tables prior to a parameterQuery (OFFICE 97 SR2)

    Hello again:
    I am doing a parameter query of an Access table that we can call Master. At an unpredictable time during each month, a monthly table, called mmmyyModComp, is deposited in...
  15. Auto Append Monthly Tables to a Master (Office97 sr2)

    Hello again:
    I have a table deposited in this database each month that I want to have automatically appended to a Master
    table in that same database. The monthly tables...
  16. Re: Need guidance autolinking tables (Office 97 SR2 win98)

    Hi Again:
    OK, I set up the Union queries but I do not think that this will be the best answer because it takes too long to run them. Here is what the Union query looks like (each mmmyyANS table is...
  17. Replies
    6
    Views
    672

    Re: Project & Excel (2000)

    Maybe but it is a PIA to have to deal with the "hrs", "days", or "wks" that MSP attaches as suffix to the exported data. Does it do the same thing in exporting to Access?
  18. Replies
    4
    Views
    447

    Re: Linked Access tables (Office 97 SR2)

    Hi Paul:
    Thanks to you and Bill for your quick response. Paul, this is a long story and the only short answer that I can give you is the ols adage "if it ain't broke, then don't fix it". Actually,...
  19. Replies
    4
    Views
    447

    Linked Access tables (Office 97 SR2)

    Hi:
    I need a little advise about linked tables. I have a database that draws its data (via linking) from monthly databases that our system generates. In fact, I recently completed linking for all...
  20. Re: how to use a range Name as an argument by pointing (Office97 SR2)

    Rory:
    Thanks. Can't wait to try this tomorrow. I might even get to work on time for a change. SO the 20 char limit, which sometimes was 19 and then 21 would be explained by the fact that the...
  21. Re: how to use a range Name as an argument by pointing (Office97 SR2)

    Rory:
    I sent you the file via e-mail. The zip version was too large.
    Thanks for taking a look.
    Stephen
  22. Re: how to use a range Name as an argument by pointing (Office97 SR2)

    Rory:
    Please see (Post: 111785).
    Yes, you are correct, =var(indirect(AT3)) will give me the variance of the named range that appears in that cell. BUT, THIS ONLY WORKS, ON OUR SYSTEMS HERE (WITH...
  23. Re: use a range Name as an argument by pointing (Office97 SR2)

    Sammy:
    Please check out WorSheet2 that I inserted into the file you sent to me. Go to the validation cell and choose, in turn, each of the named ranges with multiple B's. You will see, if you do...
  24. Re: use a range Name as an argument by pointing (Office97 SR2)

    Thank you, Sammy. I am not sure how to use offset in the situation where the cell reference is a named range being selected by the user from a Validation List. It seems like...
  25. Re: Number of characters allowed forFunction arguments (Office97 SR2)

    There are no commas. The equation works fine for range names of 19 characters or less and it does not work for range names of 20 characters or more.
    There must be some setting somewhere that...
Results 1 to 25 of 254
Page 1 of 11 1 2 3 4