access

I have an access 2007 database that my client has provided me. The products table contains the Attachment type for the product image. I can read the product data no problem, but I have yet to figure out how to display the image for the product in my picturebox control in VB.Net Any...

Hello everyone. I have one application that have database connections with access and dbase. When I run the application using vs 2010 everything is ok. Now I want to give a copy to one friend for a testing purpose. I've taken the files in release folder and give them to my friend, and everything...

Hi, this is my problem: i've some data in an access database, i collect this data from the table and when i try to record the data in the text file, with the fields separated with a "!", the registration fails, better, doesn't register all the datas that are in the table. This is the code...

Hi, everybody, i've dev a program that access to an mdb database and insert a new record with the command INSERT INTO but when i execute the db command with ExecuteNonQuery the program catch an exception that i did not understand. I post the oledbcommand line and the fields of the access mdb...

First off, let me say Hi. I'm new to this forum and I would like to thank you in advance for any suggestions or comments. Here is what I'm looking for: I have created a Payroll Management application in vbexpress2008. It is my very first vb project and I've spent a lot of time and effort on...

Hi Could someone please offer some advice on how to retrieve the number of records (rows) in an access database and display on a form please (vb.net)? Also, is it possible to display (in a label) the last record in the database, which will then update when another record is added? Thank you.

Hi I am having a application in vb.net with access database and crystal reports.In report I know how to load a table with all data in table, but how to make query and where to make it to load only specific data from table?For example I want my report to show only data from table "Products"...

Using VB.NET, If i need to read a txt file that has 2 million records and they need to be added to Access database. Before I add these records, I have to check if the record exists in the table. If the record exist, then update the record, else add a new record How do i go about it? Will I be...

Hi, I'm trying to extract records from an access database. I pass a date to the query and i want to retrieve records where my date is between TASK_START_DATE Column and TASK_FINISH_DATE Column. Dim queryString As String = "SELECT * FROM(MSP_TASKS) " & _ "WHERE (@data BETWEEN...

Hello everyone, its my first post here. What i am trying to achieve is to execute queries i have already created which are stored in my access file from my VB application. My code looks like this. 'Dim command As OdbcCommand = New OdbcCommand Using cnx As New...

I have been using what I think is a simplistic and easy way of reading and writing to/from the registry but whenever I look at code I keep seeing links to DLL's and constant decorations and lines and lines of code. Is there any reason why I shouldn't use the following: Friend Function...

Greetings everyone, Let me preface this by saying I have read other posts on this board that describe the problem I am having but I am not understanding the solutions, and I need some help. I need to create a Windows Service that involves being able to access and move files saved on the...

Hi there, I have created a DataGridView from an MS access query (more than 12 columns!), I would like to make a search or filter the records either with an external combobox or some checkboxes to avoid showing all the columns and making a search through the controls. I know... it's a very...