Visual Basic

Luc Pattyn3-Mar-12 13:05

Luc Pattyn

3-Mar-12 13:05

My idea exactly, but then I didn't want to reply that, as it sounds a bit like "I really don't know"...

Laugh | :laugh:

Luc Pattyn [My Articles] Nil Volentibus Arduum

Dave Kreskowiak3-Mar-12 14:09

3-Mar-12 14:09

Really, it's the only reliable way to do it. Actually, I'd try using ACE.12 first, then downgrade to 4.0.

You could start check the version of Office that's installed, but then some application could have installed one of the Access Runtimes and making the detection code inaccurate.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Luc Pattyn3-Mar-12 14:26

Luc Pattyn

3-Mar-12 14:26

I fully agree; even if I knew a way to determine something like that, I'd probably go for the functional test anyway. With external dependencies involved, I prefer to eat the pudding, rather than to look for the boxes.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Dave Kreskowiak3-Mar-12 15:06

3-Mar-12 15:06

Luc Pattyn wrote:
I prefer to eat the pudding, rather than to look for the boxes.

I haven't heard that one before. That's a good one.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

ivo755-Mar-12 2:05

5-Mar-12 2:05

what You mean? This

Public Sub ConnectToAccess()
    Dim conn As New System.Data.OleDb.OleDbConnection()
     conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & databasePath.dbPath & ";Persist Security Info=False;"

        Try
       conn.Open()
       .......
    Catch ex As Exception
       conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & databasePath.dbPath & ";User ID=Admin;Password="
    conn.Open()
........
    Finally
       conn.Close()
    End Try
End Sub

Dave Kreskowiak6-Mar-12 5:43

6-Mar-12 5:43

Kind of. I really wouldn't do it this way, but whatever works for you.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

ivo756-Mar-12 6:08

I would like to create a textbox where I can input hour and minute.

6-Mar-12 6:08

give me some example how to do this

AlainStP3-Mar-12 6:54

AlainStP

3-Mar-12 6:54

I am trying to figure out how to create a textbox, or another component where the user can click up and down to change the time (hours and minutes).

Like the one we use in windows when we need to change the hour/minute of our OS.

Thanks again

asp

Re: I would like to create a textbox where I can input hour and minute.

Dave Kreskowiak3-Mar-12 7:26

Re: I would like to create a textbox where I can input hour and minute.

3-Mar-12 7:26

I've never made one, but you could easily do this with a custom UserControl. A few textboxes and a couple of buttons should do it.

HourTextBox : MinuteTextBox : SecondsTextBox AmPmTextBox  UpButton
                                                          DownButton

Shouldn't be hard to figure out what to put in the Up/Down Button click handlers. You'll probably also handle the MouseDown/MouseUp events on those if the user wants to change the numbers without clicking for each increment.

Then the UserControl just exposes the time as a property. The gettor just puts a datetime object together based on the values in the textboxes. The settor does the opposite.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Shameel3-Mar-12 7:46

Shameel

3-Mar-12 7:46

The DatePicker control allows you to do that, you just have to play around with its properties.

Re: I would like to create a textbox where I can input hour and minute.

AlainStP3-Mar-12 8:24

AlainStP

3-Mar-12 8:24

Thanks this is exactly what I was looking for

asp

DB connection string

ivo752-Mar-12 18:36

2-Mar-12 18:36

Can I use same DB connection string to connect to MS Access 2003 and MS Access 2007? I use this "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & databasePath.dbPath & ";Persist Security Info=False;"

Re: DB connection string

Wayne Gaylard2-Mar-12 20:38

Wayne Gaylard

2-Mar-12 20:38

Yes, it is possible to use the OLE DB provider for the Microsoft Office 12.0 Access Database Engine for both 2003 and 2007 versions of Access, although it is not possible to use the Jet 4.0 OLE DB engine for Access 2007 databases.

Hope this helps

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

Re: DB connection string

ivo753-Mar-12 8:17

3-Mar-12 8:17

I want to connect without install Microsoft Office 12.0 Access Database Engine in the client mashine, because my program is 2MB, but Microsoft Office 12.0 Access Database Engine is 26MB.

modified 3-Mar-12 14:29pm.

Calling all vber’s

User-57756572-Mar-12 10:55

User-5775657

2-Mar-12 10:55

I am sick and tired of the relentless bagging of the VB language by other languages. I hear it in your comments vber’s, well I know I’m writing in vb but?

You’re given up demanding VB code examples be given and submitting to the blogs hate messages, VB is dead. Stop being brainwash by other languages that we are inferior. The other languages have come to VB land not us to theirs, those who deny us the vb code samples are other language leaders.

The .net engine is designed to incorporate several languages into VB land not the other way round. The VB team has done a great job and we are better.

Squiggly brackets is like the days when man ate with his hands, come on we have spoons and forks, catch up already.

