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 Mike Lewis 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: StanKorn
  • Order by date
  1. StanKorn

    convert mainframe data to a number in Excel

    Thanks Frederico. Stan-+ Remember - only dead fish go with the flow.
  2. StanKorn

    convert mainframe data to a number in Excel

    The text file is this: 073105AI0705411119000041401018070000 CY078A0000007288D 00355180700 073105AI0705411130020011401018070000 CY078A0000007288M 00355180700 073105AI0705411130020021401018070000 CY078A0000007288D 00355180700...
  3. StanKorn

    convert mainframe data to a number in Excel

    I believe it is 0000007288D = 72.88 but can't telln if it is Debit or credit. tia,S Remember - only dead fish go with the flow.
  4. StanKorn

    convert mainframe data to a number in Excel

    I need to convert the following data into a number. It is from a mainframe using a standard TSO app. The data represents a $ amount with 2 decimals but comes thrugh as the following: 0000007288D 0000007288M 0000007288D 0000024553{ If anyone can advise I would be grateful TIA, Stan Remember -...
  5. StanKorn

    SQL Query and Formula Fields

    Create a formula that converts a date out of your internal layout into a traditional mm/dd/yyyy format. set up a parameter using input based on the formula you just created and then write an if/then statement to generate your report parameters using standard date formats. It takes a few steps...
  6. StanKorn

    Outlook 2003 stops responding

    I have the above referenced app and it does a strange thing. I can open the app and get and send mail but it will not close propperly and I must reboot to get it to clear from memory. Ctl-Alt-Del does not show the app running but it appears in my sys tray. I am using XP Pro SP2 in a home office...
  7. StanKorn

    power up problem

    Hi: I tried to isolate the components and it turned out to be the DDR ram. Thank you all for your help with this :), stan Remember - only dead fish go with the flow.
  8. StanKorn

    power up problem

    ouch Hadn't thought of that. Do you think that the cpu and other components may have also suffered. I need to let the client know and see what she wants me to do. thanks for your help with this. stan Remember - only dead fish go with the flow.
  9. StanKorn

    power up problem

    It was blown Remember - only dead fish go with the flow.
  10. StanKorn

    power up problem

    Hi; I found the MoBo info I was looking for. One additional piece of info - when I power up I get a very short beep just b4 power shuts off - can anyone tell me the significance of this? Also the time frame I am speaking os is less than three seconds. Thanx, s Remember - only dead fish go with...
  11. StanKorn

    power up problem

    Yes = all is set up the way I received it from the client. I am not sure that it was correctly set up when they gave it to me and since I had to replace Power supply ... well. Is there anywhere to get a digram of the MoBo = it is a P4G533-LA and I can't seem to find the details for it. I believe...
  12. StanKorn

    power up problem

    I just replaced a power supply on a Compaq S5200 computer (350W that is compatible with the unit I replaced) and now when I plug the PC in and try to turn it on I get a power active indication (lights are on and CPU fan is running) and then the power just goes off. Anybody have any ideas on the...
  13. StanKorn

    date problem in excel 2003

    Thanks, I'll try it tonight and let you know. s Remember - only dead fish go with the flow.
  14. StanKorn

    date problem in excel 2003

    HI, I am trying to process on dates from a VFP 7 data file that we used to use to compare with the new SQL platform we are currently moving into. My problem is the date field from VFP is coming into Excel as a text field yyyymmdd and I can't seem to reformat it. Can anyone help me with this...
  15. StanKorn

    date conversion

    got it thanks much Remember - only dead fish go with the flow.
  16. StanKorn

    date conversion

    When I use the TOTEXT format I get 02DDYY as a result. When I use the VAL format I get 2.00 as a result. THe original value when I browse the data is 02/06/2004 12:00. When I format thru CR it returns 02 06 04 as a result. The SQL table setup indicates a datetime type with 8 chr. Can this...
  17. StanKorn

    date conversion

    Sorry I forgot to tell you I am using SQL 2K and CR 8.5 for this task. Remember - only dead fish go with the flow.
  18. StanKorn

    date conversion

    Hi, I need to convert a date from an SQL table datetime to an ascii numeric MMDDYY field. When I run the query I reformat the date to read as MMDDYY by removing the separators and assigning the correct output form. My problem is I get a result that catches the space where the separator would be...
  19. StanKorn

    remot connect to desktop in office

    I am trying to connect to my PC in the officethru remote access. Office server is W2K3 and office PC is on XP. I have a port address to search but when I try to connect using IE6 I get a syntax error. My firewall is programmed to allow me to pass thru it but to no avail. I am running Win98SE at...
  20. StanKorn

    what is this?

    Is there a way to determine what the user ID is for these requests? Remember - only dead fish go with the flow.

Part and Inventory Search

Back
Top