command line - Visual Basic Discussion Boards

devil66616-Jul-02 9:22

16-Jul-02 9:22

hi i want to draw a graph with respect to date.. soif there is a control for this please let me kno and also tell me some way that i can draw this without the control
regards

Re: drawing a graph in vb.net

Slim Shady20-Jul-02 8:56

Slim Shady

20-Jul-02 8:56

there is a control...... MSCHART.OCX if i remember correctly.... have fun

Problem with TextBox

Pradhip15-Jul-02 11:18

Pradhip

15-Jul-02 11:18

HI Folks

i use a text box for my applicationa nd am right nowhaving 2 problems that i need to address.

1). Whenever that text box gains focus for user to input data the cursor goes and stands right in the middle of the first line,While i want it to stand at the extreme left ahnd top corner.Now what property of the textbox do i need to meddle with to get what i want.i tried so many things but nothing seems to work.

2). when i use the ' symbol in my data input inside the text box like say "I've a good car" im not able to input data inside the databse becos of the "'" symbols importance in a database.now how do i overcome it.do i ahve to search for every text in my text box for that occurence and change it to something else??

Regards
Pradhip Swaminathan

Why Need Parking lots in Bars when Drunken Driving is Prohibited

Re: Problem with TextBox

Richard Deeming16-Jul-02 6:17

Richard Deeming

16-Jul-02 6:17

Try this in the Focus event: TextBox1.SelectionStart = 0 and TextBox1.SelectionLength = 0
(In VB6, these are called SelStart and SelLength)
sValue = TextBox1.Text.Replace("'","''"),
or in VB6, sValue = Replace(TextBox1.Text, "'", "''")

HELP!!!! ComboBox

MFC is the Best15-Jul-02 10:32

MFC is the Best

15-Jul-02 10:32

Hello!

I want to programm a ComboBox in Excel. My problem:

How can I get a text in the dropdown-list from the ComboBox ?????

MFC is the Best

Re: HELP!!!! ComboBox

SHaroz16-Jul-02 10:17

SHaroz

16-Jul-02 10:17

try this:

Dim myCB As CommandBarComboBox
Set myCB = EXLapp.CommandBars(myComBarIndex).Controls.Add(msoControlComboBox)
myCB.AddItem ("Item1")
myCB.Text = "select an item"
Set myCB = Nothing

reply if you have any questions

Re: HELP!!!! ComboBox

MFC is the Best16-Jul-02 12:04

MFC is the Best

16-Jul-02 12:04

Thank you very much!

Rose | [Rose]

MFC is the Best

command line

Unplugged15-Jul-02 6:33

Unplugged

15-Jul-02 6:33

Is there anyway that I can pass a variable into a vb program when I call it. I want to do something like

vbprogram.exe textfile.txt

but I don't know how to receive the variable and stuff in the vb program.
Cry | :((

I know in C it's argsv. any help would be great. Big Grin | :-D

ICXC
NIKA

Re: command line

sultan_of_6string15-Jul-02 7:28

sultan_of_6string

15-Jul-02 7:28

The default VB projects normally create Sub Main(), kinda like void main() in C++. Well, just like in C++, there are other "versions" of the main function:

Sub Main(ByVal CmdArgs() As String)
Function Main() As Integer
Function Main(ByVal CmdArgs() As String) As Integer

Just replace the default with the one you need.

Re: command line

Jeremy Falcon15-Jul-02 7:40

Jeremy Falcon

15-Jul-02 7:40

There's also the Command object. And, you can access it from anywhere in the program. It's a string containing what was passed on the command line after the executable's filename. It's up to you to parse it.

Try this...

MsgBox """" & Command & """"

Then, compile it into an exe and run it from the command line passing whatever you want.

Jeremy Falcon
Imputek

<nobr>"The happy people are those who are producing something; the bored people are
those who are consuming much and producing nothing." - William Ralph Inge

How can i create timeline

Mustafai15-Jul-02 0:25

Mustafai

15-Jul-02 0:25

hi
any1 have idea how too create Timeline
on the basisc of date
using VB.Net...or creating Graphs in Vb.net

Transfering Files/Folder over a network (LAN)

Birdy14-Jul-02 19:57

Birdy

14-Jul-02 19:57

i am having prb in Transfering Files/Folder over a network (LAN). i have to transfer my files from my server on the workstations of the lan .
FTP should be the choice / Winsock.
pls tell me abt it

Work Hard and Test your Luck

Re: Transfering Files/Folder over a network (LAN)

devil66614-Jul-02 23:44

devil666

14-Jul-02 23:44

check out these three links .. i hope ya get wat ya want.. Wink | ;)

http://www.15seconds.com/issue/981203.htm

http://www.acky.net/vb/vbtcp/index2.sht

http://www.vb2themax.com/HtmlDoc.asp?Table=Articles&ID=520

VB code problem - string

Member 4167514-Jul-02 18:27

Member 41675

14-Jul-02 18:27

Having a problem with the following code:

DoCmd.OpenReport "Print - IncompleteMemosbyTeamLeader", acViewPreview,, _
"RequestTo = 'Tod O'Dell'"

Only recognises the String as Tod O instead of Tod O'Dell. Can someone please suggest a way to overcome this. I'm not a VB coder. I'm unfamiliar with VB. I assume you could declare Tod O'Dell as a string as would in C++ and use the VariableName. e.g.

C++ Example
String VariableName = "Tod O'Dell";

Your help would be greatly appreciated Smile | :)

