Hi folks ! So today's problem is getting me mad because that should be easy and i can not find the answer : How to declare a public array in VBA ? I'm using an array with the letters A, B, C,... because i'm working with Excel cells, and i don't want to declare it in every function i create, right ? I've tried to look on the web first an...
Hello guys, How can I write a sql query that takes information from a database, and then put in the text in a label? I'm not really sure how to do this so please give me a good explanation! :) Thanks, Kevin ...
I have XML data like this: <search ver="3.0"> <loc>Birmingham, AL</loc> <loc>Gulf Shores, AL</loc> <loc>Alabama, NY</loc> <loc>Abbeville, AL</loc> <loc>Abernant, AL</loc> </search> I would like to return the name of the places. How may I extract this data using Visual Basic? ...
How can I get the color of a pixel at the location of the cursor? I know how to get the mouses position using MousePosition but I can not figure out how to get the pixel color at that location. ...
abstract class can inherits by other class , and force people to override the abstract function, abstract property etc.. interface also can implements by other class, also force people to implements the function, property,indexers etc.. the only different i found is visual studio is smart to auto generate the nessesary member of this i...
Good morning all! Myself and a co-worker are tasked with a system-wide scripting solution but neither of us are .NET programmers so we need your help. We have a GUI that displays a radio selection box (3 options) that are the three sites where our hospitals are. We need to dropdown located on the form to fill with only the locations bas...
I am trying to create a setup for SourceForge PDFCreator using Inno Setup and getting following error in Setuplog.txt: Printerdriver-Directory (Environment: Windows 4.0): Result: Success = C:\WINDOWS\System32\spool\DRIVERS\WIN40 Printerdriver-Directory (Environment: Windows NT x86): Result: Success = C:\WINDOWS\System32\spool\DRIVERS...
I have a need to create a wrapper for a DLL, loading and unloading it as needed (for those interested in the background of this question, see http://stackoverflow.com/questions/1662075/how-to-work-around-memory-leaking-3rd-party-dll-no-source-code-accessed-by-tomc) . I'm doing it in Visual Basic 6, and the loading and unloading with the ...
So I have an excel workbook that has a global mapping scheme in it. So I have a shape for each and every country in excel. Depending on the region select, relative to the data/query, it will shade regions/countries in various ways. So I know how to manipulate each shape in terms of colors, gradient shading, etc.... What I don't know ho...
I'm trying to output data from an Access table as XML. The output looks like example A, what is required looks like example B. My current code to do this is shown below at example C If anyone could help it would be greatly appreciated. Example A: <inlineData inlineDataId="1"> <date>24 AUG, 2009</date> <regis>123456</regis> ...
So I have this global mapping scheme, and each country on it are individual shapes. I learned how to manipulate colors/fill based on certain criteria. So the way I do this, or the way I know how is one shape/object at a time. For example USA is "C_USA", Canada is "C_CAN", etc. So is there a way I can define countries into groups?? ie. ...
I'm trying to make a script to rename PC's to their serial number. I'm not great with VB, but I've been able to put together enough code to READ the serial number, but I'm not sure where to WRITE it. Here's what I currently have: strComputer = "." Set objWMIService = GetObject("winmgmts:\\" & strComputer & "\root\CIMV2") Set col...
I have a mdb file hosted on my site http://www.simplyfy.co.in/db/dbfile.mdb. I am developing an application which will be running on multiple machines and will contact the mdb file via internet. I am not sure how do i go about it as building the connection string for an online connection. Any help? ...
I added 3 optional boolean parameters to a method found within a VB6 DLL. The class that houses it is MultiUse (public), and the method itself is Private. The class implements a specific interface from a TLB, allowing for public calls to this method. After adding the 3 optional parameters on the VB6 side, I modified related C# code so t...
Hello I need a file search for my Visual Basic 2008 program. Do you guys know a way to start off? I've heard that you need admin priveledge for some file searches, but I don't want any of those kind of things since it would be a bug to the user. Thanks, KEvin ...
Lately I have been programming an application in Visual Basic 2008, and on one of my Windows Application forms I have several text box forms, and with my code the way it is, none of them can be enabled, and they must all be set to Read Only. Now if I put a big block of text in one of the Text Box's that extends past the parameters of th...
Hello How would I be able to make a variable that holds the value of the directories that exist in the C:\ Simple question to answer... Thanks Kevin ...
I have a relatively simple question regarding the best way to call the DataGridView.Rows.Add function when it is inherited into the current control. Which is the best way to make the call to the inherited control? Call it directly in the invoke or call it using recursive-like function? They both seem to produce the same result, a row get...
Hi, HttpPostRequest with Files only in VB2008 is easy: Using wc As New System.Net.WebClient() wc.UploadFile("http://server.de/exemple.php", "c:\test.png") End Using But I want POST Text + Files in one POST (username, password, file). But, how to? ...
Hi There, I have some vb code that brings up an e-mail when a user closes the workbook. I was wondering if there is something i can do to stop the user from closing the e-mail @ the x in top right coner and on file memnu, please find code below.... Private Sub Workbook_BeforeClose(Cancel As Boolean) repdate = Format(Date, "ddmmyyyy") ...