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...
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...
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...
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...
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...
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.
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
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.
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.
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)...
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...
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.
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...
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.
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.
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.
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.