[microsoft:access] Forum Topics

Guys,i want a small help from you.I have a created a database in MS Access and now i want to connect it to with Java Application by using ODBC Administartor.But when opens it,it doesn't show any driver for MS Access DBs.Do u guys know any driver for that.I'm using Windows …

Hi, I have developed a VB.NET Application with backend MS Access. Now I want to install on the user's machine, so i deployed the setup project. I need to know how can i create a desktop shortcut for my VB.NET Application. If I just copy and paste the filename.exe file …

[CODE]980 Set rs = db.OpenRecordset("0 - Supplier List") 990 RptLoc = 0 1000 If rs.EOF = False Then ProcessCount = ProcessCount + 1 1010 Do While rs.EOF = False [COLOR="Red"]1020 XL.Sheets("Supplier").Copy Before:=XL.Sheets("Supplier") 1030 XL.Sheets(2 + RptLoc).Name = rs!Supplier[/COLOR] 1040 RptLoc = RptLoc + 1 1050 rs.MoveNext 1060 Loop 1070 XL.DisplayAlerts …

Hi all, I wrote a .hta script (with vbscript - no jscript, in it) and put it on a fileserver. The people who use this script, start the script by clicking on a shortcut on their Desktop that leads to the .hta script on the fileserver. The .hta script reads …

Hi Everyone. I am totally new here and this is my first post.. I have tried many place, since i could get any solution. I have no choice then posting here. basically, i have one delete form, where i will load the firstname from a table in access(hardcode) to listbox. …

i'm trying to get data of 30 minutes ago to now.. any idea with the query [CODE]SELECT DateDiff("n",Now(),[TimeStamp]) AS [Time] FROM RIMData_RAW GROUP BY DateDiff("n",Now(),[TimeStamp]) HAVING ((Now()>30)); [/CODE]

Hi There experts... i am hoping that someone will be able to help me with a problem... I have the following vba code.. some of you that are clued up with vba will know... it is a code i got from the net that allows me to choose dates before …

hi, i'm new to c# programming and i have this problem that i encountered while trying to create a database browser. Here is my code: [CODE]private void button1_Click(object sender, EventArgs e) { string search; search = searchbox.Text; if (search == "") { MessageBox.Show("You have not entered anything. Please enter the …

Hello, im working on a project that works with an access database but i dont know how to edit an existing record... here is the code that i use for reading the database: [CODE]Public Function ask() Dim dt As New DataTable Dim ds As New DataSet ds.Tables.Add(dt) con.Open() Dim da …

I want to calculate the average of a column or rows of project #1, project #2, etc.... and Adding a new column with the grade of the students ....like the picture.. Im new using visual basic. Thanks in advance. =D [img]http://i41.tinypic.com/5z1xi.png[/img]

I was wondering if there is a code i could add to my applicatio that will delete a data entry from a database. I'm designing a voting application as my project and i want a situation where an access code is good for only one entry. i put my code …

Hi again !! I am making a widows application wherein i have a form containing two datagridviews.. The first one( named dgv1) consists of all the data from the database and a checkbox column.. While the user selects the rows using checkbox, the data are displayed in adjoining datagridview(named dgv3).. …

Hi I have made lots of Access databases over the years but it seems I have fogotton lots of basic principles since I have not used it for ages. One thing I want to do is: For instance when you send an email using Yahoo or similar webmail if you …

Hello, I'm a newbie working with vbnet but i'm trying to create a project were I enter a name in a textbox and save it to a access database. I'm trying to create the OledbConnection but i'm getting this error: "oleDbException was unhandled" this is the code i'm using: [CODE]Private …

Main Form = Frm_Engineer_Search Sub Form = Frm_Engineers Frm_Engineers populated by Tbl_Engineers I've been trying to link together a textbox with a subform so when a surname is entered into TxtSearch and CmdSearch is click it will run a query/refresh the subform displaying the correct record which correspond to the …

I cannot believe how loooooong i have been searching the internet for this. However i have a form that i have created in Visual studio 2010. I have 3 text boxes for FIRST NAME, LAST NAME and NOTES. I have 1 button to submit data. When i click the button …

how to inset data into ms access database in vb 2008

