3,459 Topics
I have tried every possible way of connecting the database to the program, but its just not happening! Help me please :( final static String fileName ="Netlync.mdb"; static{ try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ="+fileName; con = DriverManager.getConnection(url,"",""); }catch(Exception exx){ exx.printStackTrace(); }} private static Connection con;
So I put the database into the dubug folder in bin of my project, and in the data source configuration wizard i selected ms access and my file, then i copied my connection string, it was "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\bin\Debug\bookshop.mdb" and wrote some code for it to connect to it, to be …
hello all, I want to make some simple database in access that would track student information, semesters etc... I have created basic tables like: students, professors, subjects.. now I am stuck with the most important part: semesters and subjects... here is the link [Click Here](http://prntscr.com/2jafl6)where you can see database relationship …
@ by : O This is topic (http://www.codeproject.com/Articles/21351/Import-Data-to-SQL-Server-from-Excel-or-Access-usi) is reactivated again which was posted by : Oxiegen for further information: The code is corrected but the data is not getting exported from Access database to SQL. The code is as follows : Private Sub Button1_Click(ByVal sender As System.Object, ByVal e …
Hi I am doing a project where i need to edit values in textboxes from database using jsp, here is my code, Please can anyone help me to solve this: retrieve.jsp [code] <%@ page import="java.sql.*" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");%> <HTML> <HEAD> <TITLE>Fetching Data From a Database</TITLE> </HEAD> <BODY> <H1>Fetching Data From …
greetings everyone!. I'm making Clinic system for my project. I just want to ask how to get the total quantity of the medicine and display it on textbox. I'm using using vb6 and adodc. Any help will be greatly appreciated.Thank you... Table name inventory fields: Medicinename StockQuantity
I have used datagridview in the form and using combo box/ But i have no idea as to how can i update the database to reflect the latest changes in the gridview. Tried searching but could not find proper and organised answer. Could you please help me out with this …
how to transfer data from excel to ms access database?? and how to retrieve data from ms access database using visual basic 6.0??anybody can help me..
Hi, I have a problem with changing the password from Microsoft Access Database. I get an Error "[B]No data exists for the row/column[/B]". The password in the database is encrypted and when I change the password it should be decrypting the password and new password should be updated with encryption …
I have created an application in c#. Following are my concerns. 1) create setup file which includes the ms access db 2) identify the location where this db will be stored 3) use this location as the data source for the application
Hello, My sincere apology, I have been posting almost 4 questions now where I have received 2 answers being solved. These are simple questions which any one familar with VB.Net can solve easily. Please understand, I'm a newbie to VB.Net. Now my next issue is; I have a a form …
hi guys, I got another issue doin my project. Im using Microsoft access as Database. When i need to UPDATE it work and the msgbox displayed: "thank you", but when i looked into the database nothing happened. Anyone can help me to determine the problem? please Thanks in advance. con.Open() …
Hi I am new to using Microsoft Access as a database for Visual Studio (previously I used SQL Server) so I am unsure how to go about the usual tasks such as accessing the database. At the minute I am trying to write code to check if a username already …
This is a theoretical question but any specific technical knowledge that could help will also be appreciated. I am an IT Assistant with not much knowledge in programming (apart from EasyPattern and super-simple batch files) but have been given an opportunity to start getting into it by having been given …
i am using employee table to test if i am doing the whole program correct. I have 5 buttons. one is to add records and another to save(commit), to update, to delete and to clear. I am having trouble with the code to save the record to the data set. …
Hi Guys, I am using access (.mdb) database in my windows application. When i am inserting values to db it gives me an error "syntax error in insert into statement" but it will work in SQL and access query analyzer. here is my code [CODE] string StrInsertToServer1 = "insert into …
Hi, I have a table with curdt field with datatype datetime in ms-access. the entries in curdt as follows:1/28/2011, 2/9/2011 etc. I have a form with two datepickers with custom format of dd/mm/yyyy. my query is like [CODE] select * from table where curdt between #dtfr# and #dtto# [/CODE] where …
Plz Help me I'm creating a form-View in asp.net 2010 and successfully upload all my data on the Form View but my problem arise when i edit the data in the form, it does not update the data. Following is my code. <%@ Page Title="" Language="VB" MasterPageFile="~/Site.master" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" …
How can I save the data comes from my flexgrid and save it to my access using vb6? Private Sub Command2_Click() opendata With save .AddNew !product = fg.Col = 1: !quantity = fg.Col = 2: !price = fg.Col = 3: !total_price = fg.Col = 4 .Update End With End Sub
I have this code working on VB.NET 2008 but not working in VB.NET 2010 and show no error code. When I use the query analyzer the query work good, but when I try on my code nothing happen. I can do SELECT code and that ok, it’s just the update …
Friends, I have a Database in Access, Table Name- Master . Structure is given below Mno=Membership no in digits Name=Member's Name Fno=Family number in digits Fname=name of the family Faddress=Address of family Fphone=Telephone of Family The database contains several records where some members come under the same family.In other words,Suppose …
When I click on Button which fetch records from the database it works fine public void fetchrecords() throws SQLException { Statement stmt = null; String query = "select * from Employer where Fileno=1"; try { stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); rs = stmt.executeQuery(query); while (rs.next()) { firstNameTextField.setText(rs.getString(2)); lastNameTextField.setText(rs.getString(3)); addressTextField.setText(rs.getString(4)); //and more records. …
i have the following fields in my access application. 1.studentid 2.grade e.g A,B,C..... IN COMBOBOX 3.GRADING SYSTEM E.G A= 4.00,A- = 367 IN COMBOBOX I WANTED IF ICHOOSE A , I GET 4.00 AUTOMATICALLY QUICK REPLY WILL BE APPRECIATED
i have trancript generating application in access. these are the fields 1. studentid 2.grade in combobox(A,B,C---) 3.grading system IN COMBOX(4.00,3.67---) I WANTED IF I CHOOSE A,I BE ABLE TO GET 4.00 AUTOMATICALLY IN GRADING SYSTEM COMBOBOX. quick reply will be appreciated
I I have an application in access 2010 which is mainly for generation of tranascripts. i have the following fields. 1.Grade(A,B,C-----) IN combo box 2.grade points e.g (4.00,3.67......) IN combo box 3.credit hours e.g(3,2,1,0) in combobox I wanted if i choose A(grade) for example from the combobox, i be able …
Hello. I have an old access data project. I need to convert it to sql and .net. How can I do that?
'I have a problem in database Program in VB 6.0 that connects to Ms access which the field datatype is OLE object. ' here is my problem 'when i tried to run my program i always got this error message '"System Error &H80040E00 (-2147217920)" 'here is my code for uploading …
As the title says I'm having trouble in my Vehicle Maintenance routine where I will have a a monthly maintenance based on the last maintenance date. If the vehicle has reach 1 month since last maintenance it will show in a datagrid. Also it should select those vehicle that reach …
my problem is i want to save a date from label in vb to field in ms access but i do not know that problem with my coding, the error appear is run-time error 91 object variable or with block variable not set, can anyone check my coding? Dim Con …
Hello Guys, Is it possible to connect C++ Console app to MS Access?
Im using Microsoft Visual Studio 2012 and Microsoft Access What code/sql will I add to check whether User is an admin or a regular user? so it can load to a Admin form or Regular user form. My professor told me to use a FieldName "LoginType" in my database.. but …
Im creating an application where some data should be populated in a gridview and then user should be able to update it and then same should be replicate to the database. So i have put a gridview and configure it to connect to my database which is base on access …
hello, i am doing a mini project in vb.net2010...BLOOD BANK MANAGEMENT...but i dnt knw how to connect vb.net2010 with ms access 2007..and how to code for add, delete,update records...plz help me
PLEAS I WANT TO KNOW HOW TO LINK VB.NET TO DATABASE ACCESS
-->>Hi everyone Iam trying to use and applcaton developed in VB 6.0 with Microsoft Acess Database (.mdb) but when I run the application I get the Error code as to the thread, -->>I followed some instructions on the following links http://social.technet.microsoft.com/Forums/zh/w7itprogeneral/thread/7aa24584-49a6-4001-8c68-a6742aacbc81 and http://www.analyrics.com/search?q=Error%20code%200x8002801c but still the problem persisted so Im …
HERE I WANTED TO FILL MY BLANK RECORD WITH ITS VALID DATA private void button5_Click(object sender, EventArgs e)//modify { comm.Connection = conn; comm.CommandText = " UPDATE Table1 SET total='" + textBox6.Text + "',result='" + label7.Text + "' WHERE Fname ='" + textBox1.Text + "'"; conn.Open(); comm.ExecuteNonQuery(); conn.Close(); dataGridView1.Update(); } I …
Hi I have access database with two tables With a Relationship i can insert records into the first table with no problems but when im trying to insert a record in the second table i got error message Error message : Syntax error in INSERT INTO statement. - Microsoft Office …
Hi I use Windows 7 Home Premium. It has had SP1 installed and as of today Windows Update advises the system is up to date. The problem I have is with an Access 2007 database. It is in a folder and I have a shortcut to it on the desktop. …
Hey Guys! Im making a furniture company cost software using MS Access.I have two tables,Product and ProductMaterialDetails.What I want to do is when the user updates a material's price then the product automatically updates its TotalCost.For example if YellowChair uses a galon of Sealer at $5.00 and a galon of …
Hello everyone, I have a problem, i am unsure how to read the data from my Access Database into my vb.net form. I did some searching but i didn't manage to find anything useful so i would appreciate any pointers. Here is the code from frmAddNewCandidate i am using that …
i have a a cooperative society website.i need to process the loan members ask for.how will i create a admin page where admin staff process and grants loans to members
hi my name is vishal i am using vb6 as front-end and ms access as back-end.I dont want to use data report instead i want to export all these multiple tables values to excel into a single sheet.I am using a command button and whenever i click that command button …
hello i am using vb 2008 version and microsoft office access 2003.I have installed access 2007 also. while i work in vb,i get error -could not find installable ISAM ,at this code con.open("provider=microsoft.jet.oledb.4.0;datasourse="&application startup path&"vbnet.mdb")
I have just a user form in access 2007 with a text box and a Save command. MY code: Private Sub Save_Click() If School.Value = "" Then MsgBox ("Text Box is empty") else Msgbox(" Not Empty") End If End Sub When the Save is clicked, and the text box is …
Dear Friends, Help me to break my database password. Database in .accdb format
i have been doing like the code below, but why when i clicking the "delete" button, it is delete all records in the datagridview, but it does not updating to the database. And, how do i make only the selected row that has been selected by the user that gonna …
Hi, this is my first post, and I'm in need of some help making an application that saves the data from a textbox to an access database. This is my code, it gives no errors, but when I use it, ie, I input the text in the textbox and click …
Private Sub Save_Record() Dim cmd As New OleDbCommand Dim sSQL As String = String.Empty Dim arrImage() As Byte Dim myMs As New IO.MemoryStream Dim bSaveImage As Boolean = False Dim strImg As String = String.Empty Try If Not IsNothing(Me.pic1.Image) Then Me.pic1.Image.Save(myMs, Me.pic1.Image.RawFormat) arrImage = myMs.GetBuffer Else arrImage = Nothing End …
Hi, I need to retrieve records from access database in c# which falls between date1 and date2. anyone could help me out this...
Hi all , I am trying to build a function in Access Query database which gives results of a 1 month expire invoices from the current month.Therefore when I run the query, the results will be all the invoices which will expire next month. I have tried the Data Add …
The End.