[microsoft:access] Forum Topics

Hi all, We use a .hta vbscript from a fileserver, but after office 2007 has been intalled, the script does not read/write from/to a .mdb file on that same fileserver. The script does work (with office 2007), if it is started from a desktop instead of the fileserver. (reading/writing the …

I've a field, say "Invoice No.", i want to be this as an auto-generated number. like DLP/001/2013-2014 DLP/002/2013-2014 DLP/003/2013-2014 . I use vb6 and Access.how can i do this?

Hi, I am currently migrating access programs into vb.net with t-sql database backend. I am having 400000 rows of data that I have to pass into recordset and display it on the grid. In the good old access, the data appears almost immediately. Because access does not wait to load …

Hi, it's a very simple question, but I cant see how to solve it! I'm doing a web form, I have a button inside a table, the thing is, I can't access to the code of this button, Usually you just double click on the design view over a button, …

Hi guys, wondered if anyone could help, or point me in the right direction please, i want to insert data from the datagridview to the access database, that datagridview is not bound to anything, i insert data from textboxes to the DGV, and want them to insert into the DB, …

hi friends! From my Microsoft Access form I would like to hyperlink to a pdf document. At present each record contains a document name and a full file path to where the document is stored. I would like to open adobe Reader and view the specified document. please give me …

I am presently doing a project in vb 2008 where the database that i need is in MS Access... I have windows 7 64bit OS and msjet4.0.dll in the c:\WINDOWS\SYSWOW64 folder but still when i run the .vb code i get an error ...as follows.. The 'Microsoft.JET.OLEDB.4.0' provider is not …

Hi everyone I was wondering if it was possible to update two tables in an access database with the same data input from a single form without doing anything to the actual database itself ie linking tables etc? I have asked this in other forums but have been shouted down …

Looking for assistance in, as the title reads, accessing an Access database via PHP when the database is open. (Please bear with me as my knowledge of PHP, when used in conjunction with a database, is extremely sketchy at best.) Using the code below, I can pull up a directory …

please how can i create a database and link it to my VB6 application. i designed a VB application to hold bio-data that will be updated from time to time but am finding it difficult to create the access back-end for it. please any urgent help will be most welcomed.

Hi All, I'm trying to import the contents of a csv file to an access database. I have a database named myDatabase with a table named myTable. It has columns A-E say. I have a csv file with headings in the first row which are called say S-Z. I want …

Hello, i'm trying to add some values in the database (ms access) but i am having the following error: Error:java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Can somebody help? Here is my code: package db_con; import java.sql.*; /* * To change this template, …

Hi, Have been using the same database for years without any trouble. Suddenly we are getting the Data Type Mismatch in Criteria Expression when we attempt to run a VB function. I am not familiar with VB so much, but have found where the error is happening: [CODE] Private Sub …

Hi.. I want to read data from the microsoft access file(.mdb) using my servlet application . I need to read the data in .mdb file and format it to display on the web using my servlet application (or JSP)..How can i read data from .mdb file? I have never worked …

I am trying to populate a gridview from an Access database and am running into an interesting issue. The database is populates with data, but when I do a very simple Select * From it returns an empty data message. I tried putting together a test page with only a …

Hello, I am new here. I would like to ask opinion from you guys on what are the best options available for me to develop a database system using Visual basic? I am using Visual Basic Express Edition. My problem: I am currently developing a toolkit that needs the user …

hi i m making a c# app which reads data from ms accesss & display it in textbox i have tried the following method but that didn't worked suggest me smthing or correct my code pls myconn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\nature bliss\Desktop\Stock\section1.accdb;Persist Security Info=False"); try { OleDbCommand cmd = new …

Hi i finally done my first project and thanks to those who help me here in daniweb. Special mentions @Reverend Jim and @TnTinMN. But when i run the setup to install it in another computer which is a 64bit. My project didnt connect to the database which is access. But …

Hi to every one .. I have Access database Access 2007 . and i need to connect with ASp.net ..nad i put database in db folder but it gives errors ... if provide Database1.accdb in connection string (following error) Unrecognized database format 'C:\Documents and Settings\erum.mirza\My Documents\Visual Studio 2008\Projects\ajax\ajax\db\Database1.accdb'. if provide …

I'm Developing A very Basi App For Generating Bill On A retail shop I'm Using Access(mdb) As Data Base The Table with Name "Invoice"(Holds grand Total And Deposited Against That Invoice) On which I wants to perform task has fields As Follow: InvoiceId , CustomerId , CustomerName , InvoiceTotal , …

i'm helping a friend and i'm almost done with the program what i can't figure out is i need to sort the number of votes from lowest to highest my database is just ms access and i'm trying to display the photos of the candidates who got the highest votes …

hi all, i am doing my java project (video player). This is the task : Enter a video number and click a button to add that video to a playlist. If the video number is valid, the video name should be added to the list and all the names in …

I have an access database which I am using with .net, I can search tables and maker very specific searches no problem, trouble is that I can't work out how to make global searches. IE search entire databse for "fred" or search a single table for "fred". Anyone know what …

I have a problem with retrieving data from access databse. I make the connection and retrieve the data no problem. But when the data changes from another use of the database, I cannot get the new changed data without reloading the complete programme. Even repeating the load functions does not …

Hello guys, I have a school assignment and I need to develop a site with Microsoft Access database, but I have no clue how to set up and use that database, I searched eveywhere on the internet and I haven't found anything concludent, all explications are foggy and I can't …

i am using "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\My PC\Desktop\MOMS 3\MOMS2\WindowsApplication2\MOMS.accdb" This is the path to connect with the database. can you one tell me any other way i can use instead of this. I want to use the program on other computers. I tried "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|Data Directory|\MOMS.accdb" and "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & application.startuppath & …

I have a database which I need to select all data in a particular column, automatically as long there is a data stored in that column then use that all data(Phone numbers) in sending msg (My system was Send Message System). I already have done sending one by one , …

Hi Guys... Putting together a Tiny little app which shows VPN Details for use 'In-House' but for some strange reason my DataSet won't fill? Can anyone spot the mistake? :S private void Form1_Load(object sender, EventArgs e) { //XML Load of Document. This loads the XML Document and the value of …

I am developing a VB6 application which connects with an Access 2010 database. I want the application to execute queries stored in the database. Some of the queries include Access functions in field names. For example- FieldName: IIf(Nz([AnotherFieldName],0)=0,3,[AnotherFieldName])" Is there a way in VB6 to execute the queries natively in …

Hi everyone, please i am writing a program in C# for connecting to a microsoft access database using visual studio 2005 and ADO.NET. i want to be able to use Dataset to update,delete,insert and edit records in the database.please how do i go about this.I already have aform with a …

I have a 3 columns in my MS access database namely ID, Name and Type. The Types are Driver, Conductor, and Inspector. I want is i click a button, all names in column "Name" that is classified as Driver will be the items of my combobox, also the other two. …

**I am building a hospital managment system as a practice in visual basic. I am having some problem I want to write or read data from particular row or column with visual basics How do I o it? Thanks in Advance -Hassaan bin Jalil**

just want to know the correct synthax for creating a table in access database using vb myqry = "CREATE TABLE HoldInvoide'" & k & "'(Barcode varchar(20) not null Primary Key, ItemName varchar(40) not null, Quantity int , Price double, Total double)" k is a variable i want to create a …

Hello guys, I'm working on my code vb.net to save data into access database. I'm kinda lost right now. Couldn't find the solution to the error. it highlight on dbcommand.ExecuteNonQuery() as state as the title problem. Here's my code. Appreaciate the help. ` Imports System.Data.OleDb Imports System.String Imports System.Windows.Forms Imports …

i need some help how can you save the item in my textbox to the access database? For example i have Firstname.Text Middlename.text Lastname.text if i click the add button it will save it to my access database and also if i want to edit it and update it, how …

I've been battling with this for the pass few days. I have an access03 database that is used to track training that we give to employees. i had a form that has, the training info and then a subform that lists all the attendees and their scores. Now I was …

Hi i wonder how can i delete my data using access as my database? for example i want to delete Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source='" & ConAccessDatabase & "';") Dim cmd As OleDbCommand cmd = New OleDb.OleDbCommand("delete * from [" & EBU2DB_LOB & "] where Brand ='" & …

Hi, I've never really created a login screen in VB and connected it to a table in MS Access before. So I'm supposed to create a login screen and after gaining access to it, a main menu form needs to show up which would be connected to the rest of …

hi! can you please help me. I want to count all "OPEN" in my status column. im using access for my database. thank you!!!!

string location = Environment.CurrentDirectory; string connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" + location + "\\harita.accdb"; // get records from the Shippers table string commandString = "Select x from map"; //create the data set command object and the DataSet OleDbDataAdapter DataAdapter = new OleDbDataAdapter(commandString, connectionString); DataSet ds = new DataSet(); // fill …

Hello, Here is the scenario : I have the follwoing sales return from in my software:  In the from I have tow listview control, the left is Listview and the right is Listview1. I have the following code in procedure : Dim xsprice As String Dim xsprice1 As …

I am trying to retrieve all the names of the mp3 files from my hard drive, heres the full code, what i am facing is "Access to the path 'D:\System Volume Information' is denied." error, but i have changed the manifest file as below [ICODE]<?xml version="1.0" encoding="utf-8"?> <asmv1:assembly manifestVersion="1.0" xmlns="urn:schemas-microsoft-com:asm.v1" …

Hi guys, I'm hoping you can help here with a problem I am having with regards to filling a Dataset. It was working fine but have had to amend the code to read a different data set and structure. Basics are 2 tables.. one customers, 1 orders. Joined on there …

Hi, Here is the code I’m trying to execute using MS Access database to return a dataset. And i get the error "No value given for one or more required parameters". Public Class Main_Form Dim conn As New OleDb.OleDbConnection Private Sub btnReset_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles …

MY code doesnt saves the data entered through dropdown box into access database

Hello! I am currently developing a web interface that has access to an MS ACCESS database. However, I am unable to key in more than 6 Values into the database using the INSERT INTO sql code. Here are the codes that I am using: protected void bnAddPart_Click(object sender, EventArgs e) …

Good evening! I'm trying to figure out how to retrieve and display data from MS Access to my project's DataGridView. So far I have the codes to make the options for the CheckedListBox appear. SAMPLE: (Codes for other categories are not included since they're all basically the same) 'view client …

I've got 2 flex grids in one VB form and I wanna connect both of these Flex Grids to 2 different tables in MS Access. This is how my form looks like: http://i213.photobucket.com/albums/cc228/rose_408/form_zps100c290c.png Here's the code for the service flex grid (FlexService): Private Sub Form_Load() Set conn = New ADODB.Connection …

How does one connect an Access Database to Visual Basic 2008?

Ok, so my form displays an error saying "run time error. could not find installable ISAM." everytime i run it. And its pointing at "conn.Open" part of the code when i run it. heres my code: Dim conn As ADODB.Connection Dim rec As ADODB.Recordset Dim rec1 As ADODB.Recordset Dim rec2 …