Visual Basic Discussion Boards

First Prev Next

Re: Need help to add a VB shortcut(hotkey) key to function

Dave Kreskowiak20-Jul-09 4:19

Dave Kreskowiak

20-Jul-09 4:19

In addition to what nlarson said, move that code you want to call to its own sub instead of putting everything in the button handler. This will allow you to call the code from anywhere in the form without passing in arguments you don't have.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008
But no longer in 2009...

how to check is SQLServer2005 is installed on my m/c

koolprasad200319-Jul-09 21:06

koolprasad2003

19-Jul-09 21:06

hi there

i want to check that IS SqlServer2005 is installed on my machine ???

i am using VB6.0

how can i do that ?? Confused | :confused:

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: how to check is SQLServer2005 is installed on my m/c

Vimalsoft(Pty) Ltd19-Jul-09 22:48

Vimalsoft(Pty) Ltd

19-Jul-09 22:48

Really am not a Fan of VB6 and i dont know why you still use it. But here is an example of C#

http://blogs.msdn.com/sqlexpress/archive/2006/07/29/682254.aspx[^]

to convert between languages use the Following link http://converter.telerik.com/[^]

Remember this is not for vb6

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Upgrade Failure?

teknozwizard19-Jul-09 20:47

teknozwizard

19-Jul-09 20:47

Hi,

I'm new to the programming world, but not the computer world. Anyway, I've just recently downloaded Visual Basic 2008 Express Edition, and so far I love it. However, I came across an old source file that's opensource on SourceForge.net and downloaded it. I was trying to upgrade the Project1.vbp using the VB2k8 Express upgrade wizard when it told me that the upgrade failed because the mdlFormHandling.bas file was missing. The problem is, I went into the folder and looked and it's not missing. It's right there. I took some screenshots to show you if anyone could please, please, please, please help me. I'm just a lowly college kid! No money for the big guns yet! >.<

The Upload Error Screenshot - http://i927.photobucket.com/albums/ad117/teknozwizard/UpgradeError.jpg[^]

File is there Screenshot - http://i927.photobucket.com/albums/ad117/teknozwizard/Fileisthere.jpg[^]

Please help this newb!!!

Re: Upgrade Failure?

Johan Hakkesteegt19-Jul-09 21:20

Johan Hakkesteegt

19-Jul-09 21:20

By the look of it, the studio is looking for the file in a different place. Check the path in the error message, against the path that the bas file is actually in.

You may have to copy the file to the path mentioned in the error message.

My advice is free, and you may get what you paid for.

Re: Upgrade Failure?

teknozwizard20-Jul-09 4:04

teknozwizard

20-Jul-09 4:04

I've got and tried to track through that filepath and.....nothing. I've done a system wide search and I don't have a file labelled "VB98" to try and find and get into to follow the rest of the path. I'm completely at a loss here. I thought that maybe it was looking for a library I didn't have so I went online and downloaded the libraries for VB2k8EE from microsoft's website and installed them, but unfortunately, I'm still having the same trouble....I can't copy the file's into the location because the location it's looking for them in doesn't seem exist and I'm not even sure what the full filepath would be because it gets cut off with the "\...\...\...\VB98\" and etc...I thank you for your response though.

Re: Upgrade Failure?

Johan Hakkesteegt21-Jul-09 0:16

Johan Hakkesteegt

21-Jul-09 0:16

You could try to copy the entire folder with the project you want to upgrade, to another location (preferably a simple one like c:/temp/myproject/), and try and upgrade again from there.

My advice is free, and you may get what you paid for.

convert string to int?

veon cheng19-Jul-09 20:02

veon cheng

19-Jul-09 20:02

hi to all

this may sound stupid cause i'm new to VBA.
in C# we are able to write in this way if i'm not wrong

int n = Convert.Toint16(textbox.Text)<br />

but how to write in VBA ???

thanks
veon

Re: convert string to int?

Andy_L_J19-Jul-09 20:11

Andy_L_J

19-Jul-09 20:11

Dim n As Integer
n = CInt(textbox.Text)

I don't speak Idiot - please talk slowly and clearly

I don't know what all the fuss is about with America getting it's first black president. Zimbabwe's had one for years and he's sh*t. - Percy Drake , Shrewsbury

Driven to the arms of Heineken by the wife

Re: convert string to int?

veon cheng19-Jul-09 20:16

veon cheng

19-Jul-09 20:16

hi

i have try this code but it jus keep saying object required?

this is what i code

Sub Delete_Row_Excel_VBA()
Dim n As Integer
n = CInt(tbxRow.Text)
Rows(n).Select
Selection.Delete Shift:=xlUp
End Sub

Re: convert string to int?

Andy_L_J19-Jul-09 20:37

Andy_L_J

19-Jul-09 20:37

What is

<br />
<blockquote class="FQ"><div class="FQA">veon cheng wrote:</div>tbxRow.Text</blockquote><br />

Re: convert string to int?

veon cheng19-Jul-09 21:28

veon cheng

19-Jul-09 21:28

hi

tbxRow is the id of the textbox, i name it as tbxRow

thanks
veon

Re: convert string to int?

koolprasad200319-Jul-09 21:05

koolprasad2003

19-Jul-09 21:05

try to use
Val in the place of CInt

hope it helps.... Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Re: convert string to int?

