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: Finedean
  • Order by date
  1. Finedean

    Linking a form to a another form using a command button?

    Hi all, I have a form with a list of contact names. I would like to add a button next to each contact name to open another form that contains Only details of the that contact. Name Button John Lerch Button Ali...
  2. Finedean

    Bypass message?

    thank you.
  3. Finedean

    Bypass message?

    Hi all, When I open any of my databases I get the following message: Opening C:\FileName This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or canceal the operation? Canceal Open Does anyone know how to paypass this...
  4. Finedean

    help desk

    Thank you soooo much.
  5. Finedean

    help desk

    Hi, is there any more files extension that I need to look for besides: jpg and wma? Thanks
  6. Finedean

    help desk

    thank you linney. I will look at the site you recommended.
  7. Finedean

    help desk

    Hi everyone, My boss wants me to go around the office and check our staff pc's for programs/software that should not be there like (firewalls, music file etc..). Anyone have an idea what programs/softwares to look for that my harm the computers? I have no idea where to start. Thanks in advance
  8. Finedean

    Export Ramdom Excel Data

    Man, you're good. It worked like a charm.
  9. Finedean

    Export Ramdom Excel Data

    skip, I think I know why it's pulling the 0. In the excel sheet there is more than one computed fee cell. one in F40 and it equal 0 and the other one is the one I need to pull wich is F57 and it equal 2710.06 I think this is why we're getting the 0.
  10. Finedean

    Export Ramdom Excel Data

    I really appreciate your help and patience. this what I get now: PlanID Partic Compu Computed 1231 130 0 1445365.99 2710.06 169 27 0 2388263.51...
  11. Finedean

    Export Ramdom Excel Data

    Hi Skip, It did not work. Before you add the new line this is what got: PlanID Participant count Computed asset Computed fee 1231 130 1445365.99 169 27 2388263.51 AAM 27 4067256.32 New Code: PlanID Participant count Computed asset...
  12. Finedean

    Export Ramdom Excel Data

    F57 Thanks
  13. Finedean

    Export Ramdom Excel Data

    I forgot to mention that computed fee is in the excel sheet more than once. The one I am looking for is: Computed fee: $2,710.06 Thanks again Dean
  14. Finedean

    Export Ramdom Excel Data

    Amazing. You're genuis. My friend is a programmer but He couldn't do it. thank you so much. I need to ask one more thing. I need to add another field called computed field. I played with the code little bit but it did not do it. The field Computed Field heading was added to the sheet but...
  15. Finedean

    Export Ramdom Excel Data

    When you type A4 in the formula you get: Plan ID: 1231 Artemide, Inc. 401(k) Profit Sharing Plan G40 returns 130 A54 Returns Computed Assets F54 Returns $1,445,365.99 A40 returns Participant count
  16. Finedean

    Export Ramdom Excel Data

    when you click A4 Plan ID: 1231 XXXX, Inc. 401(k) Profit Sharing Plan is in A4:L4. 130 is in G40:H40 I do not know how it happened.
  17. Finedean

    Export Ramdom Excel Data

    I did not think it was going to be easy. I have never done anything like this before that's why I was asking if anyone knows of a program to help. When I put G To H I meant G:H, or A to L it means A:L Key Identifier will be Plan ID Plan ID is in Cell A4:L4 Participant count is in A40:C40...
  18. Finedean

    Export Ramdom Excel Data

    Thanks for your quick reply Plan Id is in Column A to L Participant count is in Column A to C The amount (130,..) is in Column G to H Computed Assets is in A to D The amount ($1,445,365.99) is in F to H I am not sure what you mean by these questions: What is the key identifier? How will you...
  19. Finedean

    Export Ramdom Excel Data

    I have an excel sheet that contains random data. this is an example of the excel sheet: Plan ID: 1231 XXXX, Inc. 401(k) Profit Sharing Plan Report period: 4/01/2006 to 6/30/2006 Activity fees are paid from plan assets: Distribution fee amount: $0.00 Count: 1 Amount due: $0.00...
  20. Finedean

    Export Ramdom Excel Data

    Hi Everyone, Does anyone know a program to help me export data from excel to Microsoft Access? The data in excel is not in row/Column format. Thanks in advance dean

Part and Inventory Search

Back
Top