|
oRsAdmin.Close
Set oRsAdmin = Nothing
IS right!
|
|
|
|
|
I think it's closed automatically !!
|
|
|
|
|
Hello Everybody
I access the data as follows..
Check Box Order Number Entered By Qty Total Qty 25
1 ab 10 Entered BY ab
2 xy 15
3 xy 6
4 ab 15
5 mn 21
6 rs 21
Now I like to put check mark to group the orders entered by same person and see what would be the total quantity . Ex. Another columns which expalin that when there is a check mark against ab the that would be total qyantity and the name of the person.
I hope I explain clearly. I need help here.. How can I do that?
I am new to Vb.net. Pl. let me know.
Thanks.
bmpu
|
|
|
|
|
I'am new to VB and doing a little dibbling. When I create a form and want to have a label/text or a picture capable of draging and droping on any part of my form? I am using a picture on the form and want to be able to move lables/text or other picture boxes from one location to another on the picture.
Barry
|
|
|
|
|
I am relatively new to VB, using VB6; and working on a project that needs to be able to allow someone to type into a text box a name and then click a button to have it search through a certain drive's folders for Excel or Word files that have that the name somewhere in the file.
I have found some codes on the net that can do close to that, BUT I need the people using this application to be able to double-click on the file from the list of ones returned and be able to have that file open up in either Excel or Word depending on the extension.
Using oshell.FindFiles seems to get me the closest to accomplishing what I want by just pulling up the Window's Serch box; but how can I make the "containing text" box stand out, or tell it to look at .xls and .doc files, and OLNLY from certain directories in a certain drive?
Is oshell.FindFast what I should be trying to do this on or is there another way?
Thanks for any help anyone can offer; it is mucho appreciated!
CP
|
|
|
|
|
I have 2 class libraries and a Windows Application that use a common set of of structures and classes to pass and manipulate data. Each is written in VB.NET. My thinking was to create a public module, shared through Source Safe so a GetLatest would at least update all projects before a build. Now, many of the public and private methods within each class library pass data types that include some of these "shared" structures and classes.
I was planning on simply including that public module in each of these projects so the type information would be common knowledge. However, it doesn't work... the compiler says (for instance in the Windows application) that the type should be ClassLibrary1.modPublicStructures.clsMyClass and not MyWindowsApp.modPublicStructures.clsMyClass.
Now, I KNOW I can simply create yet another class library that contains this set of common classes and then add a reference to that new class library to each of these projects... but that's now ANOTHER DLL added to the project. Surely there's another way to accomplish this.
???
|
|
|
|
|
Hi All,
Is this forum an appropriate place for issues regarding VBA development? (I'm working with Excel) -- If not, can anyone recommend a good forum?
Thanks
READIN writin rhythmetic
|
|
|
|
|
Sure.I've posted VBA Qs here in the past, and nobody's shot me......yet;)
God, I pity me! - Phoncible P. Bone
If I end up Windows ME someone is going to be hurting. - One of the answers to a question for What OS are you
|
|
|
|
|
Thanks, problem solved -- a stray DoEvents floating around from a previous version of the program, once I deleted it everything worked.
READIN writin rhythmetic
|
|
|
|
|
Glad to hear it worked out for you.
God, I pity me! - Phoncible P. Bone
If I end up Windows ME someone is going to be hurting. - One of the answers to a question for What OS are you
|
|
|
|
|
Hi
Here's the problem: Trying to generate reports using Crystal Reports for Visual Studio .NET (specifically VB.NET) , using a MySQL database doesn't seem to work with any kind of Left Outer Join. The link type setting ( =, <=, != etc...) also confuses me. HELP HELP HELP! If you have any information, need more information from me to help, or know who i can ask, please e-mail me at cnight@webmail.co.za. Thanks for your time.
Chris
where do you want to mow today?
|
|
|
|
|
|
You have 2 options:
1. Add a property Get "specControl" (or whatever name you want) to your MyControl with return type specControl. This makes the all properties/methods of specControl accessible for the outside world. A thing to be aware of is that you test/handle _every_ possible combination of specControl and MyControl, because you don't have control over specControl anymore.
2. This is usually a better solutions although looks like/is duplicating code. Add properties of specControl to MyControl which you want to make available to the outside world. In the implementation of those properties you're internally forwarding to specControl. With this option _you_ are in control of specControl.
Hope this helps.
|
|
|
|
|
I'm trying to invoke a method of a web service which is running with the basic authentication. I'm using MS Soap Toolkit 3.0's low level API's to invoke a web service method. Following code is used to set the authentication details..Connector.Property("AuthUser") = "userid" and Connector.Property("AuthPassword") = "pwd"..but I'm receiving an error always.
here's the error message
Error 401--Unauthorized xxx
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.4.2 401 Unauthorized
If anyone has encountered this type of problem before and got solution for this problem, please let me know immediately.
Thanks for any help offered,
Praveen
|
|
|
|
|
I am using the SendMessage API to read text from a textbox in a third party application.
I am calling it using the following command:
Win32API.SendMessage(hwnd, WM_GETTEXT, textlength, mymessage)
where hwnd is an Int32 representing the textbox handle;
WM_GETTEXT is a constant
textlength is the number of characters to be retrieved; and
mymessage is the string to store the info.
Everything seems OK apart from the fact that when I try and display the string it simply appears as a series of blobs.....not readable text (see below).
片敡敭丠睥慭敔瑳倠条eಇ䐁
This is my first foray into the world of Win32 APIs and VB.Net so your help would be much appreciated.
|
|
|
|
|
I have build a windows services. The windows service are controlled by 'n windows application. The problem: When I start the windows service form the windows application the application timed Out.
Service cannot be started. System.Net.WebException: The operation has timed-out.
at KITSync.KITSync.serviceStart()
at KITSync.KITSync.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
If I start the windows services manually the program runs smoothly. The problem only occurs after installation not in the development environment.
Please help me!
Thanks Regardt
|
|
|
|
|
Hi
I have a large project which refers to a number of dll's. These dll's are in small projects which I often go back to and change from Debug to Release and then rebuild them.
The main project is also often switched from Debug to Release.
What I'm now finding is that if I press F5 from the IDE (either in Debug or Release), even though the Output window says its building the project, any changes I've made to the main project are not reflected in this build.
However, if I select from the menu, Build and then press F5 the new build is fine.
I've tried deleting all *.dll;*.exe;*.pdb but this seems to help for a couple of hours, and then it goes back to its old behaviour.
Has anyone else experienced this ?
TIA
Jeremy
|
|
|
|
|
Does the same problem occur if you Build >> Rebuild Solution instead of just using F5?
This seemed to solve our issue.
Cheers,
Simon
sig :: "Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG picture :: my first abstract photo
|
|
|
|
|
Simon
Yes it still happens with Rebuild Solution - note its one of these intermittent problems, sometimes happens sometimes doesn't. I've just got into the habit of doing a build before a run - but its still very irritating.
Regards
Jeremy
|
|
|
|
|
Wonder if there is a way to create a windows form notification/alert to inform the user when there is an update made to microsoft Sql Server database?
|
|
|
|
|
How can i change the font, forecolor,caption and ...
in then msgbox function of vb6.
please answer me?????
MkhProgrammer
|
|
|
|
|
The easiest way(maybe the only one) is to make your own MsgBox !!
Create a with label to hold the text and put buttons (OK,Cancel,etc..) and make them visible/invisible according to parameters passed.
|
|
|
|
|
The short answer is you can't! The long answer is to write your own MsgBox function.
RageInTheMachine9532
|
|
|
|
|
i want suggestions for my major project which i have to make in my 4th year of engineering.
I will be very grateful if u can suggest something which is very good and a good learning experience.
PLEASE HELP!!!
Every problem has a solution!
|
|
|
|
|
Hello all..
How to get the icon that is associate with the file?
I have email item... which contain file attachments..
So first get the file attachment using mail.Attachments and mail.Attachment. Up to here no problem..
here the code to get the icon and saving it in C:\PCKM so I can call the image file from HTML code
<br />
Function GetIconLocation(ByVal filename As String) As String<br />
Dim loc As String<br />
'Use this to get the small icon.<br />
Dim fName As String 'The file name to get the icon from.<br />
Dim shinfo As SHFILEINFO<br />
shinfo = New SHFILEINFO<br />
Dim openFileDialog1 As OpenFileDialog<br />
openFileDialog1 = New OpenFileDialog<br />
Dim hImgSmall As IntPtr 'The handle to the system image list.<br />
<br />
hImgSmall = SHGetFileInfo(filename, 0, shinfo, Marshal.SizeOf(shinfo), SHGFI_ICON Or SHGFI_SMALLICON)<br />
Dim hIcon As Icon<br />
hIcon = Icon.FromHandle(shinfo.hIcon)<br />
<br />
Dim bip As System.Drawing.Bitmap<br />
bip = hIcon.ToBitmap()<br />
bip.Save("c:\pckm\icon.bmp")<br />
loc = "<img src=""c:\pckm\icon.bmp""><br>" & filename<br />
<br />
GetIconLocation = loc<br />
End Function<br />
After I saved the icon.bmp I try to open it by double clicking the file or using open with to oen the file but can't open with any other programs
How to save the icon to the hard drive???
Thank you
|
|
|
|