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

    Managing, modifying "kits" for recurring orders

    What is a manageable way to create modifiable item “kit” orders. For example: The following is the item id field contents ItemId: AF14 20 2 APR201 AZT7 BEC3380 BECAF44XR BECF0 BG108121 BGP04080 BLN1/2 24 BLN1 8 BRP21/2 20 CARCF1103F In this example, lets say we have established that there...
  2. kmarr

    Why rename tables with P., X., etc.

    I am new to this. The query below is Golom's response to one of my earlier questions (It produced the desired result by the way) Thanks! In the following SQL query, there is a P. and an M. preceeding the fields in the select command and later in the From command the table names are preceeded...
  3. kmarr

    Select min cost item from many with same item number

    I have two tables Tbl_MarItems (Items that are used in my business) Auto_MarItemID (primary key) Str_AltCode Str_ProdDesc Str_UOM Tbl_VendorPrice (prices from suppliers for items that are used in my business) Str_VendorID Num_MarItemID (many side of primary key relationship)...
  4. kmarr

    What is the best way to learn SQL?

    I know, it's a broad question. Locally, the community college and tek.school don't offer classes in this. I am reading what I can find and learning VERY slowly. Eventually I will make it but are there any tips on how to accelerate learning? Thanks a lot! Ken
  5. kmarr

    Dim screen on laptop

    My computer tek recently "rebuilt" my harddrive - unconditional delete or format (I don't remember exactly) and then reloaded software. The screen brightness is just a bit low - even on the highest setting on the laptop adjustment buttons. Is there any way to brighten it up? Thanks, Ken
  6. kmarr

    How to tell how long a file was open

    I have an employee who is storing some personal msword files on our office computer system. I don't have a problem with that as long as she is using this as a sort of backup and not actually working on these during company time. Is there a way to tell how long these files were open or what...
  7. kmarr

    Query selects low value item

    Two tables: Table one (Tbl_Items) has following fields: Auto_ItemId (the one side of the one to many relation) Str_Description Table Two has (Tbl_VendorPrice) following fields: Num_ItemId (the many side of the 1 to many relation) Str_VendorPartNumber Cur_VendorPrice...

Part and Inventory Search

Back
Top