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: *

  1. student4life

    Import an image into a form or a report, from clipboard.

    Do you guys know of a code that will import (paste) a picture from a clipboard.? Many thanks in advance for your help. And this is what I a trying to do: I have a query output that I want to graph, and exporting it into excel and just capturing the chart with...
  2. student4life

    Count the number of words (commas) in a cell

    Hi, How can I write an SQL statement to count commas in a cell in Excel i can do this with =IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1,",",""))) any ideas on how i can do this in Access, I was trying to create a select query, without luck. thanks in advance for the help
  3. student4life

    Invalid use of Null

    Hi, I have Access 2003, and XP SP2. I have a problem executing the query. When I try, I receive an error that says:Invalid use of Null. Any ideas? BS_Diam: String(CInt([rva_BS_Data]![Diam]*25),ChrW(9644)) Any help would be appreciated. Thanks!
  4. student4life

    Force close the DB

    Do you guys know of a code that will force close the application with or without saving? I have about 15 users and the DB stays open for hours. If I want to do a fix I will have to wait until the users close the application. Any ideas? Many thanks in advance for your help.
  5. student4life

    Split fields

    How do you parse the data from: ID POS WB 6740 41 BC W12345|W12344|W11111|W22222,, 6741 43 W99999|W88898,, to: ID POS WB 6740 41 BC W12345 6740 41 BC W12344 6740 41 BC W11111 6740 41 BC W22222 6741 43 W99999 6741 43 W88898 Values in WB column may very from 1 to 30-40 and every...

Part and Inventory Search

Back
Top