Hi..this is my coding. Its compiled successfully. But i could not get my result. I don't know whether the data stored in the file successfully or not. Please Help me. [CODE] #include <iostream> #include <fstream> #include <cstring> using namespace std; struct status { char name[80]; double balance; unsigned long account_num; …

hello guys in daniweb. i have a application windows based created in vb.net that contains crystal reports and access .accdb files. to be honest i have tried to publish this app for 11 times and still there to be some problem. the application will install but it cannot run. it …

I’m trying to create Web Application using ASP.Net via Visual Studio 2010. The Database that I use is Access, with connection Method OleDb When using the query “Update” or “Delete”, the programs shows no errors, but the data in Access does not change. While for query “Select” and “Insert”, the …

I've created an append query to move records from one table to another. Am i right in thinking it should move the records then delete them from the previous table? If so then for some reason its not working for me. Using MS Access 2003. [ICODE]INSERT INTO Tbl_Job_Temp SELECT Tbl_Job_List.* …

i am just developing a library management system as one of my project. i using vb.net 2010 and the MS Access 2007 as back end. when i save some records into my database through my application it is correctly saved and i confirmed it through opening the relevant table in …

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> <script language="text/JavaScript"> function Myconn(){ var cn = new ActiveXObject("ADODB.Connection"); var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = Test.mdb;Persist Security Info=False"; cn.Open(strConn); var rs = new ActiveXObject("ADODB.Recordset"); var SQL = "select * from Customers"; rs.Open(SQL, …

I'm using Visual Studio 2010, Win 7, MS Access 2010, C++, Direct ODBC, 32 bit. The first SELECT statement executes. The INSERT, SELECT, SELECT and UPDATE statements don't nay help is appreciated. Thanks. [CODE] #include <windows.h> #include <stdio.h> #include <sqlext.h> const char* DAM = "Direct ODBC"; SQLCHAR szDSN[256] = "Driver={Microsoft …

Hi I have a database of one table with headings as shown DONOR COURSE TITLE START DATE END DATE MIN/DEPT ANNOUNCED TO DATE RECEIVED BY HRD DONOR DEADLINE DATE FORWARDED NOMINEES BENEFICIARIES-MALE BENEFICIARIES-FEMALE NUMBER ACCEPTED REASONS FOR NON-ACCEPTANCE DATE OF ENTRY NATIONAL COUNTY The table is in access. I would …

This is problem that I have struggled with for some time, but im sure the answer is very simple... I have a sub report that performs calculations on 2 fields ( [Rate] [Hours Worked] ) from a table called [Hours]. The report is GROUPED by [Rate] and is as follows: …

All, I can't seem to find anything on the web about how to connect to a LibreOffice database. I am currently using the following code to connect to a MS Access database and would like to know how to change it to work with LibreOffice. [CODE]String strConnect = "jdbc:odbc:DRIVER=Microsoft Access …

Using: MS Access 2010 Visual Studio 2010 with Provider=Microsoft.ACE.OLEDB.12.0 Connection I have 2 forms: frmCustomers contains datagridview that launches frmEdit used to edit record. The issue I am having is my save button on frmEdit saves changes to the datagridview on frmCustomers but not to the database frmCustomers: [CODE]Public Class …

Using: MS Access 2010 Visual Studio 2010 with Provider=Microsoft.ACE.OLEDB.12.0 Connection I have tried multiple ways to do this fought through Concurrency issues current code gives no errors however when I re Fill DataSet nothing has been removed from database... Current code for Button1(reload data), Button2(delete row): [CODE] Private Sub Button1_Click(ByVal …

can someone help me connecting ms access 2010 to visual basic 2008, this is the error of my program every time I run it "The 'Microsoft.ACE.Oledb.12.0' provider is not registered on the local machine." here is my code for the provider Imports System Imports System.Data Imports System.Data.OleDb Public Class Form1 …

when i am trying to use delete button on my frame it is showing such exception and stack trace is here java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer at MyFrame.actionPerformed(AcctHld.java:225) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2012) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2335) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:404) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:253) at java.awt.Component.processMouseEvent(Component.java:6099) at javax.swing.JComponent.processMouseEvent(JComponent.java:3287) at java.awt.Component.processEvent(Component.java:5864) at java.awt.Container.processEvent(Container.java:2109) at java.awt.Component.dispatchEventImpl(Component.java:4460) …