Nathan Browne

Re: VB code problem - string

Ravi_Shankar14-Jul-02 21:27

Ravi_Shankar

14-Jul-02 21:27

Hi,

In the criteria, put it in a variable and use Replace function to replace the single quote found with 2 single quotes. Please find an example below to use the same with SQL Server.

Dim sSql As String
Dim sName As String

sName = "O'Leary"
sName = Replace(sName, "'", "''")

sSql = "Select * from authors where au_lname = '" & sName & "'"
Debug.Print sSql

Try executing the output of the above SQL statement in Query Analyser under Pubs database...

Ravi Shankar S
Programmer Analyst
iSOFT R&D Pvt Ltd
Chennai, INDIA
Ph: 91-44-4414980 Extn 1103

Re: VB code problem - string

Ravi_Shankar14-Jul-02 21:31

Ravi_Shankar

14-Jul-02 21:31

Hi,

You can use the Replace function to replace a single quote with 2 single quotes...

Consider the following example:

sName = "Tod O'Dell"
sName = Replace(sName, "'", "''")

DoCmd.OpenReport "Print - IncompleteMemosbyTeamLeader", acViewPreview,, _
"RequestTo = '" & sName & "'"

Hope this helps you...

Ravi Shankar S
Programmer Analyst
iSOFT R&D Pvt Ltd
Chennai, INDIA
Ph: 91-44-4414980 Extn 1103

Re: VB code problem - string

James T. Johnson14-Jul-02 22:07

James T. Johnson

14-Jul-02 22:07

As Ravi_Shankar pointed out (but not so clearly) the problem is that databases use single quotes (or apostrophes; your pick) to delmit the boundries of a string.

In order to support the use of single quotes/apostrophes in a string the SQL specification says that a double-single quote/apostrophe '' is used (not ").

So rather than the last line being
"RequestTo = 'Tod O'Dell'" you need to make it
"RequestTo = 'Tod O''Dell'" (note the use of the dobule-apostrophe)

Hope that is a bit clearer for you Smile | :)

James
"Java is free - and worth every penny." - Christian Graus

getting the user information

devil66613-Jul-02 10:24

devil666

13-Jul-02 10:24

hi!!
i want to retirieve the user information currently logged on to the system...
the inforamtion whihc i want to reitrieve is

group to which the user belongs
comlete name

this inforamtin is in actie directory so i have to get this from active directory..
would any1 guide me how to do this in vb.net
regards

Re: getting the user information

Ravi_Shankar14-Jul-02 19:31

Ravi_Shankar

14-Jul-02 19:31

Hi,

You can use the Environment Class to get the details... Please find the sample as follows:

MessageBox.Show("Machine Name: " & Environment.MachineName())
MessageBox.Show("Domain Name: " & Environment.UserDomainName())
MessageBox.Show("Logged on User Name: " & Environment.UserName())

Ravi Shankar S
Programmer Analyst
iSOFT R&D Pvt Ltd
Chennai, INDIA
Ph: 91-44-4414980 Extn 1103

Re: getting the user information

devil66614-Jul-02 23:42

devil666

14-Jul-02 23:42

thx for the reply but this environment class doesnot provide me the facility to know the group of currently logged on user.. which is the most important information about the user as far as i am concerned.. so plz hep me out..

Using MSHTML Advanced Hosting Interfaces

Gene Sivorot13-Jul-02 9:00

Gene Sivorot

13-Jul-02 9:00

Can anyboday port the code in the Using MSHTML Advanced Hosting Interfaces example to VB.Net? The example is under Home >> C# Programming >> COM Interop or http://www.codeproject.com/csharp/advhost.asp. I can't get it to work in VB.Net.

Thanks

VB 6.0 and excel 2k interaction.

patty13-Jul-02 2:03

patty

13-Jul-02 2:03

I have written 1 app which creates new excel workbook and writes into it.But ,I was not able to do so with existing excel workbook.

How should I open existing excel sheet in vb6.0 ?

I want to write data into workbook having macros.

should I use MS excel driver ?

Thanks,
Amit

Re: VB 6.0 and excel 2k interaction.

Toni Monte OLD13-Jul-02 2:58

Toni Monte OLD

13-Jul-02 2:58

Hello,

Try the next code:

' Variables...
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

' Excel, Book and Sheet instantiation...
Set xlApp = CreateObject("Excel.Application")
Set xlBook = xlApp.Workbooks.Open(App.Path & "\Book1.xls")
Set xlSheet = xlBook.Worksheets(1)

With that code you can access to a existing sheet in a XLS file.

The DLL you have to use is 'Microsoft Excel XX Library' (in the references section of VB6).

Bye.

Re: VB 6.0 and excel 2k interaction.

patty13-Jul-02 4:01

patty

13-Jul-02 4:01

hey ...thanks for ur quick help !!!!

Getting the path of the current dll

Anonymous Programmer11-Jul-02 5:25

Anonymous Programmer

11-Jul-02 5:25

How do I get the path of the currently executing dll? Sample code, please.
Thanks.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.