Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.basic.visual.misc > #1707 > unrolled thread

visual studio controls

Back to article view | Back to comp.lang.basic.visual.misc

Contents

  visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-20 14:52 -0800
    Re: visual studio controls Karl E. Peterson <karl@exmvps.org> - 2013-02-20 15:21 -0800
    Re: visual studio controls "Auric__" <not.my.real@email.address> - 2013-02-21 01:23 +0000
    Re: visual studio controls GS <gs@somewhere.net> - 2013-02-20 22:46 -0500
    Re: visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-21 01:17 -0800
    Re: visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-21 01:20 -0800
    Re: visual studio controls Deanna Earley <dee.earley@icode.co.uk> - 2013-02-21 09:28 +0000
      Re: visual studio controls GS <gs@somewhere.net> - 2013-02-21 13:07 -0500
    Re: visual studio controls colmkav <colmjkav@yahoo.co.uk> - 2013-02-21 11:10 -0800
      Re: visual studio controls GS <gs@somewhere.net> - 2013-02-21 14:22 -0500
      Re: visual studio controls ralph <nt_consulting@yahoo.com> - 2013-02-21 13:43 -0600
      Re: visual studio controls "DaveO" <djo@dial.pipex.com> - 2013-02-22 09:55 +0000

#1707 — visual studio controls

Hi, I am trying to convert an old VBA project that uses an Excel Workbook as the user interface. I want to replace the interface with a VB.net project using VB.net controls instead. which would be the best control to use in my application?

My current spreadsheet has a start button and a list of jobs with a check box for each specifying whether the job is to be run or not.

[toc] | [next] | [standalone]

#1708

colmkav brought next idea :
> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as 
> the user interface. I want to replace the interface with a VB.net project 
> using VB.net controls instead. which would be the best control to use in my 
> application?

"Self-", I'd have to say.  WTH would you want to do that?

-- 
.NET: It's About Trust!
http://vfred.mvps.org

[toc] | [prev] | [next] | [standalone]

#1709

colmkav wrote:

> Hi, I am trying to convert an old VBA project that uses an Excel
> Workbook as the user interface. I want to replace the interface with a
> VB.net project using VB.net controls instead. which would be the best
> control to use in my application?

Depending on exactly what you're trying to do, you could probably just use a 
DataGridView control.

> My current spreadsheet has a start button and a list of jobs with a
> check box for each specifying whether the job is to be run or not. 

This group is almost entirely people who are using pre-.Net VB (i.e. VB6 and 
older). For future .Net questions, you could *try* asking here:

  microsoft.public.dotnet.languages.vb

...but that group is pretty dead nowadays.

-- 
This world is mine, in time.

[toc] | [prev] | [next] | [standalone]

#1710

colmkav explained on 20/02/2013 :
> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as 
> the user interface. I want to replace the interface with a VB.net project 
> using VB.net controls instead. which would be the best control to use in my 
> application?
>
> My current spreadsheet has a start button and a list of jobs with a check box 
> for each specifying whether the job is to be run or not.

You could use a 3rd party spreadsheet control if you need spreadsheet 
features/functionality. If not then a grid control as _Auric suggests.

