|
If you want to see if there is already a copy of the same application running then you use:
App.PrevInstance
Looking for an instance of ANOTHER application is a bit trickier but you can do it looking for window titles.
|
|
|
|
|
In Vbscript using Ole Automation how to I open a PPT presentation with the main PPT App window in a minimised mode
|
|
|
|
|
when a html file without its accompanying gifs, bmps etc is opened with ms-word
U get a msgbox "Some of the files in this Web page aren't in the
expected
location. Do you want to download them anyway? If you're sure the Web
page
is from a trusted source, click Yes." .
Basically, I want this msgbox to go away and Yes to be chosen by
default.
The reason being that we have automate the process using VB script and
when
this happens, No seems to be chosen by default.
|
|
|
|
|
What are you automating exactly?
Nick Parker
If the automobile had followed the same development as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year killing everyone inside.
-Robert Cringely
|
|
|
|
|
I am using the ADO in VB 6 and I was wondering how I could search the active database for a specific value. If someone could please give me a hand with this, that would be great!
|
|
|
|
|
Your question is a little decieving because you mention two different technologies used to access a database. I will assume you are using ADO. Here is an example to "search" a database. You will need to add a reference to the ADO object library in your program before running this code.
Dim conn As New ADODB.Connection
Dim adors As New ADODB.Recordset
Dim sql As String
sql = "SELECT User_ID Where username = '" & replace(txtUserName.Text, "'", "''") & "'"
Set conn = New ADODB.Connection
Set adors = New ADODB.Recordset
conn.ConnectionString = <code>"[YourConnectionStringGoesHere]"</code>
conn.Open
adors.ActiveConnection = conn
adors.Open (sql)
If Not adors.EOF Then
Do Until adors.EOF
MsgBox txtUserName.Text & "'s user id is " & adors("User_ID")
adors.MoveNext
Loop
Else
MsgBox "There are no records that match that name"
End If
adors.Close
Set adors = Nothing
conn.Close
Set conn = Nothing
HTH
Nick Parker
If the automobile had followed the same development as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year killing everyone inside.
-Robert Cringely
|
|
|
|
|
I've written a simple service in VB.NET and it's almost working right... almost. I need to debug it to see what's going wrong but I can't seem to work out how... You have to start the darned thing using that InstallUtil.exe and then start it through Services under Administrative Tools... but how do I connect to it and debug it?
|
|
|
|
|
ah, i can help you here
you have to start your service and then use the Debug > Processes... menu option to attach to your service, at that point you will be in debug mode in vs.net
a couple of points/warnings:
- to stop debugging, STOP the service from the services control panel applet instead of using the stop debug action in vs.net, otherwise you will have to uninstall your service and reboot your machine  in order to reinstall it again. when you stop the service properly, vs.net will exit debug mode gracefully
- you only get 30 seconds from the time you start your service to attach and debug the OnStart() method,, use the application log to log debug messages, it's much easier than racing to attach to the process,, servicebase has an applicationlog method for this (logmessage() i think)
- this is cool: once your service has been installed with installutil.exe, you can stop the service, make code changes, recompile the service and start it again without uninstalling and reinstalling it
iv'e been thinking of writing an article for writing a service in .net, but i haven't gotten around to it yet 
-John
|
|
|
|
|
Thanks! I actually worked it out yesterday on my own but you gave some good points. Thanks for the help!
|
|
|
|
|
Hi there,
I m working on a application that is supposed to get a lot of info thru the web and it s calling a dll on server side thru SOAP..
1)it s working on several server but on one of them it s saying 'Class not registered"
2) when 2 client are accessingin the same times a big piece of work for the server it says send the 5300 error message which mean bad connection.. but it works fine if only one does that job
Anyone has a idea?
Thx
__________________
|
|
|
|
|
The DLL on the server... what's that written in and how is it setup? If it's a COM DLL (not .NET) you probably need to set it up through Component Services as a COM+ application. It's easy to add these "hooks" into a DLL if they aren't already there (depending on what language was used for it's development). In COM+ your DLL can be managed by Windows in a way where it can be properly instanced for use in a Web environment.
|
|
|
|
|
how to import a file from excel and then store it as a table in ms-access database thru vb.net code? plz help
|
|
|
|
|
Are you still stuck on this? I'm pretty sure my buddy has done this before so I could ask him tomorrow if you're still stick (seeing as you asked this a little while ago).
|
|
|
|
|
how to execute query thru code and display the results thru code in VB.Net?
when the data is connected thru oleDbDataadapter i.e MSaccess??
plz help !!
|
|
|
|
|
how to implement Update procedure in visual basic.net when
connection to the database is made using oledbDataadapter and objdataset??
i mean how to implement update query in dataset
when i try update it gives me this error :
Update requires a valid Update Command when passed DataRow collection
with modified rows.
please tell me how to solve this?
--thnx
|
|
|
|
|
you could try and add an Edit() command. I know in VB 6.0, you can only put an update() command if you had an edit or add command before it.
I'm not usre if it is the same in vb.net, I am still in the trial period of experimenting with it.
Have fun!
|
|
|
|
|
pretty new to .NET, i was just trying to read an image column (recordset) into a stream object before i flush the stream and dump everything to disk.
Here's the code:
mstream.Write rs.Fields("Photo").Value 'Exception thrown here!
mstream.SaveToFile "c:\oolala.bmp"
The exception thrown:
MYQUOTE:
"SystemRuntime.InteropServices.COMException 0x800A0C93 Operation is not allowed in this context
at ADODB.StreamClass.Write( Object Buffer)
..."
Any idea? I presume i cant just put this VB 6 code in VB.NET...? any pointer?
Thanx!
norman_lm_fung@hotmail.com
norm
|
|
|
|
|
can any1 help me out... problem is how to create ActiveX controls for making a time line for scheduling which should also have the option of draging so the schedule can be updated.
|
|
|
|
|
I have an old VB6 projected that I have upgraded to VB.NET and all works well apart from one strange issue.
I have a form with an Load event handler, not if I display the form using myForm.Show () Load executes, if I use myForm.ShowDialog () then Load does not execute!
Is there a way round this?
Thanks
Stephen.
|
|
|
|
|
I have not played around with .ShowDialog much, but from the looks of it, what you see is what you get. Is there a reason you are using ShowDialog vs. show? Are you really trying to use this form as a modal dialog box?
|
|
|
|
|
I am writing an application right now in VB 6.0. I was just wondering if someone could help with this. Upon the FormLoad() function, I need the program to call a notepad file (main.ini) and read the third line and replace a variable inside of my program. Can somebody please please help me????
Thanks again,
Bob
|
|
|
|
|
|
ray's ini file reader is the preferred method for working with application config stuff, but if you want to work with text files, use the FileSystemObject
where: scrrun.dll,
register dialog: Microsoft Scripting Runtime
progid: scripting.filesystemobject
i'm typing this code in manually, so it might not be syntactful
<br />
<br />
dim fso as scripting.filesystemobject<br />
set fso = new scripting.filesystemobject<br />
<br />
dim txt as scripting.textstream<br />
set txt = fso.opentextfile("c:\mytextfile.txt")<br />
<br />
do while not txt.atendofstream<br />
msgbox txt.readline<br />
loop<br />
<br />
txt.close<br />
set txt = nothing<br />
set fso = nothing<br />
<br />
-John
|
|
|
|
|
I need to get a path of an app's exe using registry,in VBS
|
|
|
|
|
I would search the registry for the filename that you need the path to. If it is an exe file that is registered to a file ext then it will probably show up in there. Once you know it you can open the key in your script and check to see if it exists.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
