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 SkipVought 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: DougP
  • Order by date
  1. DougP

    Using vb.net 2017 reading excel file 2016, into grid DataGridView

    I am unable to install "Microsoft.ACE.OLEDB.12.0" I have Office 365 which is downloaded. Anyway I found the following code which read the rows into an array. then I thought I would load that into the grid. The issue is the dates in the array are numbers such as 43810 = 12/11/2109 and 43782 =...
  2. DougP

    Neded help with join two tables count return too many

    I went a different route, case closed DougP
  3. DougP

    Neded help with join two tables count return too many

    FYI: this is the result of the above query UPCode StoreID UserName DateAdded RecordID 1230000033 5 llh123 2019-01-10 05:09:04.057 2113 DougP
  4. DougP

    Neded help with join two tables count return too many

    I have two tables, one stores a record for each item each time it is used. The second holds the main item list and has a record for each user. So an item could be in the table multiple times. I see now this needs to better normalized. But is there a way to make the following query return one...
  5. DougP

    How can I locate windows 7 dektop icons?

    OK I found code in C# to add the icons to a Listview along with their X-Y cords. So I guess I'll pursue it in C#. >> link here https://social.msdn.microsoft.com/Forums/windows/en-US/d7df8a4d-fc0f-4b62-80c9-7768756456e6/how-can-i-get-desktops-icons-information-?forum=winforms DougP
  6. DougP

    How can I locate windows 7 dektop icons?

    Ok I am doing this but I still am unable to find their physical location on the screen. I have moved one into a new folder to test. But when I double click on the folder it opens in Windows Explorer which is not ideal. Is there a way to open a desktop folder so it shows the icons and not a list...
  7. DougP

    How can I locate windows 7 dektop icons?

    I have a lot of desktop icons and I am using 3 monitors. The other day the video driver updated throwing all my icons on the main screen/Monitor. The screen is packed and I think some are not displaying (are off the screen entirely, since the entire screen is full of icons; (I know I need house...
  8. DougP

    Excel 2016 in Windows 7; missing formula quick button on left side of formaula bar

    Ok well it was a fluke, I called Microsoft and they said open a new Excel. When I did that both bars showed correctly. When I went back to my workbook it too was showing correctly. WTF Go figure case solved. DougP
  9. DougP

    Excel 2016 in Windows 7; missing formula quick button on left side of formaula bar

    I was using Excel 2016 90day trial for free. In the formula bar at the top of the grid was a smaller box showing a ƒx. It was on the left side of the formula bar so you could click it and add a formula quickly. Also the Named Range box is not showing either. However when I paid for the Office...
  10. DougP

    SQL server set variable equal to result from concatenated string

    I want to verify a row is deleted. I am passing both the table name and the value in question to my stored procedure. It deletes said items and I want something returned back. I created @ItemFound and want to let it equal to the count. But it is not getting set since its inside of the SQL...
  11. DougP

    Making slideshow using W3Schools example gives error

    I made a blank HTML page and copied and pasted the code from w3Schools and it works just fine. So for some reason it will not work when added into an .aspx page. http://www.doogiestoyshop.com/testslideshow.html <test HTML page DougP
  12. DougP

    Making slideshow using W3Schools example gives error

    There is a link at the top of the page to show the W3Schools code I copied? Sorry Brain of a 60 year geezer! LOL DougP
  13. DougP

    Making slideshow using W3Schools example gives error

    Ok, any ideas how to fix it? it work on the W3C site just as is, what is different about that? I copied the code from the "try this" page since the code form the front did not work however both give the same error? DougP
  14. DougP

    Making slideshow using W3Schools example gives error

    this is the example on W3Schools: https://www.w3schools.com/howto/tryit.asp?filename=tryhow_js_slideshow Here is my WEB page on my side which does not work correctly: http://www.doogiestoyshop.com/Cool%20Crafts.aspx this is the error I get; which is highlighted in my code near the bottom in...
  15. DougP

    Newbie question about making functions to pass image names for viewing larger

    I'm sorry for the confusion, about my explanation or lack knowing of what I am doing. But the original code at the top has exactly what I want to do, if you just copy it and paste it into a WEB you will see how it works. that code was on a web site and it only works for one image. I have dozens...
  16. DougP

    Newbie question about making functions to pass image names for viewing larger

    Ok, I'm not following your example Vacunita. I think we got off track, the code at the beginning is what I need help with. I don't know enough about JavaScript to take your examples and make them into anything usable for me. Is there anyway to pass parameters to a style? I got the code for one...
  17. DougP

    Newbie question about making functions to pass image names for viewing larger

    Ok that much I know, but I don't know how to make the functions. After that then how do I call them? I want to have a table full of images and when I click on one it popups the window with the "X" so you can close. Or which part do I put into the function? here are my 3 images, each id has to...
  18. DougP

    Newbie question about making functions to pass image names for viewing larger

    Newbie question about making functions to pass styles parameters... I found this on another site which works great but I would like have functions so that I can call the same code over an over, instead of duplicating it many times. The top part is a table with 3 images. But the original code is...
  19. DougP

    Help with SQL using CASE in Where statement looking for specific text

    Ok here is my final solution I made a stored Procedure and checking @name for NULL, which works great, It returns just groups or it also returns groups and one name as well, or jus tone name and now group so Hoorah. or Thanks all. Consider this one solved :) Create Procedure...
  20. DougP

    Help with SQL using CASE in Where statement looking for specific text

    I found an option which is to make a Stored Procedure and check the value of @Name in there and make it NULL. I don't know how to make it NULL in VB.NET since there is no .NET code driving anything its all using Connected items. There is a default value but putting the word NULL in there it...

Part and Inventory Search

Back
Top