veon cheng19-Jul-09 21:30

veon cheng

19-Jul-09 21:30

hi

thanks for replying, but its the same error

thanks
veon

Re: convert string to int?

Sebastian Br.19-Jul-09 21:43

Sebastian Br.

19-Jul-09 21:43

Are you sure your variable has any value?

Re: convert string to int?

veon cheng19-Jul-09 21:56

veon cheng

19-Jul-09 21:56

hi

thanks =)) its solved. as i run the code in macro it does not work but when i change it to a button it works =)) thanks for all the helps guys. Big Grin | :-D

anw can i have some comments, my boss wants me to programe a excel programe to help them generate report. do you think i should do in spreadsheet or forms. which one would be presentable and more interactive??

thanks
veon

Re: convert string to int?

Dalek Dave19-Jul-09 23:45

Dalek Dave

19-Jul-09 23:45

I have to do Excel VBA a lot.

I tend to use the Forms, sometimes just have a macro to call it.
(eg, Ctrl Q to call the form).
I find them easier and more adaptable.
Obviously for simple things like a column transfer or a set of create and save Sheets etc a Macro is easier, especially as you can use the recorder.

It really is a matter of choice, but I think the Forms a) look more professional, and b) imply you have done more work(even if you haven't), so it is better for workplace kudos.

------------------------------------

"When Belly Full, Chin Hit Chest"
Confucius 502BC

Re: convert string to int?

veon cheng20-Jul-09 15:47

veon cheng

20-Jul-09 15:47

hi
ok so form will be more ideal, but what will be the possible challeng that i will face. besides that is form able to read data from excel, as in use the spreadsheet as the data.

thanks
veon

Clarification

Dalek Dave20-Jul-09 22:09

Dalek Dave

20-Jul-09 22:09

Are you asking if the form can use data from the spreadsheet, manipulate it and then move it back to the same or different spreadsheet?

If so, then yes.

Something like ...

<br />
Dim Something as Int<br />
With ActiveWorkbook<br />
Sheets("Name of worksheet").Select<br />
Range ("A1").Select<br />
Something = Selection.Value<br />
Range ("B1").Select<br />
Selection.Value = Something<br />
<br />

Of course you can choose different sheets and manipulate the data or other things as required, this was just a simple example.

------------------------------------

"When Belly Full, Chin Hit Chest"
Confucius 502BC

Re: Clarification

veon cheng21-Jul-09 16:42

veon cheng

21-Jul-09 16:42

hi

ok thanks a lot realy thanks for the help and this is what i want thanks

thanks
veon Big Grin | :-D

code for passing username and password to crystal report?

KIDYA19-Jul-09 18:44

KIDYA

19-Jul-09 18:44

Hello Experts!!

I am developing crystal reports in vb.net and used MS Access as database having password security, when i want to view reports in project it asked for password of database.
Now i want to avoid that step, so what kind of coding required to pass username and password to crystal report?

show all columns from a combo box

Kevin Mitchel19-Jul-09 18:32

Kevin Mitchel

19-Jul-09 18:32

Hi Guys, is there a simple code that I can use. I have a database and I collect information using a query and I want to see all the columns that are in the query when I use a combo box drop down. I am a newbie to visual basic

Re: show all columns from a combo box [modified]

Andy_L_J19-Jul-09 20:09

Andy_L_J

19-Jul-09 20:09

You would use a datagridView...

Create a DataTable to hold the query results:

Dim dt As DataTable = New DataTable("MyTable")

Get the data from the database:

Dim conn as New SqlConnection(connString)
Dim sql as String = "SELECT * FROM SomeTable"
Try
  conn.Open()
  Dim cmd As New SqlCommand(sql,conn)
  Dim da As New SqlDataAdapter(cmd)
  da.Fill(dt)
  conn.Close()
  cmd.Dispose()
Catch ex As Exception
End Try

Assign the DataTable to the DataGridView Control's DataSource property:;

DataGridView1.DataSource = dt

...or something like that.

<edit -="" changed="" datagrid="" to="" datagridview="" cmd="" dt="" in="" sqldataadapter="" initialiser="" too="" many="" vb6="" questions="" around="" here...="">

modified on Monday, July 20, 2009 2:48 AM

Try and catch ???

veon cheng19-Jul-09 17:06

veon cheng

19-Jul-09 17:06

hi to all,

i would like to know whether VBA is able to perform try and catch, if there is. how am i suppose to code it

thanks
veon

Re: Try and catch ???

koolprasad200319-Jul-09 21:10

koolprasad2003

19-Jul-09 21:10

there is no try catch like .NET but u can use OnError goto

let's see with an example

Private Sub Command1_Click()
On Error GoTo ErrorHandler
Error 424 'This error is displayed when there is a missing object
Exit Sub
ErrorHandler:
MsgBox "Error Number: " & Err.Number & " With The Description ->> " & Err.Description & " <<- Occured."
End Sub

this is how you can handle exceptions, errors in VB6

hope it helps... Smile | :)

If the message is useful for U then please Rate This message...

Be a good listener...Because Opprtunity knoughts softly...N-Joy

Last Visit: 31-Dec-99 18:00 Last Update: 24-Sep-24 16:19

Refresh

ᐊ Prev 1...995 996 997 9989991000 1001 1002 1003 1004 Next ᐅ

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