|
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
|
|
|
|
|
Kind of. I really wouldn't do it this way, but whatever works for you.
|
|
|
|
|
give me some example how to do this
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
The DatePicker control allows you to do that, you just have to play around with its properties.
|
|
|
|
|
Thanks this is exactly what I was looking for
asp
|
|
|
|
|
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;"
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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 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]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
+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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
I am getting old and can't follow the math any more 
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.
|
|
|
|
|
Well, it could be done, but the image is still going to be skewed and look funny, but the circles will look just like circles.
Wouldn't it be faster to setup the dart board again and put the camera on a tripod and raise it so the center of the lens is the same height as the bullseye??
|
|
|
|
|
Sounds good but most of the darts will hit the camera 
|
|
|
|
|
Hi Friend,
I am using MSAccess database and VB Data Environmental datareport(vb datareport)
i don't have serial number as a field in the database table.
But in VB Data Environmental datareport(vb datareport)
i need to display serial number.
That report will display only one person's information.how to give that serail number. Here is my sample database table.
Nam id feename amt
----------------------------------
AAA 11 Tution1 100
AAA 11 Tution2 100
AAA 11 Tution3 100
BBB 12 Tution1 100
BBB 12 Tution2 100
BBB 12 Tution3 100
BBB 12 Tution4 100
CCC 13 Tution1 100
CCC 13 Tution2 100
CCC 13 Tution3 100
DDD 14 Tution1 100
DDD 14 Tution2 100
Kindly help me.
Expectd Output in DataReport is
Sno Nam id feename amt
----------------------------------------
1 AAA 11 Tution1 100
2 AAA 11 Tution2 100
3 AAA 11 Tution3 100
----------------------------------------
Sno Nam id feename amt
----------------------------------------
1 BBB 12 Tution1 100
2 BBB 12 Tution2 100
3 BBB 12 Tution3 100
modified 29-Feb-12 5:12am.
|
|
|
|
|
If you mean adding record numbers to a report here is an article that may help:
Counting in reports[^]
|
|
|
|
|
It is working in ms access datareport but am asking about VB Data Environmental datareport(vb datareport)
modified 29-Feb-12 23:41pm.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
