|
Have you tried:
Shell("C:\Program Files\Microsoft Office\Office11\WINWORD.EXE " & """" & "c:\Documents and Settings\Administrator\My Documents\Docs\Analysis.doc" & """")
|
|
|
|
|
I just knew it would take 2 or three sets of quotes...(yeah right)
What does the ampersand do?
|
|
|
|
|
Ampersand concatenates the strings into one string. The """" adds quotation marks, which are required because the file path has spaces.
VB reads the resulting command line as:
C:\Program Files\Microsoft Office\Office11\WINWORD.EXE "c:\Documents and Settings\Administrator\My Documents\Docs\Analysis.doc"
Not sure why you can have spaces in the executable path without adding quotes.
|
|
|
|
|
if you just like to open a .doc file you also can do this by
Process.Start("c:\Documents and Settings\Administrator\My Documents\Docs\Analysis.doc")
|
|
|
|
|
Thanks alot, Process.Start requires less keystrokes to process. I have found a invaluable resource here at the Code Project. Way Cool...
|
|
|
|
|
Hello everybody,
I've cretaed a database application that build tables/triggers/stored-procedures at runtime (Oracle DB 10g).
After all tables created, the application starts creating the triggers and the SPs.
this is small code:
--------------------------------------------------------------------------------
Public Shared Sub CreateTriggers()
Dim Err As String = ""
Dim HasErr As Boolean = False
Dim CmdTmp As OleDbCommand = New OleDbCommand
With CmdTmp
.Connection = oConn
'creating trigger(s)
.CommandText = "CREATE TRIGGER change_status AFTER INSERT ON invoices " & _
"REFERENCING NEW AS newRow FOR EACH ROW " & _
"BEGIN update orders set orders.order_status='Close' where orders.orderID = :newRow.orderID; " & _
"END change_status;"
.CommandType = CommandType.Text
Try
.ExecuteNonQuery()
Catch ex As Exception
HasErr = True
Err += ex.Message + Chr(13)
End Try
'creating stored-procedure(s)
.CommandText = "CREATE OR REPLACE PROCEDURE Add_Inventory(SID varchar2, IID varchar2, Amount Number ) " & _
"IS " & _
"BEGIN " & _
"Insert Into Inventory(StoreID, ItemID, Inv_Amount, Inv_DateM, Inv_DateY) " & _
"Values(SID, IID, Amount, To_Number(To_Char(SysDate, 'MM')), To_Number(To_Char(SysDate, 'YYYY'))); " & _
"END;"
Try
.ExecuteNonQuery()
Catch ex As Exception
HasErr = True
Err += ex.Message + Chr(13)
End Try
...
...
--------------------------------------------------------------------------------
now, I dont get exceptions when the app runs, but the triggers\SPs were NOT created..
I also created tables at run-time and there is no problem..the tables have been created...
There is no problem creating the triggers\SPs from sqlplus with the same user
so I dont think that is a permissions problem
(when I copy the trigger/SP code & paste it in sqlplus, I get the message(s)
Trigger created
or
procedure created )
I also CAN delete trigger(s)\SP(s) from the application but CANNOT create them..
what could be the problem?
please help me out here..I'm stuck...
Thank You
RoyRose
|
|
|
|
|
he y don't u try stored procedures instend of command text
|
|
|
|
|
Hey,
Well, I guess this some kind of bug that OleDbCommand cannot create trigger or SPs but when I changed the objects to Oracle object (OracleConnection, OracleCommand, OracleDataAdapet, OracleTransaction..)
Everything works!
Thank You
RoyRose
|
|
|
|
|
How to make our winform application custom skin like yahoo change its skin base on different images and ini file setting.
I mean Form Title Window and whole skin color change shape does'nt matter.
If any Body have any Idea. Please Tell Me
Muhammad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
|
|
|
|
|
Muhammad Waqas Butt wrote:
Muhammad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
What was your email address ?
Basically, make all your controls owner drawn, and get the paths to the images to draw on them from a config file.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Thanks for help.
My E-mail Address is : waqasb4all@yahoo.com
But how we do this to form title bar (Close,Minimize and Maximize Buttons) Shape.?
I mean as Stlye Xp do different theme in our windows xp change Folder Title bar colors and stlye.
Do you have any example to do in C# or VB.Net?
I just do to form title bar other controls does not matter.
Please Help me. and again thanks for your help.
Muhammad Waqas Butt
waqasb4all@yahoo.com
Muhamad Waqas Butt
waqasb4all@yahoo.com
|
|
|
|
|
make FormborderStyle = none
make your own title bar and place images the way it should look like .
|
|
|
|
|
Ya i know this thing but in this we create close and other title bar button too. I mean Title has default controls but color title bar color change as we do in Windows Xp we can change title bar font, color etc in the properties box.
May be i never got your point i send you an url you visit this and then tell me.
http://www.skincrafter.com[^]
Muhamad Waqas Butt
waqasb4all@yahoo.com
|
|
|
|
|
I have checked the site well if you found any free control for this type of design do let me know
my mail is rbashir@alm-soft.com
thanks and best of luck
|
|
|
|
|
Let say we have a class 'car' and it has an attribute 'color'. We can easly create 2 instance of car and set their color as:
Dim car1 as New Car
Dim car2 as New Car
car1.color = "red"
car2.color = "blue"
However if we need to create many instances of car then this method is limited. I want to write a procedure which can receives the name of instance and the color as parameters and then creates the instance and set the color.
Private Sub xyz(insName As string, colName as String)
dim insName as New Car
insName.color = colName
End Sub
|
|
|
|
|
Dim insName As New Car will not work.
Typically what you do in this scenario is create a collection of Car objects and then retrieve the instance you want by a key string value.
Dim colCars As New Collection
Private Sub CreateNewCar(ByVal colName As String, ByVal Key As String)
Dim oCar As New Car
oCar.Color = colName
colCars.Add(oCar, Key)
End Sub
Then retrieve an instance by
Dim oCar As Car
oCar = colCars(Key)
etc.
|
|
|
|
|
Use a parameterized constructor:
Public Class Car<br />
<br />
Private Color as String<br />
<br />
Public Sub New()<br />
'default constructor<br />
End Sub<br />
<br />
Public Sub New(colName as String)<br />
'parameterized constructor<br />
Me.Color = colName<br />
End Sub<br />
<br />
End Class
Do a Google search on Constructors for more information.
|
|
|
|
|
Hi guys,
Can someone help me? I need to open a temporary text file and put some numbers in it for another app to read.
This third-party app will delete my temporary file upon reading it.
The trick is, how do I stop him from deleting my file until I finish writing the complete number? Is there anyway I can "lock" until i use FileClose() command?
Please adivise...
Thanks...
|
|
|
|
|
The FileOpen() method should set the OpenShare parameter to OpenShare.LockReadWrite by default so other processes cannot delete the file before the FileClose().
From .NET help:
Public Sub FileOpen( _<br />
ByVal FileNumber As Integer, _<br />
ByVal FileName As String, _<br />
ByVal Mode As OpenMode, _<br />
Optional ByVal Access As OpenAccess = OpenAccess.Default, _<br />
Optional ByVal Share As OpenShare = OpenShare.Default, _<br />
Optional ByVal RecordLength As Integer = -1 _<br />
)
e.g.
<br />
FileOpen(1, "TESTFILE", OpenMode.Output, OpenAccess.Write, _<br />
OpenShare.LockReadWrite)
Are you opening and closing the file only once, or after each number is written?
...Steve
|
|
|
|
|
hi i need motion detection program in visual basic 6
i need program motion detection from webcam and
motion detection from my tv card
|
|
|
|
|
Sorry, we don't just give a completed apps away here.
The mission here at CP is to help you with code you write.
Try Google if you're looking for complete apps -> "vb6 motion detection"[^]
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This is going to sound stupid to you, but iv'e only just started programming (a few hours ago, just playing around, no books)
anyway,
I'm trying to change the enabled property of a textbox when there is input,
I'm using the following, and the enabled property of the button is set to false at design time.
<code>Private Sub btnlogin_EnabledChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnlogin.EnabledChanged
If txtpassword.Text = "" Then
btnlogin.Enabled = False
Else
btnlogin.Enabled = True
End If</code>
Please help me
Thanks
|
|
|
|
|
Hi,
Guess you should use the use the textchanged on the textbox setting the enable property on the btnlogin instead of using the enabledchanged on the button, as this would require the button property to change before the code is executed
Cheers
DJ
Think, try, think, think, try, think, think, think, try, ASK, think, try, advance on step and start over...
|
|
|
|
|
"I'm trying to change the enabled property of a textbox when there is input"...???
Private Sub txtpassword_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged
If txtpassword.Text = "" Then
btnlogin.Enabled = False
Else
btnlogin.Enabled = True
End If
End Sub
|
|
|
|
|
Thanks. That worked great
|
|
|
|