|
Your code could look something like that (providing you are using ADO):
MyConnection.Open MyConnectionString
MySQL = "INSERT INTO MyTable(MyField) VALUES('" & _
txtName.Text & "')"
MyConnection.Execute MySQL
MyConnection.Close
I hope this helps.
|
|
|
|
|
If you are getting a run-time error or your output is not appropriate, let a master programmer
look over your code. I'll catch subtle errors that your favorite debugger or linter will miss! See
my web page at: http://www.doctor-debug.com
|
|
|
|
|
Anyone know if or where I can get ahold of the icons that are used by Microsoft for all of their programs? I'd like to use commonly known icons in a project I've got.
|
|
|
|
|
This is an option of the VB install to install commonly used bitmaps and icons. Also you can take a handy dandy resource editor and extract them from system DLL's or reference them directly if you don't want to pull them into your project.
Hope it helps,
-Erik Thompson
|
|
|
|
|
I've got VB5 and it does not include many icons especially not the ones for MS apps.
I do have a program that will extract icons from dlls but what dlls contain the icons for MS apps? I can't seem to find any...
|
|
|
|
|
Hello,
Here's a good VB site that has ZIPs of MS icons plus some win 200 icons. I think its just what you are looking for.
http://www.vbaccelerator.com/
http://www.vbaccelerator.com/iconlib.htm
There's lots of good VB code also, check it out!
-- Marty
|
|
|
|
|
Here's a couple of sites you might want to check out!
Both site have a lot of Icon's.
http://www.ozemail.com.au/~afactor/iconolog/ico/index.html
http://www.winfiles.com/
Jerome W. Norgren
|
|
|
|
|
I need to build a menu with at least 400 items in a mdi application but VB do not let me do it.
Is there any way this can be done?
|
|
|
|
|
Use control array(s). For example if you create a menu item called mnuItem in one of your menus with the Index property of 0 you could dynamicly add items like this:
For i = 1 To 500
Load mnuItem(i)
mnuItem(i).Caption = "Item " & i
Next
However, I must say that if I was a user I wouldn't want to be scrolling thru 400 menu items.
|
|
|
|
|
WHY, on earth, would you want to do this?
The limit is there for two reasons. First, It's very bad design practice to put that many item in a menu. Second, If the first reason is true, there is no reason to put in support to support more than this.
RageInTheMachine9532
|
|
|
|
|
Surprise . I'm doing nothing here. Just registering my name in the history :->
Code-Frog:So if this is Pumpkinhead. Time for him to run and hide. It's an interesting thought really.
|
|
|
|
|
This is one way hiding a sensitive thread
Artificial Intelligence is no match for Natural Stupidity
No one can understand the truth until he drinks of coffee's frothy goodness. ~Sheik Abd-al-Kadir
I can't always be wrong ... or can I?
|
|
|
|
|
Code-Frog:So if this is Pumpkinhead. Time for him to run and hide. It's an interesting thought really.
|
|
|
|
|
We have a project that will run on standalone workstations
as well as on an NT terminal server. We need to be
able to call the WTS API in the latter case, so we will
use the LoadLibrary function to load the WTSapi32.dll.
I can then use GetProcAddr to get the address of the
function that I want from the dll. In VB, how can I
then call a function from the dll? Easy in C, but
for VB?
Thanks
Pls reply to bbuckley@trilan.com
|
|
|
|
|
I don't think that VB can use function pointers to call functions (although I'm not 100% positive). You can Declare a function and use it in VB (see docs on the Declare keyword). However your app will fail to load if wtsapi32.dll isn't on the system.
A solution for this would be to encapsulate all your WTS calls in a COM object in a separate DLL. Then, if your app wants to make some WTS calls, it can create an instance of this COM object and do what needs to be done. When your app isn't on a terminal server, it won't ever create this COM object.
Another solution would be to create a "stub" DLL, in C, that wrapped each function in wtsapi32 you wanted to call. Use the Declare keyword in your VB app to import each of these functions from your stub DLL. Then, when you wanted to call a certain wtsapi32 function, you'd instead call one of your stub dll's functions to do the dirty work (GetProcAddress(), call function, package return values and other info, then pass back to the calling VB function).
If your project is mainly VB, I'd take solution #1. If your project is enough of a mix of C and VB that you don't mind maintaining the C stub as part of the project, go for #2.
|
|
|
|
|
How exactly do I add a click handler for a button on a form using VBScript? In Java it's
I want to call a subroutine before the form does its POST thing.
Or, can the ACTION of a form be set to execute a VB sub instead of going to an URL or script?
|
|
|
|
|
<script language=vbscript>
sub beforeload()
msgbox "Hello World"
end sub
</script>
<INPUT TYPE="SUBMIT" onClick="beforeload()">
|
|
|
|
|
Hello Friends,
There is a component called web browser in VB6.Has anybody used it, Can anybody provide me startup tips on how to use this control as a web browser within my VB Form.
Thx a Ton
Lakshmi
|
|
|
|
|
It's really cool - it's a full featured HTML browser that you can drop right into your apps!
I think that there's an example project on CodeProject that demonstrates how to use it... if not, I'll write one up (we found some pretty cool things to do with it at work).
To use it, you just drop it onto your form. Then in code you can use its Navigate() or Navigate2() functions to tell it to show some HTML page. It fires events when interesting things happen - like the user clicking on a hyperlink, or other things like that.
Take a look at its properties and methods in the object browser - they're all pretty self explanatory. I'd advise creating a test project and just playing around with it for a day or two
|
|
|
|
|
Do you want to know how to make simple database applications in VB but don't know how, or you don't want to use a special 'engine' if so I think I have the appropriate tutorial for you.
visit www.pcbware.co.uk
thank you
Paul Kinlan
Senior Software Engineer
PCBware
www.pcbware.co.uk
|
|
|
|
|
hi im 18 yrs old programmer i know how to make programs with database but i also want to try other techniques in coding a program using database. can u give me some sample code or advice in writing program (im usually dont write functions)
truly yours
jaydee
|
|
|
|