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 bkrike 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: terpster
  • Content: Threads
  • Order by date
  1. terpster

    Ordering with blanks

    I have a report where I have 'due dates' for projects, and I want to order by date asc. Some of the rows do not have a date provided. I want to have the report show all the itetms with dates first, then the ones with no date at the end. Anyone have an idea of how to make this happen. Many...
  2. terpster

    form calculations

    I'm very new to java script. But I figure I have to learn somehow. What I'm trying to do is take the inputed values from a form and print out the calcuated value. I would guess it's something similar to an order form. eg of what I'm trying to do? <FORM> <P> <table> <tr><td...
  3. terpster

    error when trying to open db..

    We have a database that sits on a shared directory on our server. As of last night we keep getting the following error message. Could not use H:\projects\projects.mdb file already in use. Noone is in the database. Please help! :) Thanks from all of us here trying to use the db! :)
  4. terpster

    Checking for duplicate entries

    I'm trying to assign a manager to an employee using combo boxes in a form. I have an emp_mgr table that contains the empID and mgrID. I'd like to show an error message to anyone who tries to duplicate the emp/mgr relationship if it already exists in the database. How could I do this. Please be...
  5. terpster

    using ssh...

    Can a windows admin snoop my ssh session?
  6. terpster

    checkboxes in reports

    Hi! I'm trying to have check boxes 'checked' or unchecked based off of values in one of my tables. I have 4 check boxes: Yes No Pending Information not in file The values in the table: 1=Yes 2=No 3=Pending 4=Information not in file How do I get the apprpriate box checked for each customer...
  7. terpster

    exporting from sql server to Access

    When I export from sql server 7.0 into Access 2000 I lose all of my primary keys and relationships? Is there a way to keep my primary keys along with the relationships so I don't have to recreate them each time? Thanks!
  8. terpster

    reports

    Does anyone know why the margin settings and page layout changes every once in a while for my access reports? How can I get the settings to stay put? Thanks! Lori
  9. terpster

    parsing 1 column into 2

    I have a column that contains both last name and first name seperated by a comma. I was wondering if there was an 'easy' way to parse that column to put it into two seperate columns. thanks!
  10. terpster

    Multi columns (like newspaper) in reports

    Anyone know if you can make your columns 'wrap' like how a newspaper is laid out? I have a long list of names that I'd rather have all one one page. :) Thanks!
  11. terpster

    Rounding in Access

    How would you go about rounding to the thousands place in access? eg. 3600 -> 4000. Thanks for your suggestions!
  12. terpster

    Capitalize the first letter in a string

    Was wondering if there was anything in access that would allow me to capitalize the first letter in a string? Something similar to initcap in oracle? Many thanks!
  13. terpster

    Entering Data in to Tables

    Was wondering if there was a feature in MS Sql that was similar to the datasheet view in Access? thanks :)
  14. terpster

    Update from a file

    Can you update columns from a file stored on your hd?
  15. terpster

    Intersect query in access?

    I've used the intersect function in Oracle before and was wondering if there was something in Access to get similar results? [peace]

Part and Inventory Search

Back
Top