|
Hi,
Currently i'm developing a system that store inventory record. In my system, i have a database named "rnz.mdb" and it has a table named "recordsList". The PK for the table is FormSerialNumber. The FormSerialNumber is like this --> 68001-001-001. The 1st 5 digit shows the form code.(68001 is the code for inventory form). The 3 digit in the middle is the item ID and the last 3 digits is the number of changes that have been made to the item(for example, computer upgrading). In the field also, there is a field named "Date". My problem is, my boss want the system to display the latest record for each item and at the same time keep the previous record of each of the item. The previous record will became the record's history. I can do the record history part. My problem is the latest record. How can I extract the latest record for each item from the list of records .
|
|
|
|
|
Try this:
Select * from sometable a
where a.FormSerialNumber = (Select max(b.FormSerialNumber)
from sometable b where a.identifier = b.identifier
This way you select the latest record
Hope this is the answer to your "VB" guestion
Grtz, Guus
|
|
|
|
|
|
What's the best way to document classes that you write in .NET? I know C# has some XML-comment documentation abilities, but VB .NET is limited. Plus the output of those is rather ugly.
I would like to be able to deliver nice "MSDN-looking" HTML documenation to the developers who will be using my classes, but I don't want to spend more time on the docs than on the code!
Barry Etter
|
|
|
|
|
The support for XML documentation provided by the C# compiler is very nice... using the xml output it produces combined with a tool like NDoc[^] creates very nice "MSDN-looking" documentation. Or if you don't want to use NDoc, you can always create your own XSL stylesheet to process the xml documentation.
It's too bad that the VB.NET compiler does not support the same feature. You may want to look at the following:
http://vb-doc.sourceforge.net/[^]
http://www.fesersoft.com/products/VBXmlComments/[^]
http://vbxmldoc.tor-erik.net/[^]
I haven't used any of these, so I can't offer a recommendation. But one may be what you're looking for.
|
|
|
|
|
How can i compare the value of a Current cell to Previous one in all of my row That are displayed in a datagrid? I got this result but I am Looking for a way which should be more efficient than mine.
Kenny
|
|
|
|
|
Maybe you should check the cells before they are displayed in the datagrid. Usually there is a recordset or an array attached to it. It's easy to compare these. But perhaps this is not your question.
Grtz,
Guus
|
|
|
|
|
I am working on a project in which we have to provide a UI to user in which all frames belonging to a selected mpeg2 video file are displayed. User then assign some attribute to each frame and then we have to store that video with those attributes added to each frame. Can any one give some idea about libraries or API's or controls which can help us.
|
|
|
|
|
Hi all,
Im currently developing a MFC-program in Visual C++ 6.0 that will identifiy a user through his/hers fingerprint.
The C++ program needs to be launched from another program with VBA support (so Im currently testing it in MS Excel)
The C++ program also needs to return a textstring with the username (or ID or some kind of text like "George Lucas")
With my very basic skills in VBScript I have manged to run the C++ program. But is it possible to get something back from the program ??
Im guessing that the C++ program might need some kind of method to communicate back to the VB Script ... ?
Im would be very thankful for any kind of help !
/ daniel
|
|
|
|
|
I have a VB project that loads a C++ DLL.
Declare the following module level API functions in your VB project.
' -- Windows API
Public Declare Function LoadLibrary Lib "kernel32" Alias "LoadLibraryA" (ByVal lpLibFileName As String) As Long
Public Declare Function FreeLibrary Lib "kernel32" (ByVal hLibModule As Long) As Long
' -- Public function in C++ DLL
Public Declare Function Test Lib "mycdll.dll" Alias "test_vb" () As Long
To use the C++ function you can use something like the following.
Note: strDLL holds the fullpath to the C++ DLL
' -- Load the dll
lngRet = LoadLibrary(strDLL)
' -- Check for success
If lngRet <> 0 Then
' -- Run the script
Msgbox Test
Else
MsgBox "Could not load dll '" & strDLL & "'" & DEF_SPACE, vbCritical, DEF_APP_TITLE
GoTo PROC_EXIT
End If
PROC_EXIT:
' -- Clean up
If lngRet <> 0 Then FreeLibrary lngRet
|
|
|
|
|
thank you, I'll look in to it
|
|
|
|
|
You can do that using the Exec method of the WScript.Shell object. The Exec method will return a WshScriptExec object that can be used to monitor the status of the running program, its exit code, and get to it StdIn, StdOut, and StdErr streams.
The docs on the WshShell.Exec method start here[^].
Dim WshShell, oExec
Set WshShell = CreateObject("WScript.Shell")
Set oExec = WshShell.Exec("MyCApp.exe")
Do While oExec.Status = 0
WScript.Sleep 100
Loop
WScript.Echo oExec.ExitCode
RageInTheMachine9532
|
|
|
|
|
Getting access to the StdOut would be great, thank you very much !
*edit*
Got it working now, thanks a bunch !
|
|
|
|
|
say suppose in my desktop application there is a datagrid having 20 records and i want that when i move my mouse pointer on any row then background color of that will be changed say red. i know it is possible in asp.net web application but i dont know how could i get this effect in my window application using vb.net at run time in desktop application not in the web application.if it is possible for any one then please give me small sample code to implement it for desktop application using vb.net
tbhattacharjee
|
|
|
|
|
If you change the Property Selection BackColor in the Grid Proerties page you can get your results. (If I understand your question properly)
Thanks,
Ken
Keshav.
|
|
|
|
|
Hi,
I am currently writing a utility to detect blank pages in tiff documents and delete them. I have a toolkit to manipulate the file but unfortunately it does not have a very flexible blank page detection routine.
So what I want to do is allow the user to set a percentage of black pixels parameter in a page and read the page data to look for the ratio of black to white pixels to determine if the page needs to be dropped.
The toolkit allows me to get the image data for each page into an IPicture but I am stuck from there on how to read the image data. Currently the system only needs to read black and white images (colour may be an option later but I will try to cross that bridge when I come to it)
So in short, can anyone help me in reading B&W data in an IPicture to count the black and white pixels?
Many thanks
Mark
|
|
|
|
|
I would like to create a command button on the vb form which i would like to export the data that i key in to the microsoft excel.What is the code for that command button?You get what i means???Thank !!!
|
|
|
|
|
Hi i am new to VB.NET. I want to develop an image gallery which consists of all kind of images. i want to show a thumbnail view for all the images. It consists of BMP,JPG,GIF,PSD,TIFF format. Is it possible to show PSD images in VB.NET if so how???
any help will be a great honour.
Thanks in advance.
Regards
Prasanna
|
|
|
|
|
I am migrating a large VB.6 solution to VB.Net and have encountered a problem that I haven't been able to solve.
It has been my habit for some years to notify myself of errors by putting up a new form and write to it the location and type of error that has occurred. This works nicely in VB.6.
I use this class in an error routine, such as.
Catch ex As Exception
Err.Showit("clsBars", "DoNewMinute", ex.Message.ToString)
End Try
In VB.Net the form comes up and is correctly sized and positioned and the error message is written to it.
When you pass the cursor over the form it turns to an hourglass. You can not minimize, maximize, close or drag the form.
If you use this class from a command button on another form with this code
Err.SetUpForm()
Err.Showit("This is a test")
the form behaves normally.
What am I missing?
Thanks
RCarey
Here is the code for my error class.(alias Err.)
Public Class clsError
Private dG As System.drawing.Graphics
Private dFt As System.Drawing.Font
Private dBr As SolidBrush
Private dFm As StringFormat
Private dX, dY As Integer
Private lineCount, maxLines As Double
Public Sub SetUpForm() '1/14/04
Dim dbgString As String
Try
frmError = New Form3 '<form3 is="" a="" ordinary="" form="" with="" no="" added="" objects
="" frmerror
="" .left="0
" .text="Errors"
="" .top="384
" .width="1000
" end="" with
="" frmerror.show()
="" catch="" ex="" as="" exception
="" dbgstring="ex.Message.ToString
" stop
="" try
="" dg="frmError.CreateGraphics
" dft="New" system.drawing.font("ariel",="" 7,="" fontstyle.regular)
="" dbr="New" solidbrush(color.black)
="" dfm="New" stringformat
="" dfm.formatflags="StringFormatFlags.MeasureTrailingSpaces
" maxlines="Math.Round(frmError.ClientSize.Height" dft.getheight)
="" sub
="" private="" sub="" clearform()="" '1="" 14="" 04
="" dim="" string
="" dg.clear(frmerror.backcolor)
="" linecount="0
" public="" overloads="" showit(byval="" instring="" string)="" if="" frmerror="" nothing="" then="" 'set="" up="" the="" form
="" setupform()
="" if
="">= maxLines Then
ClearForm()
End If
Catch ex As Exception
dbgString = ex.Message.ToString
Stop
End Try
Try
dX = 0
dG.DrawString(inString, dFt, dBr, dX, dY)
lineCount += 1
dY += dFt.Height
Catch ex As Exception
dbgString = ex.Message.ToString
Stop
End Try
End Sub
Public Overloads Sub Showit(ByVal inClass As String, ByVal inProcedure As String, ByVal message As String)
Dim dbgString As String
Try
If frmError Is Nothing Then 'set up the form
SetUpForm()
End If
Catch ex As Exception
dbgString = ex.Message.ToString
Stop
End Try
Try
dX = 0
dG.DrawString(inClass, dFt, dBr, dX, dY)
dX = 50
dG.DrawString(inProcedure, dFt, dBr, dX, dY)
dX = 200
dG.DrawString(message, dFt, dBr, dX, dY)
lineCount += 1
dY += dFt.Height
Catch ex As Exception
dbgString = ex.Message.ToString
Stop
End Try
End Sub
End Class
RCarey
|
|
|
|
|
I would like to show the .NET OpenFileDialog window after the MDI Parent Window is shown. This feature is available in the .NET IDE.
Tools/Options/Environment/General/AtStartup combobox.
Any ideas on how to code this feature?
Thanks,
Matt
.NetGuy
|
|
|
|
|
I got a problem here.
I need to link the microsoft excel to C++. The excel will act as a database for the coordinates..and i need to programme some commands for these coordinates like 3
Can C++ do this or should i use visual basic?
Thx alot
|
|
|
|
|
Goh Hui Beng wrote:
I got a problem here.
I need to link the microsoft excel to C++. The excel will act as a database for the coordinates..and i need to programme some commands for these coordinates like 3
Can C++ do this or should i use visual basic?
Thx alot
Hi, i have create a program using VB6.The purpose of this program are for sales department person key in the data and then review by manager.Now, my problem is manager want me to create a command button to export the data from microsoft access to excel.What is the command button code and the step? Another Question,this program must set up in the office and all the staff can see and use this program at their own PC's!Thank for ur help!
|
|
|
|
|
Hi,
I use crystal reports to show my reports @ my Winform. The procedure I do for this is...
Create a Crystal Report,
Create a Report Document,
Link the report document with the Crystal Report Viewer... as all described in the http://msdn.microsoft.com/msdnmag/issues/02/05/Crystal/default.aspx^, as in the server explorer section
But it reports the error as 'FAILED TO OPEN DATASET'..
Please help!!!
I was born intelligent
Education ruined me!.
|
|
|
|
|
How can i get the shared folders of a remote system?
|
|
|
|
|
How can I map & disconnect network drives using vb.net?Pleas replyy soonnnn.....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
