I developed a custom help system for my ACCESS 2007 application using Help Workshop. I wish to open this .chm file by a command button on a form but does anyone know how to do that?
View 9 RepliesI have an application that has an Ms Access 2007 DataBase which runns great if access is installed. Is there any code that I can use in vb that I would be able to run access with out installing it.
View 5 RepliesI am writing a very simple program that connects to a accdb file (Microsoft Access 2007 file) and returns some results in a datagridview. Everything is fine. Now because we have to deploy this program in many computers i publish it so everyone we want can install it and have updates. What i wanted to do is to make the database file part of the program which i did it by adding it to the resources. My problem is that i do not know what connection string to enter in order to access it in my resources.
My previous connectionstring before i deploy it was this
ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:l.accdb;Persist Security Info=True
What should i change in the data source in order to access the same file in my resources?
I trying to create an application using vb 2010.This application handles booking of airline customers. i am using ms access 2007 where i have created a table that stores customer information and another that stores and updates seats available in different flying classes. Am trying to develop an interactive application in visual basic 2010 where customers can book. i want to add this data to the database in real time and communicate to customers the seats available,prices and so forth. In otherwards the application communicates with database and updates accordingly. Firstly how do i connect to my database? I tried ADO.net but seems better equiped to work with sql server which i have no idea how to use. Is there a tool that can make my interaction with the access seamless
View 1 RepliesI need to create a multi user VB.Net application that connects to Access 2007 and has 2 forms. How do I go about it?
View 4 RepliesSo i'm creating a simple application as an example that is to link to a Access 2007 database.
On my main form i have four listboxes that are correctly attached to the table, I have one for First Name, Last Name, Phone, and School. I added 3 records to the database in Access to see if I could display the records in the listboxes on the form. I found that it was very easy by setting the properties and I have no problem there. I also have a command button that loads a new form for the purpose of adding a record to the database.
Here is my main form (frmMain.vb)...
CODE:
And Here is the code for the form...
CODE:
What i'm looking for is when the user presses the Add button on the frmAddNew form then it needs to close and the new record is listed in the textboxes and saved to the database. Id also like to know all kinds of things i might be able to do with textboxes and databases because i'm trying to learn for a larger project where i'll need to keep track of hundreds of records.
I understand that this is a simple procedure, but i've been spending all night scouring tutorials and getting lost in the msdn library online, so maybe some human input will be better.
I am using VB 2008 & Access 2007 for windows forms application having typed datasets while creating connection to DB vb asks to store connection string so i did it now that i want to know where is the actual path of file where these connection strings are stored. b'cas after runnig a macro in Access Database i lost all these connections from Data Source Configuration Wizard Combo Box & also i am anable to create a new connection to Databases.I have tried to reinstall the entire Visual Studio couple of times .
View 17 RepliesIf I create a windows app which I link to an MS Access databse file that already exists..will I need to have MS Office installed on every computer at which I want to use the app? If not then how do I go about making a standalone windows app that will store information in a database of some form or another ?
View 1 RepliesI am creating a windows application using VB.net and I would like to know how I can go about creating a download button so that when the user clicks it, it is able to download the specific attachment from the attachment column in the database.
View 1 RepliesI have a CSV file which is delimited by a ~ and I am strugling with VB.Net code to be able to import the CSV file into Access 2007.My CSV file is located in c:empdrv.csvDatabase located in c:empdrv.accdb I have been searching on google for sometime now and can't find the solution, any help would be really apreshiated.Code so far, but this does not work:
Code:Dim myConn As OleDb.OleDbConnectionmyConn = New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:TempDRV.accdb;Persist Security Info=False;")Dim cmd As New OleDb.OleDbCommand("INSERT INTO drv_data (link_ID,drv_type,drv_text) SELECT * FROM [Text;Database=C:Temp;Hdr=No].[C: empdrv.csv]", myConn)myConn.Open()cmd.ExecuteNonQuery()myconn.Close()
I have built an Access 2007 database with some data stored in it. I have managed to export data using VB2008 from that database to Excel 2007 and have it automatically draw charts based on this data and a query in the Visual Basic Code. One of the results looks like this:
View 3 RepliesI have a CSV file which is delimited by a ~ and I am strugling with VB.Net code to be able to import the CSV file into Access 2007.My CSV file is located in c: empdrv.csv Database located in c: empdrv.accdb I have been searching on google for sometime now and can't find the solution, any help would be really apreshiated.Code so far, but this does not work:
Code:Dim myConn As OleDb.OleDbConnection myConn = New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:TempDRV.accdb;Persist Security Info=False;")Dim cmd As New OleDb.OleDbCommand("INSERT INTO drv_data (link_ID,drv_type,drv_text) SELECT * FROM [Text;Database=C:Temp;Hdr=No].[C: empdrv.csv]", myConn)
[Code]...
When trying to run the exe file error codes appear and back end data is missing. I loaded the 2007 runtime application.
View 4 RepliesI have a problem with accessing a data file from Access database. Data Source configuration Wizard comes back with a dialoge box saying "Error Message: Could not load type 'Microsoft Visual Studio.DataDesign.SynDesigner.SyncFacade.SyncManger' from assembly
'MicrosoftVisualStudio.DataDesign.SynDesigner.DslPackage,version = 9.0.0.0, Culture = netural,PublicKeyToken=b03f5f7f11d50a3a
My computer is a Vista and it have known to have lots of problem, but not sure if this is one of it.
I'm in a college class using the Microsoft visual studio 2008 for visual basic and i have a project where i'm supposed to connect a database but it can't recognize the database file as a database. I followed the book exactly so i don't know what the problem is.
View 3 RepliesConnecting VB with Excel 2007 & Access 2007?
View 14 RepliesI am using dotnet frame work 3.5. I need to access a file and reads the file which resides in a common path outside the application.
View 1 RepliesI need to migrate from Excel 2003 VBA to Excel 2007 VBA. When Microsoft introduced Excel 2007 it removed many objects from the previous versions and added some new objects. Also it hid some properties of particular objects. These hidden properties can be viewed by going to the object browser, right clicking any object and selecting "Show Hidden Members". My problem is I need to access these hidden properties. Is there any way I can access these properties. I can successfully migrate from Excel 2003 VBa to Excel 2007 VBA with the same functionality?
View 5 RepliesHow do I access the new attributes of Excel 2007 chart objects from VBA code such as setting the line gradient on a data series?
View 1 Replieshow could we download a pdf file and import the tabular data into access 2007 database, i have tried and got successful in downloading the pdf file from an URL, but not able to import the table data into access 2007 database/or may be an excel file through a VB6 program.
View 1 RepliesI am working on a project which was made using VB6, and my client wants to change it in VB.NET
i have to configure this projetct on windows vista ultimate..coz i cant go on with Win XP
can some one help me...
With VB.net, I'm coding a simple application to get more used to the new .Net format.
I'd like to save all the information to a 'new' database file. how to create a database on the fly, once that is done i'll be able to connect to it no problem, but actually creating the file is proving difficult to work/find out.
Also, with vb.net and the newly created custom file, how can it be made to automatically open that information with the program?
Is there a method in installation to associate the file type with the new program? How can i check when the program loads if a database file has been 'double-clicked' (rather than just running from the .exe of the program) and proceed to load the data?
EDIT1 - Extra InfoThe windows application has many different fields and content etc, then i need to save that to a file that could later be loaded by 'double clicking'. I assumed the easiest way would be to create a mini-database for each unique file
I have 2 access databases in access 2007 I want to be able to up date one from the other.
View 3 RepliesI'd like to create a new file everyday for a logging application to minimize size when accessing. I'm after a couple of pointers with respect to when to create the file, and what checks to do etc.
View 2 RepliesI'm trying to build an app that will read custom properties set in an accdb file. Basically, I'm trying to build a Front End updater (Yes I know there are others already built, but they don't work the way I want). The Custom properties are initially set manually by pressing the Office button, going to Manage, then Database Properties and selecting the Custom tab.
I've got most of the code set up, but my sticking point is how to read the custom properties.
Following is the function I use within Access VBA to get the properties, but obviously this is not going to work in VB.Net.
[Code].....
I think I need to replace one or more of the 4 lines after the On Error (yes I know I need to change the Error trapping too). I'm guessing I need to connect to the database file (an accdb, btw) and then go from there to define the container and documents collections.
I am trying to access settings in my config file, which is a series of xml elements listed as such:
[Code]...
i want to add a custom file type to my application For Example
somefile.dlh
the file type is a .DLH file how would i add this to my application so that it can read it ... like it would say a text file or something?
OK - for starters - I'm not even sure that the title of this thread accurately describes what I want to do - but I had trouble verbalizing it. So I will give this a try: In my application, I have a custom object, call it myObject. In addition, I have another custom object called myObjectList which is basically a List(Of myObject).
Up until this point, all of the functions that I have been working with in my BLL and DAL have been shared - I haven't needed a specific instance of my object thus far. I currently need to write a function that finds a particular myObject within myObjectList and returns to me myObject. I know that the List(Of T) has a find method, but from what I have read so far - I don't think it is what I want (doesn't it return true or false? -and also, do I need an existing object to pass to it to see if it is in the list?)
[Code]...
I have a problem with updating records from vb to access, As i am a fresser with vb software request you all to guide me in resolving this issue. is there any defult code for reference.
View 2 RepliesI have multiple copies of Access dbs running varous projects on diverse workstation all over the country. Some new additions to the team have only Access 2007. Is there a way that I can use both versions without having to re-do any VBA, macros, scripts, etc.?
View 2 Replies