Some history
Our VB King was the trailblazer that made the brand the best in the world and while you other languages gasp and you feel your blood pressure spiral, that’s how I feel every time I see negative comments about my language.

But lets have a look at the success of the VB Hive since the integration, over ten years ago our VB King shook a tablet at us and told us that this was the future, but what happen since our king let other languages leaders to rule our code world! We have been scrabbling to keep up with everyone else.

Under the C# watch we have miss major events, oh I don’t know like, mobile phones, the tablet just to name a major few.

VB land under the King has change from leaders to followers under the C# leaders.

VB land has grown to accommodate other languages and they have shaken their code bible at us for too long, telling us that they will dominate us to their language and beliefs.

I see that C# is become the mess that JavaScript is with 100 ways to do the same thing, lesson here for the VB team don’t simulate.

Be proud vber’s we are the indigenous coders and are the westernized world and not let third world languages make us feel bad to admit we are Vber’s

I agree

David Mujica2-Mar-12 11:06

David Mujica

2-Mar-12 11:06

I make a good living developing VB.NET code. I'm kind of forced into using it because the application which I support is developed in VB.NET, but I find nothing wrong with it.

I've been coding for a long time (20+ years) and used lots of languages over the years, each with its own strengths. So far, I haven't found anything that I couldn't do in VB.NET

My 2 cents.
Rose | [Rose]

Mycroft Holmes2-Mar-12 12:52

Mycroft Holmes

2-Mar-12 12:52

Have my 5 for an excellent and justified rant.

Having said that I have to devise a strategy to move all our VB devs to C#, not because of any perceived differences in the languages but the volume of support and resources and the need to standardise our development platform.

Never underestimate the power of human stupidity
RAH

Dave Kreskowiak2-Mar-12 14:08

2-Mar-12 14:08

It's a nice rant, but you're pissing into the wind. The abuse VB.NET, inherited, will never end because VB is more verbose than most languages.

Myself, I don't give a crap either way. I get paid the same whether the code I write is in C/C++, C#, VB.NET, VBscript, or whatever.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Wayne Gaylard2-Mar-12 20:31

Wayne Gaylard

2-Mar-12 20:31

+5 for a good rant. I coded in VB and VB.Net for years, and even though I now use C# almost exclusively, I still keep up to date with developments in the VB world. There sure is nothing wrong with VB.Net, and is definitely not inferior to C# in any way.

When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman

Simon_Whale3-Mar-12 2:24

Simon_Whale

3-Mar-12 2:24

I have enjoyed developing in VB.NET for many years well since framework 2.0 and before / during uni I worked in vb with rdo.

but feel that your rant even though justified will only be heard by vb'ers as the age old flaming of vb against other languages has been around as long as vb 5 as long as I can remember.

but sadly I have had to suggest to my boss that we switch to c#, due to resources through the web (even thought converting them to vb isn't difficult) and recruitment of vb developers where I work is difficult to source

Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch

Create Bulleted Lists in MS Word using VB.Net

AlainStP3-Mar-12 7:08

AlainStP

3-Mar-12 7:08

I agree

A lot of people are starting and are using VB for it's ease of use, the enormous snippet, tutorial, documentation and help available out there. Microsoft has spend and still is spending tons of money to make this language more and more sophisticated.

Just remember Cobol back in the 80ies where programmer sware that this was the only good language for accounting purposes, where is it today? Dead!

VisualBasic has been around since 1991, and is stronger today that it never was. You can use it with all office application, and also autocad, sageaccpac to name a few with the derivative VBA.

You may not like pizza but it doesn't mean that pizza lover are idiots.

asp

Alain St-Pierre

Member 86935241-Mar-12 22:17

Member 8693524

1-Mar-12 22:17

I am creating an application which creates Ms Word document with specific formats, now i want to place/create bulleted lists
Example:
. This is a Sample Text 1
. This is a Sample Text 2
. This is a Sample Test 3

how will i do this....

Thanks

Re: Create Bulleted Lists in MS Word using VB.Net

Richard MacCutchan1-Mar-12 23:17

Richard MacCutchan

1-Mar-12 23:17

You already posted this question here[^]; please post in one forum only.

Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman

modified 2-Mar-12 5:56am.

Adjust Image Help :-) me do the impossible!

rderkis28-Feb-12 21:45

rderkis

28-Feb-12 21:45

I am getting old and can't follow the math any more Frown | :-(

What I am trying to do:
I have a jpg picture of a dart board. I loaded the picture into a picturebox. The picture was not taken directly in front of the dart board so the scoring rings are oblong. I want the user to perhaps click on four points (top bottom left right) of the outside scoring ring. The program would then transform(?) the whole image so the scoring rings are all round instead of oblong.
Please let me know if I did not make this clear enough. I am using vb 2010.
I know this is way beyond the programming abilities of even most expert programmers but any help would be appreciated!

If there is a dll or activex I could use please let me know.

Re: Adjust Image Help :-) me do the impossible!

Dave Kreskowiak2-Mar-12 3:53