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!

Register Log in
  • Congratulations Rhinorhino 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: *

  1. JimTheProgrammer

    Word tables to Excel

    Is there a way to copy a table from Word (2k) and past it into Excel looking just as it did in Word?
  2. JimTheProgrammer

    Index or Primary key cannot contain Null value

    I have a datasheet subform on my main form that gets this nasty message if you enter data into a field, delete it (or backspace it out) and then try to click on the main form. I know the causes and I think I know how to trap it, but I don't know how to tell it to give up altogether and let me...
  3. JimTheProgrammer

    input list

    I know I'm overlooking something simple, but what contol do I use so the user can input a list of values? Namely, to input a list of employee numbers on a form for use in a query. I know how to use text boxes, and list boxes (to choose from a predefined set of data) but not an empty list box.
  4. JimTheProgrammer

    database prevented from opening

    HELP! I'm getting the following error when trying to run a query. "the database has been placed in a state by user "Admin" on machine "ABC" that prevents it from being opened or locked". I've rebooted all the machines (Win98 peer-to-peer) and read the MS KB...
  5. JimTheProgrammer

    CLng text to long number compare problem

    This query fails NOT MATTER WHAT I put in the "Where" clause. ITEM_NO and Short # are both 15 position text fields. This gives me a "data type mismatch in criteria expression" error. If I put a "is null" I get the same thing. I have tried >0. Same thing. SELECT...
  6. JimTheProgrammer

    data labels in Graphs

    I have succesfully made a report that contains a pie chart (one page per customer showing percent sales). The ONLY problem is on some charts the data labels for the pie slice overlaps other data lables and you can't read them. I've tried EVERYTING I can think of but some still overlap. HELP :-)

Part and Inventory Search

Back
Top