i have a program that has a database in access and i want to update data but when i click on update button on my frame nothing happens no error no exception and no work. here is my code [CODE]bUpdate=new JButton("Update"); bUpdate.setBounds(275,600,100,50); c.add(bUpdate); bUpdate.addActionListener(this); public void actionPerformed(ActionEvent ae){ Object o=ae.getSource(); …

i need code for vb.net 2008. That is invoice system i have number in each invoice. my database invoice number is null. when i click tab automatically invoice number increased number 1 ( EC000 to EC001). I used tab control . please reply...

hello friends, I am doing a bank management system project where I have to conect a database done in MS Access(.mdb extension) to the C++ code...I ve never learnt much about databases and this is the first time I m using Access...so I d be grateful if anyone could explain …

Dear All, Pls. help me I have insert data to MS.Access and re-load data to DataGridView, it's always do at LoadAllData() but some time datagridview is not refresh. [CODE]Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\EmployeeDB\EmployeeDB.mdb;User Id=;Password=;" Dim conn …

I have a database with a list of process owners. The users of this database wants the process owners emailed when a form is updated with a click of a button. I can email to one person using a macro but this requires additional codeing which I am not all …

Below is my code for login page I would like to show login user detail on home. For login my code works properly but does not show currently login user show following error "NO data exists for column/row". Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Login.Click …

hi am a newbie to the vb.net thing. am using ms access for my database. i have a customer table in my database where sutomer details like first name, last name, address, etc are stored. i've created a form in vb.net and i have a text box, a datagrid and …

Hi, I have RadDatagrid filled from MsAccess, I want when i click on a row once, my textboxes got filled with data from this row.

Hello there! I need your expertise in vb6. I made a new exercise for my vb6 subject using database Microsoft access. With the fields of FirstName, MiddleName, LastName, Birthdate and Age. and there is correct information of my family in every fields. Using navigation command. Im using Microsoft ADO Data …

hello,i am using MS-access db and java code.i want to insert values in a particular row based on selected serial no. and i use statement [code] try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con2=DriverManager.getConnection("jdbc:odbc:ResumeDSN"); Statement stat1=con2.createStatement(); Statement stat2=con2.createStatement(); stu = new Student(); String Fir6=pers.tname.getText(); if(Fir6.equals("")==true){Fir6=" ";} String Sec6=pers.tdob.getText(); if(Sec6.equals("")==true){Sec6=" ";} String Thir6=pers.tfather.getText(); if(Thir6.equals("")==true){Thir6=" …

I am a student and we are working on a project in Access database but in windows. When I go back home I tried to run and edit the project but it didn't work. Notice that I don't have Access installed on my mac. My questions: 1- do I have …

How to find index in vb.net when connected with ms-access2007:) Th'x in advance.

How do I apply and code a list box in visual basic 6.0, How do i link and generate a report with visual basic linked with the database table in Access 2007.

Please could you tell me where I am going wrong I want to open 1 of 2 forms depending if a certain text is present in a field of a table. If text "Expired" is present in the 'Name' field of Table 'MAIN' then open form 'Expired' and if is …

hi. i'm doing a search option in my system where if your searching for a entry even if you didnt typed the whole word, all of the entry that contains the letters that you have typed will appear, well i really cant explain it but it goes like this if …

I have two tables like Staff Table ............ Staff ID Staff Name Age ...and more Staff Salary Table .................. Staff ID Staff Name basic Salary ...and more Now I have created the Staff Salary form in which I got the staff ID from the staff table using the lookup wizard …

Hello everyone this will be my first post. I am happy that there is a forum like this with very supportive people.:) So on topic.. I am a student creating an Inventory System software for my school using VB on VS 2008. I am having trouble saving items from a …

I know i'm probably goin about this bassackwards. But, window is loaded, binded textboxes get filled, user edits textboxes and clicks a save button it works, all except crashing with a "vb.net 2010 Concurrency violation: the UpdateCommand affected 0 of the expected 1 records." most of the time but the …

I have made a select statement with a date condition seems like its not reading the date condition please check the code below [CODE] Select * From tbltest WHERE (((Validity.ToDate)<><cfqueryPARAM value = "#31/8/2011#" CFSQLType = 'CF_SQL_DATE'>) [/CODE] Please help I don't want dates that are equal to 31/08/2011 its getting …