Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Re: Excel Macros in Hyperion Essbase??? (excel 2002 sp-2)

    Ok Shades so how do I fix the problem?!?!?
  2. Replies
    4
    Views
    349

    Re: Transposing Data (Excel 2000)

    Your the greatest!! <img src=/S/hugs.gif border=0 alt=hugs width=41 height=25>

    Thanks!! <img src=/S/trophy.gif border=0 alt=trophy width=15 height=15>
  3. Replies
    4
    Views
    349

    Transposing Data (Excel 2000)

    I have an excel spreadsheet that looks like this,
    Empno-----4Q2002-----1Q2003---2Q2003---3Q2003
    34567------40,000------2300-------40,000----16000
    67352------30,000------2400-------30,000-----27872...
  4. Replies
    2
    Views
    518

    Re: Paste as Value (Excel 2000)

    Thanks a million!!! It's worked perfectly.

    <img src=/S/bravo.gif border=0 alt=bravo width=16 height=30>
  5. Replies
    2
    Views
    518

    Paste as Value (Excel 2000)

    I have formulas scattered throughout a large excel spreadsheet. What I would like to do is be able to select only those formulas that I want to change as a value. If I select the cells, copy and...
  6. Replies
    2
    Views
    265

    Finding rows on a change (Access 2000)

    Need Help!

    I have a Payroll Table that is 20000 rows. I need to find the rows that are NOT duplicates. However, the tricky part is that I have the same payroll code for multiple rows but...
  7. Re: Scrolling through unbound fields (Access 2000)

    Thank You!! Hans

    It was exactly what I needed.

    <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
  8. Re: Scrolling through unbound fields (Access 2000)

    I apologize as well. My mind is running full speed.

    I have a form which displays data from a table. What I would like to do is give the user the opportunity to select a record from the drop down...
  9. Re: Scrolling through unbound fields (Access 2000)

    How do I create a drop down list users can select from? and if I use the navigation button, the drop down list should scroll with the rest of the data fields.

    Any ideas.
  10. Re: Scrolling through unbound fields (Access 2000)

    yes, it's the navigation buttons. When I use them to go forward to next record all the fields navigate except the unbound combo box field. How do I fix this?
  11. Scrolling through unbound fields (Access 2000)

    Help <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>

    My unbound combo box field on a form won't scroll along with the data when I click on the right arrow or left arrow. How...
  12. Re: Refreshing an excel sheet connected to Access (Excel 2000)

    Thank you David! Excellent ideas <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    I'll give it a try.
  13. Re: Refreshing an excel sheet connected to Access

    Thank you for your input. I will certainly give it a try.
  14. Re: Refreshing an excel sheet connected to Access (Excel 2000)

    I have in the past created MS Queries by connecting via ODBC to SQL. But, I find myself creating a query in Access, then having to create the query again in MS Query. I would prefer to create the...
  15. Refreshing an excel sheet connected to Access (Excel 2000)

    Okay, so I may be a little out of my league...but, in any case here it goes.
    I have an Access database connected via ODBC connection to a SQL database. I created an export of one of the querys but...
  16. Replies
    1
    Views
    306

    Word to Excel (Word 2000)

    How do I convert a Word document into Excel?

    Any info would be helpful.

    Thanks <img src=/S/bananas.gif border=0 alt=bananas width=33 height=35>
  17. Replies
    2
    Views
    238

    Re: Word Merge (Word 2000)

    Thanks! It worked perfectly <img src=/S/cool.gif border=0 alt=cool width=15 height=15>
  18. Replies
    2
    Views
    238

    Word Merge (Word 2000)

    Does anyone know how to merge two word documents together?

    Thank you in advance!
  19. Replies
    3
    Views
    255

    Re: Finding empty fields (Access 200)

    Thank you for the reply...I do have a question.

    When I try to run the query it gives me a message as follows:
    "The sum or average aggregate operation cannot take a char type as an argument."
    ...
  20. Replies
    3
    Views
    255

    Finding empty fields (Access 200)

    Hello fellow loungers,

    I have a huge data cleanup project I need your expertise with....

    I need to find fields that are not being used for each group of codes. For example,
    Code 60- y2K bonus...
  21. Replies
    2
    Views
    370

    Re: Macros in Excel (Excel 2000)

    Wow, that is absolutely fascinating. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>

    It worked perfectly.
    Thanks a million <img src=/S/salute.gif border=0 alt=salute...
  22. Replies
    2
    Views
    370

    Macros in Excel (Excel 2000)

    Help!

    Here it goes...

    I've created a macro that finds my dups but what I need in addition to that is the following:

    IF Employee number = the Next employee number THEN
    copy...
  23. Replies
    5
    Views
    1,021

    Re: Headcount Report (Access 2000)

    Thanks Hans and Wendall. It worked great!!
  24. Replies
    5
    Views
    1,021

    Re: Headcount Report (Access 2000)

    The data I am given is a listing of ONLY active employees for the current month. So unfortunately, I have to go back to last month's list and check who's missing on this month's list. Then on a...
  25. Replies
    5
    Views
    1,021

    Headcount Report (Access 2000)

    I'll try to make this as simple as possible...so here goes...

    Every month I need to generate a headcount report. The data is sent to me via excel and I load it in using access. The table has...
Results 1 to 25 of 69
Page 1 of 3 1 2 3