|
Luc Pattyn wrote: ...so we count crocodiles if anything. Would that be all right too?
That'd work, although I'd count them from a distance. We have alligators in my part of the world - not the friendliest creatures I've ever seen. Although they're great for sausage.
Everybody SHUT UP until I finish my coffee...
|
|
|
|
|
this is my code
selectdata2 = "SELECT Students.[Name 1], Students.[Name 2], Students.[Name 3], Students.[ID number], StudentClass.Class FROM Students INNER JOIN StudentClass ON Students.[ID number] = StudentClass.[ID number] WHERE ((StudentClass.Class>=100) And (StudentClass.Class<=1209) AND (StudentClass.Position=1)) ORDER BY Students.[Name 1]"
but give me this error "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)"
this work when I remove "StudentClass.Position=1" from where clause. And I use MS access 2003 database.
|
|
|
|
|
Did you try using StudentClass.[Position] ?
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Thanks a lot, it worked for me.........thnks friend....
|
|
|
|
|
ivo75 wrote: this is my code
Please don't use spaces in your fieldnames. You might find it more readable, but the computer will be reading it more often than you will. Once the spaces are gone, you can drop the brackets around those names, which could simplify the statement a lot;
SELECT Students.FirstName
, Students.SecondName
, Students.ThirdName
, Students.Identification
, StudentClass.Class
FROM Students
INNER JOIN StudentClass ON Students.Identification = StudentClass.Identification
WHERE StudentClass.Class>=100
AND StudentClass.Class<=1209
AND StudentClass.Position=1
ORDER BY Students.FistName
ivo75 wrote: but give me this error "IErrorInfo.GetDescription failed with E_FAIL(0x80004005)"
According to Google, this could be caused by having a reserved keyword as a fieldname. You'll need a new naming-convention
I are Troll
|
|
|
|
|
Next time you've got a SQL problem, ask in the General Database forum. This has nothing to do with VB.NET.
|
|
|
|
|
Hello Everybody!
I've been puzzling all day over how I would go about giving a custom application icon to a VB.NET executable compiled from VB.NET 2010 code using the VBCodeProvider class.
My application compiles VB.NET source code into a .NET executable like this:
Dim MyCodeProvider As New VBCodeProvider
Dim MyCompilerOptions As New CompilerParameters
MyCompilerOptions.GenerateExecutable = True
MyCodeProvider.CompileAssemblyFromSource(MyCompilerOptions, MySourceCode)
That's working great, but I can't find a way to assign custom application icons to the generated executables. I've tried using a ResourceWriter to create a resources file with the icon in it and embedding that in the executable like so:
Dim MyResourceWriter As New ResourceWriter("C:\AppResources.resources")
MyResourceWriter.AddResource("APPICON", New Drawing.Icon("C:\AppIcon.ico"))
MyResourceWriter.Generate()
MyResourceWriter.Close()
MyCompilerOptions.EmbeddedResources.Add("C:\AppResources.resources")
However, though the generated executable increases in size (which leads me to think that the icon data is in there somewhere), the icon still doesn't show up as the application icon in Windows Explorer.
I'm a real novice at using resource files, and I just can't get it to work. Can anybody see what I'm doing wrong?
Thanks in advance!
MrWolfy
modified on Saturday, December 25, 2010 5:30 PM
|
|
|
|
|
|
Hi!
Perfect! Absolutely exactly what I was looking for, thank you very much indeed for the link!
Thanks Again!
MrWolfy
|
|
|
|
|
You're welcome
|
|
|
|
|
Hi
I have a VB6 system that updates Word 2000 documents held in RTF format with case specific information at points indicated in the document such as [0123] meaning replace these 6 characters with the 123rd element of case specific information. I am now in the process of upgrading this to Word 2007 and Open XML. The reason for moving to open XML is that it seems that Microsoft will not be continuing its support of RTF.
My problems are as follows:
1. When I insert case specific information I need to make it a specific colour. This works okay with Word 2000 and RTF because I just surround it with {\cf5 and }. What do I do with Open XML?
2. I have specific inserts for Returns, Tabs, Centres, Italics and Bold that in Word 2000 and RTF can be achieved by \par, \tab, {\qc, {\i and {\b with those starting with { being ended with }. What do I do in Word 2007 and Open XML?
3. I need to find the MS section breaks which are \sect in Word 2000 and RTF. What are they in Word 2007 and Open XML?
Any assistance will be greatly appreciated.
Regards
Mac
|
|
|
|
|
B Mac Gregor wrote: Any assistance will be greatly appreciated.
It won't be as simple as asking "what tag is replacing this one". RTF is a single file, OpenXML is a bundle of files.
You could download the SDK[^] and work through the examples
I are Troll
|
|
|
|
|
Hi
I want to enable the DataGridView's particular cell as multiline...
and accordingly the rows width has to increase automatically...
Does anybody have idea about it?
Thanks For The Ideas...
My Codings:-
------------
Dim MyDtb1 As New DataTable,NRow as DataRow
MyDtb1.Columns.Add("one", Type.GetType("System.String"))
MyDtb1.Columns.Add("two", Type.GetType("System.String"))
MyDtb1.Columns.Add("three", Type.GetType("System.String"))
For p As Integer = 0 To 20
Drow = MyDtb1.NewRow
MyDtb1.Rows.Add(Drow)
Next
DataGridView1.DataSource = MyDtb1
Suppose particular cell, my user need to entry multiple lines..
I don't know which event can do...and where to include...
my expectation is like....
If DataGridView1.CurrentCell.RowIndex = 12 And DataGridView1.CurrentCell.ColumnIndex = 1 Then
??????????????
????????
End If
Thanks
|
|
|
|
|
You can do this by setting dataGridView1.Rows[rowIndex].Cells[colIndex].Style.WrapMode to true.
Finally is not executed always. As told by Sir Pete and PiebaldConsult. Go figure.
|
|
|
|
|
|
Hi...any one can help me how to get the filename of current window/application using vb 6?
modified on Tuesday, December 28, 2010 5:50 AM
|
|
|
|
|
The current application can be retrieved using App.Path and App.ExeName properties. Forms are a different story, an example of looping through the available windows is available here[^].
I are Troll
|
|
|
|
|
Eddie is taking an educated guess at what you want.
You're going to have to explain further what you're trying to do. What do you mean by "current application"? Are you talking about your application that is running? Are you talking about the application window (doesn't matter what application) that has the focus?
|
|
|
|
|
Thank you. Yes, i talk about the application window that has focus, not just my application. I can get the caption of any window that has focus, but i don't know how to get the filename.
|
|
|
|
|
Unless you are REALLY familiar with Win32 and how process, modules, handles, ... work, you're going to find this very difficult to do. There are no built-in functions in VB6 that will do this for you and WMI will not help either.
Basically, once you get the window handle, you'd have to get the ThreadId that owns the window handle using the Win32 function GetWindowThreadProcessId. Once you've got the ProcessId, you can use it to get the process information. You can get the steps and functions required from this article[^], but all the code is in C++. You'll have to Google around for any examples of the functions use in VB6. I don't have any examples since I dropped all VB6 use almost 10 years ago.
|
|
|
|
|
Finally, i have get the code. I combine the GetWindowThreadProcessId and GetForegroundWindow of Win32 function. Thank you very much!
|
|
|
|
|
Please some help me updating check box in SQLStmt . beep me back in mail (villanuevaleinad@yahoo.com).. thanks
|
|
|
|
|
That is not how this site works. I suggest you read the "how to get an answer" message on this page, then abide by it; people here will gladly answer a properly asked question or two.
And I suggest you don't post e-mail addresses; you may get unwanted guests.
|
|
|
|
|
Beep, beep.
CQ de W5ALT
Walt Fair, Jr., P. E.
Comport Computing
Specializing in Technical Engineering Software
|
|
|
|
|
Consider revising your question to make some sense. An SQL statement cannot modify the state of a checkbox.
|
|
|
|