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 Mike Lewis 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. stevedemo

    Question about ILMerge

    I am new to VB.Net I am using visual studio 2010. I came across this utility ILMerge. It's a utility to combine dll's with your exe file. I think this would be a cool idea however I can't get it to work. I found a utility that has a GUI for this http://ilmergegui.codeplex.com/releases/view/19805...
  2. stevedemo

    Combine two tables with unique values

    Lameid, That works, no errors. I will take a closer look at this tomorrow. Thanks, Steve All I want is the chance to prove money won't make me happy.
  3. stevedemo

    Combine two tables with unique values

    I get this: Comp SumOfTotal_Reqd Location 1A10 526 zr010204 1A10 526 ZR030606 1A10 526 zr030401 1A12 598 zr040601 1A16 245 zr040301 1A4 3544 zr010403 1A4 3544 zr010703 1A6 7608 zr040801 1A6 7608 zr030503 1A6 7608 zr030505 Where I should be getting this Comp SumOfTotal_Reqd Location 1A10 526...
  4. stevedemo

    Combine two tables with unique values

    Here is what I have, it should only produce 42 records but I get 77. SELECT Totals2_ftgcrimp.Comp, Totals2_ftgcrimp.SumOfTotal_Reqd, Zrloc2.Location FROM Totals2_ftgcrimp LEFT JOIN Zrloc2 ON Totals2_ftgcrimp.Comp = Zrloc2.Item_Number; All I want is the chance to prove money won't make me...
  5. stevedemo

    Combine two tables with unique values

    PHV, Good call I see where you are going with this however when I try to add the Min function I get the error that "T1" is not part of the aggergate function. I built a diffrent query to test the min function and it produced the same error, suggestions ? All I want is the chance to prove money...
  6. stevedemo

    Combine two tables with unique values

    I have two tables Table1 & table2. Table1 is a list of part numbers table2 is a list of possible locations. I would like to create a table by combining them with the locations and only the parts from table1. However when I do this I am getting all the possible locations for table2. In excell...
  7. stevedemo

    How to add a on Event to a ActiveX object

    Thanks Remou, That will work when I fire the navigate event with a click however if the user clicks on a hyper link the program will never see this code. The onnavigate event is also missing. Is is possible to modify the code that MS Access uses to interface with the activeX controls ? I...
  8. stevedemo

    How to add a on Event to a ActiveX object

    Is it possible to add an onEvent to a ActiveX object ? The one I am talking about is the webbrowser control. The control lacks a very important feature - the OnDocumentComplete event. Thanks, Steve All I want is the chance to prove money won't make me happy.
  9. stevedemo

    How to register a font with VBA or MS 2007 installer

    Thanks Remou, Looks like that may work, I will test it later. Here is some info to help with WshShell Set WshShell = CreateObject("WScript.Shell") orginal thread: http://www.pcreview.co.uk/forums/thread-947405.php
  10. stevedemo

    How to register a font with VBA or MS 2007 installer

    I have a Access Solution that I have created, a few of the fonts are non standard. Is there a way to register the fonts with VBA ? Or the 2007 Devloper extensions ? Thanks, Steve All I want is the chance to prove money won't make me happy.
  11. stevedemo

    VBA Guru's can you convert this php snippet to VBA ?

    TheAceMan1, I will give that a try and let you know if I was able to make it work. Thanks for the tip. Steve All I want is the chance to prove money won't make me happy.
  12. stevedemo

    VBA Guru's can you convert this php snippet to VBA ?

    I have a routine on one of my websites that grabs a CSV file and parses it, I then extract the info I need. $handle = fopen($csvfilename, "r"); while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); echo $data[1]." ".$num; // so some more stuff } fclose($handle)...
  13. stevedemo

    MS Access 2007 accde / accdr Security Help

    I managed to find an answer - I found a forum where someone had the exact same issue. Nothing working when I generated a ACCDE file. This is what I did to fix it, open the visual basic editor under "debug" select compile. Then from the Access 2007 GUI select the "Make ACCDE" on the ribbon...
  14. stevedemo

    Access Runtime 2007 - Disable macro security

    This kind of renders the production of accde's useless since it disables the functionality of the database. All I want is the chance to prove money won't make me happy.
  15. stevedemo

    MS Access 2007 accde / accdr Security Help

    Ok, 2007 is not bad but it is a different animal. I would like to distribute a database but obviously I want to lock it so it can not be altered. So naturally I would want to use the accde extension. Fine and dandy until you add VB to the project then it shuts off all the macros and VB. I was...
  16. stevedemo

    Access 2007 Button: VBA / Macro

    I guess I should have Googled the topic first: http://blogs.microsoft.nl/bartwe/archive/2007/04/21/11403.aspx It appears the Wizard will only create Macros. Steve All I want is the chance to prove money won't make me happy.
  17. stevedemo

    Access 2007 Button: VBA / Macro

    When I add a button to a form by default Access 2007 creates a embedded macro instead of the VBA code it produced in earlier versions. Is there a way to change this ? Thanks, Steve All I want is the chance to prove money won't make me happy.
  18. stevedemo

    How to get HTML with VBA ?

    Got it !!!! ' Go to Page WebBrowser7.Navigate url:=Text1.Value ' Get HTML Do DoEvents Loop Until Not WebBrowser7.Busy Text3.Value = WebBrowser7.Document.All(1).innerHTML All I want is the chance to prove money won't make me happy.
  19. stevedemo

    How to get HTML with VBA ?

    Hello Remou, Yes I have, I have even hard coded a different URL. I suspect for the most part the code is working but I am returning a NULL value here: doc.All(0).innerHTML that part has me puzzled. The "webbrowser" was never my strong point in any language. I was hoping there was a different...
  20. stevedemo

    How to get HTML with VBA ?

    I was able to convert some VB. However the only page I can get it to load is google nothing else will load. Suggestions ? Private Sub Command1_Click() Dim doc As Object WebBrowser7.Navigate url:=Text1.Value Do DoEvents Loop Until Not WebBrowser7.Busy Set doc =...

Part and Inventory Search

Back
Top