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

    SQL Statement (subquery) problems

    I am trying to correct a statement where two tables do not have any unique information ... BIQUERY.TBLNEWOEE OEE and BIQUERY.TBLDTIME DT. I am trying to use a second subquery to alleviate the problem but I am not able to do so. What is the best way to segreate the BIQUERY.TBLDTIME DT in a...
  2. Bufsabres

    Select statement-making two columns out of one

    I am trying to create two new rows in a report with information gathered from one. Production Quantity-"ProdQty" and Scrap Quantity-"ScrpQty" from one column "production". In the Where clause I specify criteria from another column "WH" as follows 'PQ' OR 'PW' OR 'SP' OR 'S1'...'S7'. How can I...
  3. Bufsabres

    Select statement-making two columns out of one

    I am trying to fill in two rows in a report with information gathered from one. Production Quantity and Scrap Quantity from one column "production". In the Where clause I specify criteria from another column "WH" as follows 'PQ' OR 'PW' OR 'SP' OR 'S1'...'S7'. How can I make only the 'PQ' AND...
  4. Bufsabres

    Pointer or cursor does not show hand over hyperlink

    I would like to know how to change the properties of a hyperlink. Currently the hyperlink does not show the hand to indicate there is a hyperlink under the cursor. How do I change the hyperlink to show the hand?
  5. Bufsabres

    Error-Locked table

    The error is The database engine could not lock table 'ProdSum4' because it is already in use by another person or process. I get an action failed on my last query before my report when I use my command button to run my macro. However when I just run the macro, it works fine. Why do I get this...
  6. Bufsabres

    Error-Locked table

    The error is The database engine could not lock table 'ProdSum4' because it is already in use by another person or process. I get an action failed on my last query before my report when I use my command button to run my macro. However when I just run the macro, it works fine. Why do I get this...
  7. Bufsabres

    Summarizing report-would like one line per job#

    I am creating a one page weekly Production Summary Report with job# down the left and the days of the week broken down by three shifts across the top. I am quering the information into text boxes using the "IIf" function. I would like to have only one line per job on my report but end...

Part and Inventory Search

Back
Top