[microsoft:access] Forum Topics

Can someone please help me ? I made a button named "Open" for Visual Basic 6.0 , and i would like to execute/open Microsoft Access 2007, can someone please help me ...

Hi, I have been looking for several hours for code that automatically checks if Microsoft acess database engine is installed. If not it reinstalls the database driver by first detecting architechture(32/64 bit). It then automatically installs the driver. I am using Ms Access database 2007 as data source for my …

Guys how can i connect MS.ACCESS as my DATABASE in TURBO C.? Please help.. this is not an assignment.. i just want to know how....

here is my code for delete Private Sub Button4_Click(sender As Object, e As EventArgs) Handles Button4.Click If MsgBox("Are you sure you want to delete this item?", vbYesNo + vbQuestion, "Delete") = vbNo Then Else If Me.DataGridView1.Rows.Count > 0 Then If Me.DataGridView1.SelectedRows.Count > 0 Then Dim x As Integer = Me.DataGridView1.SelectedRows(0).Cells("FNo").Value …

I have a small program that queries a database and retrieve some information about employees. The only problem I have is that when I search for the employee my program never finds any employee after the first employee. Here is my code: private void buttonSearch_Click(object sender, EventArgs e) { string …

hi is there someone that can give me some hints on how to create excel file using data from my ms access database..because i haven't seen one in the net maybe someone might help me here..i would appreciate some hints or tutorials..:D thanks a lot...

Hye. i need to build an inventory system. In that system, the production department will scan the barcode in each item. **How should i connect the barcode scanner with the system ? ** and the requirement of the system is to be able to compare the information scanned **with** the …

I want to connect my access database to my project in vb 6. What are the steps i should follow? Once i'm done with that, i want to know how to drag them and place them on a form (like the way we do it in VB.NET). Thank you

Hello, I am a bit new to vb.net. I was learning Database in vb.net . I have created a MS Access file. But when I Started my Visual Basic (vb.net 2008 Proffestional) and then I Clicked the Option Add New Data Type (In Data), nothing came. Can someone help me …

I am trying to write some information to an access database using OleDB but I get an error. I dont know what is wrong with it. I it something to do with my SQL code? // The program will make use of a text file for now but must use …

Hi All, I am trying to create a drawing database in Microsoft Access. Each user has a unique log in to the databse, when they log in and go to a part I am wanting them to be able to open the drawing by pressing a button and print it. …

I have a textbox to enter date into a MS Access database. I've tried entering 29-02-2000. But it is saved as 28-01-1900 in Access. I've tried entering 02-20-2000. But it is saved as 01-01-1900 in Access. My system shortdate format is dd-MM-yyyy. My system longdate format is dd MMMM,yyyy. My …

Hi Dw I'm planing on creating a system that will share the same database over internet. There will be one core server where the database will be located and there will be a thousands of client programs that will modify the database simultaneously over internet. I've never done something like …

Hi all I just started using Crystal reports in vs2010. I have created a Dataset in the Designer and pulled data from an access DB. The dataset is being populated fine. My Issue is when I assign the dataset to crystal database expert and drag the columns to the report …

Hi guys, I just got into a little problem.I just deployed an application with backend db access.It works fine on major OSs being used like win7 and XP. But some functionality related to the database doesn't work properly when deployed on win8. I used a code to delete temp table …

Hi i am trying to display records in access database that have pictures saves binary data i have created typed dataset that populate the crystal report but the problem is the images do not display code is as below i have attached sample report Imports System.Data Imports System.Configuration Imports System.Data.OleDb …

I need help in fixing this bug (Data type mismatch).Im using a datagrid to insert data to access database but get this error. I can update and delete during runtime but I cant insert data to database. Following is my code: Try conn = New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Video Store\Video Store\DvDSystem.mdb") conn.Open() …

Hy guys, . Please assist in advicing whch toolbox conncetion controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to …

Hi guys pls help, Im trying to connect to access 2007 database in vb.net 2005 woth no luck.....im using a login form with two text boxes and two buttons, Im tring to log into the database using the below connection string....... (i only get the catch message box error)... Plz …

Hy guys, Please assist in advcicing which toolbox connection controls to add in my form. I want to connect to access 2007 using vb.net 2005 and im struggling. I have two textboxes(username and password) and two buttons(submit and cancel). When I click on the submit button it supposed to allow …

Hi, I am using MS ACCESS. I want to validate a particular field. To check whether if its a valid email address with a @ So anyone have tutorials or website to reccomend or even reply off hand with the expression to check for @ in a string? Thanks alot.

Dim total As Integer For Each row As DataGridViewRow In DataGridView1.Rows total += row.Cells("Total").Value Next TextBox2.Text = total // the above was the code i used and it worked good,bt if i do it for another column it is showing an error (which is given below)// Private Sub Button1_Click(ByVal sender …

[code=sql]insert into desg values(" & Val(txtsno.Text) & ",'" & Trim(txtdesg.Text) & "'," & Val(txtbasic.Text) & ");[/code] this how i used for inserting data to my access table in vb code. how to do in c#?

Hello, am on a project and I want the user to search for a word in datagridview. Am using vb.net 8 with access 2010 I want where the text is to be highlighted

Hope you are doing okay today! I am using ms access 2010. I want to calculate the students points and division for each student. Students are taking 9 subjects and I want to take only 7 (the highest score). The grades are: 75-100=A, 60-74=B+, 50-59=B, 40-49=C, 30-39=D, 20-29=E, 0-19=F. The …

I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access …

Hi all, I had a little problem when deploying an application having crystal reports as a reporting tool on a client pc. It works so well in my dev pc even installed.Since i'm using Access 2007 i used Microsoft.ACE.OLEDB.12.0 provider. I haven't provided any password or username for the database.But …

Hello I have started my first ever VS Web page today and have two pages open in the software: Register1.aspx and Web.config. I am hoping to devise a simple 'new user registration form' with three fields: username, password, and email. When the 'submit' button is clicked, those three fields should …

I am trying to export the current record in my app into a PDF. My current code (shown below) is exporting into Crystal Report and then into PDF format but it is exporting ALL records in the database. This program is used for entering in Purchase Requests. Each record in …

i need a simple project of microsoft access for beginner bacause i am beginner in database plz help me and give me a simple project

hi all; again i have a little bit wired problem here what i'm trying to achive here is that i would like to to a search query to search an employee and after that change the depatment and after that update the data into access database and as you can …

i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL

i need help on how to print preview and print the content of my datagrid. i used vb2010 and ms access as db -Beginner Here :D-

Hi, My project is in c#, created in vs2008 with access 2007 as the db and windows 8.1 as the os. I've created a setup file with the required dll and accdb file added to it. When the application runs for the first time it creates another copy of the …

I need to import the xml file into access and I should do the transformations (XML -> XML) and to do that Access calls an XSLT file. Then my source file is as follows, of course I deleted the rows because it was very long, but it should be understood, …

Hello, I do the simple project using VB.net 2008 to link with MS Access 2007. I have two textbox which is data for ID and Fullname. txtID.Text = ID txtFullname.Text = Fullname Button1 = Search In MS Access My data for ID : 1,2 & 3 and My data for …

Hi. I want to publish my first website using Visual Web Developer 2010 Express. I have a connection string (shown below) in my web.config file. The database is MS Access 2007. Assume I have registered the name ABC.com and I want to publish to it. I haven't chosen a host …

hi...i am a new user of vb.net and i want to have a code where changes in my existing data could be save when i click the button "update"...can anyone help me about this matter?...here's my code for the said matter... Private Sub menu_update_Click(sender As Object, e As EventArgs) Handles …

Hi Dw I've create an ASP.NET web app using VB.NET and now I want to connect an access database to it so that it can save data, and also read data from it, I've added the database as resources but I'm not sure if this is appropriate and I haven't …

Dear Experts When we create table in MS Access we enter description of field in description column. I am able to get the field name and data type from the table but how can I get the description from the table. Here is the code by which I am getting …

how do you display image from a access database into a jtable in java

hey all, i have a little issue here with the below however the wired thing that i encoutred is that the below code run only for one time perfectly and when i invoked it again it displayes the error : " The ConnectionString property has not been initialized. " private …

I'm new at this. I'm trying to set up a website. The contact us form gathers info but how do I set up where it goes? The platform is Office 365 on the public site. I'm using Access 2013 as my database.

i have a text field with name "date" and i want to retrieve all he records from database when user write a specific date on that text field.......I am using MS access data base......Query below is not showing any record String date=request.getParameter("OrderDate"); String query = "SELECT * FROM DoorStepRequests where …

im using access 2007...when i open database in vb6.0 it is throwing an error 3343 unrecognised database format..i m using latest reference. help me out

hi, I need a help.how can i SEARCH a record in a database using listbox and display the results?? For an example: if i select a destination on the listbox and it will look for the records on database and display it. im using ms access and adodb connection.Below is …

Hi, i would like to know how to retrieve an image in an access database to vb6. Thanks in advance.

try { /* Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver"); String loc = "jdbc:odbc:Library"; String filename = "C:\\Users\\Krishal Lad\\Desktop\\Library.mdb"; String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="; database+= filename.trim() + ";DriverID=22;}"; // add on to the end con = DriverManager.getConnection (database);*/ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb,*.accdb)};DBQ=Library.mdb;"; System.out.println("connecting to database..."); Connection conn = …

Hi all, Hi i have got a problem with the system i am creating on VB using Microsft Access. I have this error that keeps coming up when I debug my system. I am trying to add data in the database. I cant seem to find the solution to this …

i need to copy my data from access database to sql database through coding in vb.net , and taking into consideration the duplicates each time i select from access database to copy to sql , any help thx