|
Well, you've given us no details about what you want other than 'connect'. Besides, if you've already got the database done in Access and you've already written the VB code, what's the problem? You should have been testing the code against the database already...??
You can start with this[^] for a guide on how to connect to various data sources and use them.
Your connection string will probably look something like this:
Dim strConnect as String
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=C:\Documents and Settings\username\My Documents\dbFile.mdb"
RageInTheMachine9532
|
|
|
|
|
Thanks so much for the reply. And to give you a bit of details on the simple program that i have created, well, i usually used ADO as my mediator between my program and my database (connection). The program is working fine. But when i try to create the .exe file and run it to my computer at work, it won't run since it tries to seach for msstdfmt.dll and i can't just install the dll file cause my computer has admin rights and i don't have access on it. So, i'm wondering if i could connect my program to my database without using ADO and just use codes to have it connected.
|
|
|
|
|
Well, from what I can find, msstdfmt.dll is the Data Format object library. You could TRY recoding the app to use DAO, but I think without that file, you're out of luck as Access installs it when you install Office and I think no matter how you go about getting to the database, the Jet Database engine still needs this dll to do it's work.
RageInTheMachine9532
|
|
|
|
|
Thanks for the info. i really appreciate it. thanks again!;)
jjt
|
|
|
|
|
Try Planet-source-code.com
|
|
|
|
|
I want to be able to start my app (vb 6) by "throwing" a file on it (via sendto). When the app starts i want to catch the name of the file that triggered the application to start... Is this possible in vb 6...?
Or do I have to have my application running when "throwing" the file at it?
(I don't need to open or manipulate the file in any way: I just want to be able to catch the filename)
|
|
|
|
|
Simple, when that happens, your app gets launched with the full path and name of the file as it's command line parameter:
MyVBApp.exe C:\Documents and Settings\MyId\Desktop\TestFile.txt
All you have to do then is get the command line arguments from Command().
RageInTheMachine9532
|
|
|
|
|
RageInTheMachine, that was a peace of cake!
Thanks a lot!
|
|
|
|
|
I just added a .vbs file to my windows forms application. I was wondering how to invoke that vbscript from within my application.
Thanks.
|
|
|
|
|
let say i got 2 forms, form1 and form2, how i going to show form2 when i click one button in form1??
just like form2.show in vb6!! but i cant find that in vb.net!!
|
|
|
|
|
In the button click event handler in form1 create (or obtain) an instance of form2.
MyForm2.Show()
or
MyForm2.ShowDialog()
depending on how you want it to work.
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
Enumerators in .NET: See how to customise foreach loops with C#
|
|
|
|
|
thank you for replying me!
but i dunno how to create an instance of form2 in form 1!!
|
|
|
|
|
Dim MyForm2 as Form2
MyForm2 = New Form2()
MyForm2.Show()
[I'm not a VB/VB.NET programmer so I may have the syntax slightly wrong]
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
Enumerators in .NET: See how to customise foreach loops with C#
|
|
|
|
|
Dim frm As New Form2()
frm.ShowDialog()
|
|
|
|
|
Say if you want to display form1 from form2.
In the form2 create the instance of form1
- dim frm1 as new form1()
and then
frm1.show or frm1.showdialog will display the form
- Sunil
|
|
|
|
|
say suppose i want to develop a windows aplication that will connect a ms-access database over the internet using ado.net & vb.net
tbhattacharjee
|
|
|
|
|
I think you need ASP.NET web application for that not windows application unless you were to consider Web Service.
Sonork 100.41263:Anthony_Yio
|
|
|
|
|
at runtime i want to drag the column of datagrid but don't have knowledge now.please help me out and if it is possible then please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|
|
This is not possible in ASP.NET. You could inherit from the DataGrid control to and provide your own implementation (heavily augmented with a liberal amount of javaScript) to provide the functionality that you desire.
--Colin Mackay--
"In the confrontation between the stream and the rock, the stream always wins - not through strength but perseverance." (H. Jackson Brown)
Enumerators in .NET: See how to customise foreach loops with C#
|
|
|
|
|
say suppose i have datagrid with three column and one column having check box and 'n' no of rows are there.now i want to read the content of all the rows in a loop when no of rows is not fixed.how to do it using vb.net.if it is possible then please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|
|
please tell me how to create ms-access database and tables on fly using vb.net. if it is possible then please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|
|
i want to develop a small application that can connect to ms-access database,sql server and oracle.when user will connect to whatever database then the complete database structure will be shown like in a list all tables name will be added, in a another list box all stored procedures name will be shown and when user will select any table the total table structure will be diplayed in a list box and again when user will select any store procedure then that store precedure definition will be show in a text box.how can i do it using vb.net.if it is possible then please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|
|
say suppose i have datagrid having two column and 2nd column having check boxes in my vb.net window application. i want to know how can i detect how many check box is selected at run time.now i dont know please help me with easy sample code.
tbhattacharjee
|
|
|
|
|
Every one knows what is tree view and how it works but i want to know how can i change default[+ & -]icon and i want to set my [+ & -]icon with vb.net. so please tell me how can i do it.
tbhattacharjee
|
|
|
|
|
please give me small sample code to implement it using vb.net.
tbhattacharjee
|
|
|
|