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

    Can you put a calculated field into a table?

    I need to put two calculated fields into a table. Is this possible? In my table I have a column of current hours, a second column of earned hours. My third column needs to have a calculated field that adds colums one and column 2 together(current hours+earned hrs) to give me the total overall...
  2. nomi1

    IIF STATEMENT WON'T WORK

    I am trying to insert an "IIF" statment into a field and each time I do it gives me the messaage that an identifier is needed. My IIF statement is as follows: =IIF([MASTER.TOTAL HRS EARNED]>90,"SENIOR",IIF([MASTER.TOTAL HRS EARNED]>60,"JUNIOR",IIF([MASTER.TOTAL HRS...
  3. nomi1

    Navigating Between Form Pages in Paradox

    I have created a paradox form that has 5 pages. I would like to insert buttons on each page so that I can easily go to the correct page on demand. Can anyone help me?
  4. nomi1

    Lewy - thanks for merge info but I need a little more help!

    Thank you so much for your help. I tried using the Experts Merge but got the following error message: "an alias required to runthe expert could not be created. The Paradox error message is: "An error was triggered in the "Add Alias" method on an object of session type". Can you help me out...
  5. nomi1

    Can you access Paradox databases from Microsoft word?

    Our department has been using paradox for over 15 years and they have never directly accessed the database for mail merges in word. They usually do a query in Paradox, export it over to excel and then set up merge in word. Seems like an awful lot of work to me. Is there anyway to open word...
  6. nomi1

    Export Paradox Report to Excel

    I have a report that I run in Paradox that I need to be able to manipulate/make changes to in Excel. I was wondering if I could export the report into excel.
  7. nomi1

    Export Paradox Report to Excel

    How can I export a paradox report into Excel?
  8. nomi1

    TONY - COULD YOU HELP ONE MORE TIME?

    THANK YOU SO MUCH FOR YOUR RESPONSE. UNFORTUNATELY I AM PARTICULARLY BRAIN DEAD TODAY AND CAN'T THINK BEYOUND EXCEL. WHERE WOULD I MAKE THE CHANGE IN MY FORMULA BELOW? IF([POST WORK QUERY.Earned Hrs]>90,"SENIOR",IF([POST WORK QUERY.Earned Hrs]>60,"JUNIOR",IF( [POST WORK QUERY.Earned...
  9. nomi1

    CAN'T GET MY "IF" STATEMENT TO WORK---HELP

    TONY, THANK YOU FOR YOU REPLY, BUT TODAY I AM UNUSUALLY BRAIN CHALLENGED! COULD YOU PLEASE SHOW ME WHAT YOU MEAN? THIS IS MY STATEMENT BELOW - WHERE WOULD I MAKE THE CHANGE? IF([POST WORK QUERY.Earned Hrs]>90,"SENIOR",IF([POST WORK QUERY.Earned Hrs]>60,"JUNIOR",IF( [POST WORK QUERY.Earned...
  10. nomi1

    CAN'T GET MY "IF" STATEMENT TO WORK---HELP

    WHENEVER I ENTER THE FOLLOWING IF STATEMENT INTO MY CALCULATED FIELD IT COMES BACK AND SAY I NEED AN IDENTIFIEER. WHAT DOES THAT MEAN? =IF([POST WORK QUERY.Earned Hrs]>90,"SENIOR",IF([POST WORK QUERY.Earned Hrs]>60,"JUNIOR",IF( [POST WORK QUERY.Earned Hrs]>30,"SOPHOMORE",IF( [POST WORK...
  11. nomi1

    HELP-I have designed a one page report but 2 pages print

    What am I doing wrong? I have designed a report that is set up like this.... page all records report fields are then listed here all records page report this is a one page report but it keeps printing an extra blank page. What am I doing wroing?
  12. nomi1

    How do you set an automatic sort in a table?

    I have an existing table and I need to set it to automaticaly sort after every entry by one field. How do I do this?
  13. nomi1

    Is there a way to set "Advance Pattern Match" as the default

    Is there a way to set "Advance Pattern Match" as the default for locating values rather than the @ and... that is the default now?
  14. nomi1

    Corrupt table/index header - can this be fixed?

    I am trying to open a Paradox database and it will not allow me to open the database. The error message is: UNABLE TO OPEN TABLE CORRUPT TABLE/INDEX HEADER Is there any way possible to fix this? Thanks, Naomi
  15. nomi1

    Deleting Fields From Tables

    Help! Could someone please tell me how to delete fields/columns out of existing tables? I find myself, after 6 years and one job change back to using Paradox and can't remember how to do this simple task! I know how to delete fields from reports, forms,etc but can't for the life of me figure...
  16. nomi1

    Beginning with Paradox

    Can anyone tell me how to go into an exiting table and delete fields/columns? I just recently changed jobs and find myself, after 6 years, using Paradox again, and I can't remember how to do this simple task!

Part and Inventory Search

Back
Top