|
I'm not sure why the textbox is showing 0, but looking from your SQL Statement,"Select Max(OrderNumber) from OrderGenerate" ,would only return 1 row, the maximum(largest) OrderNumber.Then RS.RecordCount would only return 1, thus your textbox would always remain "2"
Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain
Get your facts first, and then you can distort them as much as you please
Mark Twain
|
|
|
|
|
Someone from a third party vendor has written a vb script for my company. I just wanted to update the script on my own since I can no longer contact the vendor. Here is what he has left us. We have 4 files: .bas, .cls, .exe, .vbp
I'm under the impression that I need to open the vb script and then compile it and should recreate the .exe and everything should work. The problem is I don't know if I have the correct file to open or what vb editor he used and if it is compatible with what I am using. I'm using .net. Any help would be appreciated, and I can give more details as needed.
Thanks,
Dan
|
|
|
|
|
First, this is NOT vbscript.. it is full VB.
Files are as follows:
vbp - Visual Basic project file - This is what you open in the VB IDE to open the project.
exe - Obviously the compiled application.
cls - A class source file. non-.NET versions require that each class be in it's own source file.
bas - A code module. This file holds only code, no form definitions.
By what you have told me I assume that the application does not interact with the user outside of possibly some simple dialog boxes maybe? I say this because you didn't point out any .frm files, the files that hold userform definitions.
You will need to use VB to open this project and recompile when you have made the changes that you need. What particular version I can not say for sure. I would think that it could be anything from Version 4 to 6. Open up the vbp file in notepad and it sould give you some indication of hte version needed if you don't already know.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
I have Visual Basic. net. When I try to open the .vbp it tells me visual basic 6 migration is not supported with this version. So I'm assuming is version 6. You are right there are no forms and it requires no user intevention. The program simple updates one database and puts it in another so we don't have to do it manually. The problem is I moved one of the databases onto another server therefore the path has changed and it its no longer updating. If I just want to update the program then what would I need to do assuming I have version 6. Do I open the .vbp or what. I see no reference to the path of the old computer in the .vbp, but I do see it in the .bas. Any more help would be appreciated. If you don't want me to directly email you back please let me know.
Dan
|
|
|
|
|
Well if all you have is VB.NET then you are goingt o be in a bind. I belive that you only get the option to upgrade older VB6 projects if you have the Enterprize Architect version. Sounds like maybe you only have Pro. You probably don't want to upgrade the project anyway.
Changing the path in the bas file will only get you so far. You will have to recompile once the change it made. That will require that you have VB6.
If you are in a pinch and don't have access to VB6 (There is a copy in the older MSDN CD's) You can send me the project, let me know what you need changed, and I can rebuild it for you. Provided that you don't reference any other components that I don't have things should be ok.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
Could someone tell me how to get the short filename from a long filename using VB.NET? In VB you'd have to pull it from the kernel but for one thing I can't seem to get that to work and secondly, I'd prefer to use the proper .NET class/namespace for it if it's available.
Thanks,
Matt
|
|
|
|
|
I don't know how to do this, but make sure that windows does create short
name for it. on 2000 and xp it is turned off by default. an there is no short names for the files.
Die DOS die ...
|
|
|
|
|
dear all,
i want to run my vb exe from the run dialog box in windows with some command line parameters.
how do i read those parameters in vb
|
|
|
|
|
In VB6 you use the Command$ function. It returns a string of the arguments passed into the app. You then have to parse it apart and act on each one.
in VB.NET check this out:
http://www.vb2themax.com/Item.asp?PageID=TipBank&ID=510[^]
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
nSQL = "Insert Into OrderDetail (OrderNo, ProductCode, ProductDesc, Quantity, Price) Values ('" & strOrderNo & "', '" & strCode & "', '" & strDesc & "', " & iQuantity & ", " & iFullPrice & ")"
Set RS = Conn.Execute(nSQL)
DataGrid2.Refresh
What the above code is trying to do is that when a command button is pressed, the values in the textboxes are saved to the OrderDetail table. However, what I also wish to happen is that the datagrid (the datagrid is bound to this OrderDetails table) is updated with this new record. This is not happening - what am i doing wrong?
Thanking you in advance!
|
|
|
|
|
if the OrderNumber is an autonumber(as opposed to text) in the Order table of the database, is it possible to display this number in a textbox on loading of the order generation form?
Thank you in advance!
|
|
|
|
|
I have doen this in the past by using a separate table that only contains the autonumber feild and a column for a username. I add a new record to the table (by writing the username), to get a new invoice number, then a run a querry that grabs the top 1 from the list with that username. I then use that number in the table that contains the invoice data. Seems to work quite cleanly.
Not sure just how leagle it is with regards to DB theory, but it has worked in the past.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
Does anyone know how you would detect an mp3 file that's currently playing, through WinAmp or Windows Media Player, and display the song information?
Any help would be much appreciated
|
|
|
|
|
I think, there is no universal way for both players, but at least for WinAmp there must be some way, because some time ago I saw a plugin which writes the currently played song to the mIRC client and also lot of other plugins for WinAmp displays the song info. But this is an issue for the WinAmp Plugin SDK, how it is with WMP, don't know...
Good luck!
|
|
|
|
|
I want to write a client program(.dll). The Client Program Will response whe message from IE. When I visit a special document from address of IE,My application will run and open the document.Example: When I visit a file of the extend name is '.rm' from IE , the realplay whill run and open the file.
BUT I don't know how to response whe message from IE.
|
|
|
|
|
I have project that I found on a Russian web site, that registers it self as a service and monitors the microsoft internet explorer. It will only work under windows 98. it suppose to work under 95 but it does not. email me at ilya@pokrovskiys.com if you want this project.
It might be what your are looking for.
You might find a way make it work under xp and 2000
|
|
|
|
|
hi to ya'll..want to ask a ques..ok lets say i have an Linux operating system and i want to write a configuration file into the system that can read the data entered by the user(data enter by user is done using VB, VB is used to create the interface and then vbscript is used to generate a text file. The text file contains all info entered by the user. This text file is then sent to the Linux OS, and a configuration file in the os is used to validate the info entered).Ok, my ques is what language am i going to use, and how am i going to do it?
Nash Hon
|
|
|
|
|
I can send a file from the server to the client by having the client call a function which returns a FileStream. It works perfectly.
I tried to send a file from the client to the server by having the client call a function with a filestream as a parameter. Unfortunately, the client gives me an error saying the the remoting proxy has no channel sink. 
The client's call:
T.SendFileTest2(New FileStream("C:\in2.txt", FileMode.Open))
The function in the hosted object:
Public Function SendFileTest2(ByVal FSL1 As FileStream) As Boolean
Dim Buffer(4096) As Byte
Dim readed As Integer
Do
readed = FSL1.Read(Buffer, 0, 4096)
Dim i As Integer
Dim str As String
For i = 0 To readed - 1
str += Convert.ToChar(Buffer(i))
Next
MsgBox(str)
Loop Until readed < 4096
FSL1.Close()
FSL1 = Nothing
End Function
I would greatly appreciate any help on this.
Thanks,
Steve
|
|
|
|
|
I design a COM object by ATL, which has two IDispath. Default dispatch is IPlot2D, and the second is IMIDraw.
IMIDraw has a method Plot(), how do I launch Plot() method?
|
|
|
|
|
How can I check if a user is connected to the Internet. I used the function 'InternetGetConnectedState' but it does not work with IE 6 and WinXP. Any help is more than welcome !
*** Praise none, but the Creator ***
T-break SUX
|
|
|
|
|
Hi VB Experts
Normally, I'm using C++ for my developmments but I need to configure a supervision software that makes a heavy use of VBA ... so I apologize for my stupid question...
This supervision software allows us to make views of industrial processes. These vies are NOT use classical VB forms. So the methods of the VB forms are not available .... I need to set the cursor to hourglass for lengthy processing but I failed to succed.
I declared the functions SetCursor and LoadCursor as 'Private Declare Function SetCursor Lib "user32" .... and same for LoadCursor
Then I try to get the cursor with the call:
SetCursor( LoadCursor( 0, 32514&))
But it does not work !!!
What shoudl I do to succeed ?
Thanks for your help
Thierry
|
|
|
|
|
|
I have zero experience with vb for applications, but in regular dot net you don't need anything but this one line:
Cursor.Current = Cursors.WaitCursor
Then
Cursor.Current = Cursors.Arrow
Hope this helps,
Mike "MC5" C
|
|
|
|
|
This is using vb6...
Help I've just encountered some problem with my application. When i am running my application from the Project file, everything works fine, but when i made the exe file, a run-time error occurs when i run some process.
Does anyone know the error only occurs in the exe and not the project file?
btw, the error occurs regarding the sort method of the range class of the excel object
Notorious SMC
The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain
Get your facts first, and then you can distort them as much as you please
Mark Twain
|
|
|
|
|
I am writing an application, where a third party company is writing some components. My question is this: My boss is under the impression that a DLL can be dropped into the bin folder and we can run with it (i.e.: access properties/methods within the DLL) I tried dropping the DLL into my bin folder, then adding an Import in the projects property pages, to no avail. Does anyone know of anyway besides reflection that this can be done ??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
