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 Westi 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.

    I am creating the framework for the future. For now the reports are only displayed in Access, but in the near future, 1-2 years, the reports and graphs will be exported and kept in excel or in word format. PHV thanks for your comment. If I cannot figure it out by the end of the week I will...
  2. 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...
  3. student4life

    Count the number of words (commas) in a cell

    thanks Golom. it works great.
  4. 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
  5. student4life

    Invalid use of Null

    PHV, You are a genius. ;) Thank you
  6. 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!
  7. student4life

    Force close the DB

    thanks Ed
  8. 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.
  9. student4life

    Split fields

    Golom i got it figured out. it took me some time but i got thanks for the help....
  10. student4life

    Split fields

    Golom thanks for the info. i was trying to duplicate your post from FAQ701-1002047 and i am getting the same compile error at line Mid$(";" & I1.Product & ";", S1.num + 1 , S2.num - S1.num - 1) AS [SubProduct] any ideas ?
  11. student4life

    Split fields

    I’m new to this and will need a little more guidance from the experts, What I am trying to do is create a Private Subroutine that will be activated via a button and the generated rows/columns will be appended to the existing table. So this is what I was thinking. 1. A user imports a table. 2...
  12. 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