I bought Farpoint's Spread.ocx ActiveX control back when MS released 
the Ribbon so I could make all my Excel-based apps standalone Windows 
apps using VB6. It works great! (Farpoint is now GrapeCity, and they do 
have a dotnet version of the control. It's not cheap!!)

In addition to Karl's comment, I can't imagine why you'd want to go 
with dotnet if you're already familiar with VBA since dotnet's an 
entirely different language (despite name similarities). VB6 is as 
close as you'll get to VBA, and most all of the code is portable beteen 
the two!

I went back to Excel-based apps because that's what clients wanted 
(popularity rules in the corporate world), so I've settled on combining 
VB6 and Excel via automation. I still use my Spread.ocx for proprietary 
projects, though.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

[toc] | [prev] | [next] | [standalone]

#1711

On Wednesday, February 20, 2013 10:52:31 PM UTC, colmkav wrote:
> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as the user interface. I want to replace the interface with a VB.net project using VB.net controls instead. which would be the best control to use in my application?
> 
> 
> 
> My current spreadsheet has a start button and a list of jobs with a check box for each specifying whether the job is to be run or not.

thanks for the responses. The reason why I am doing it in VB.NET is because I am trying to learn VB.NET in order to improve my skill set so I have more employment opportunities. 

[toc] | [prev] | [next] | [standalone]

#1712

On Wednesday, February 20, 2013 10:52:31 PM UTC, colmkav wrote:
> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as the user interface. I want to replace the interface with a VB.net project using VB.net controls instead. which would be the best control to use in my application?
> 
> 
> 
> My current spreadsheet has a start button and a list of jobs with a check box for each specifying whether the job is to be run or not.

btw, is there any good side you can recommend for example applications which I can look at to see what choices are made for such decisions ie choosing which controls to implement for certain situations?

[toc] | [prev] | [next] | [standalone]

#1713

On 20/02/2013 22:52, colmkav wrote:
> Hi, I am trying to convert an old VBA project that uses an Excel
> Workbook as the user interface. I want to replace the interface with
> a VB.net project using VB.net controls instead. which would be the
> best control to use in my application?
>
> My current spreadsheet has a start button and a list of jobs with a
> check box for each specifying whether the job is to be run or not.

As I'm already damned to hell, I might as well say:
Use a ListView with the CheckBoxes property set to true.

I expect the other grid controls also have a similar property.

-- 
Deanna Earley (dee.earley@icode.co.uk)
iCatcher Development Team
http://www.icode.co.uk/icatcher/

iCode Systems

(Replies direct to my email address will be ignored. Please reply to the 
group.)

[toc] | [prev] | [next] | [standalone]

#1714

Deanna Earley explained :
> As I'm already damned to hell, I might as well say:
> Use a ListView with the CheckBoxes property set to true

I wish I thought of that (or a listbox)!<g> It certainly makes for a 
simple solution.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

[toc] | [prev] | [next] | [standalone]

#1715

On Wednesday, February 20, 2013 10:52:31 PM UTC, colmkav wrote:
> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as the user interface. I want to replace the interface with a VB.net project using VB.net controls instead. which would be the best control to use in my application?
> 
> 
> 
> My current spreadsheet has a start button and a list of jobs with a check box for each specifying whether the job is to be run or not.

thanks, I have chosen the listview. 

A follow up question: I am conceptually trying to think what I should do in order to keep the results of the form somehow. When I used an Excel workbook as the interface I would store values such as the time the job was run etc. In Excel, it was simply a case of saving the workbook to keep these details of the last run but how would I do this with a form?

[toc] | [prev] | [next] | [standalone]

#1716

colmkav presented the following explanation :
> On Wednesday, February 20, 2013 10:52:31 PM UTC, colmkav wrote:
>> Hi, I am trying to convert an old VBA project that uses an Excel Workbook as 
>> the user interface. I want to replace the interface with a VB.net project 
>> using VB.net controls instead. which would be the best control to use in my 
>> application?
>> 
>> 
>> 
>> My current spreadsheet has a start button and a list of jobs with a check 
>> box for each specifying whether the job is to be run or not.
>
> thanks, I have chosen the listview. 
>
> A follow up question: I am conceptually trying to think what I should do in 
> order to keep the results of the form somehow. When I used an Excel workbook 
> as the interface I would store values such as the time the job was run etc. 
> In Excel, it was simply a case of saving the workbook to keep these details 
> of the last run but how would I do this with a form?

I use a delimited text file with field names in the 1st line. This lets 
me dump the data into an array OR use ADODB recordset. In the case of 
using the aforementioned Spread.ocx, it imports the data directly. 
Using the listview you'd need to populate columns with a For...Next 
loop since that's not a grid control.

-- 
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
  comp.lang.basic.visual.misc
  microsoft.public.vb.general.discussion

[toc] | [prev] | [next] | [standalone]

#1717

On Thu, 21 Feb 2013 11:10:43 -0800 (PST), colmkav
<colmjkav@yahoo.co.uk> wrote:


>
>A follow up question: I am conceptually trying to think what I should do in order
> to keep the results of the form somehow. When I used an Excel
> workbook as the interface I would store values such as the time the
> job was run etc. In Excel, it was simply a case of saving the
> workbook to keep these details of the last run but how would I do
> this with a form?

There are several methods... (in addition to GS's advice)

1) Use SaveSettings - save to registry
2) Store the values in "hidden" cells
3) Store in Public Declarations
4) Set the Control values as the default values

And probably a few others I can't think atm. <g>

[toc] | [prev] | [next] | [standalone]

#1718

"colmkav" <colmjkav@yahoo.co.uk> wrote in message 
news:6a416320-d9ed-441d-847d-957340be3724@googlegroups.com...
On Wednesday, February 20, 2013 10:52:31 PM UTC, colmkav wrote:
>> Hi, I am trying to convert an old VBA project that uses an Excel Workbook 
>> as the user interface. I want to replace the interface with a VB.net
>>project using VB.net controls instead. which would be the best control to 
>>use in my application?

>> My current spreadsheet has a start button and a list of jobs with a check 
>> box for each specifying whether the job is to be run or not.

>>thanks, I have chosen the listview.

>A follow up question: I am conceptually trying to think what I should do in 
>order to keep the results of the form somehow. When I used an >Excel 
>workbook as the interface I would store values such as the time the job was 
>run etc. In Excel, it was simply a case of saving the >workbook to keep 
>these details of the last run but how would I do this with a form?

Hi

This simple function will make a string with which can then be saved to 
disc.
I'll leave you to work out the reverse needed to load it back to a LV.

Public Function ReadLV(LVName As ListView) As String
Dim x_Cell     As Integer
Dim y_Cell     As Integer

With LVName
  For y_Cell = 1 To .ListItems.Count
    ReadLV = ReadLV & .ListItems(y_Cell).Text
    For x_Cell = 1 To .ColumnHeaders.Count - 1
      ReadLV = ReadLV & vbTab & .ListItems(y_Cell).SubItems(x_Cell)
    Next
    ReadLV = ReadLV & vbCrLf
  Next
End With
End Function

If it's a really long list or one that has a lot of columns, you'll probably 
want to modify it to use a stringbuilder of some kind.

Regards
DaveO. 

[toc] | [prev] | [standalone]

Back to top | Article view | comp.lang.basic.visual.misc

csiph-web