[microsoft:access] Forum Topics

Hey guysz. I had follow up the Daniweb discussion on VB6. I tried to develop a software based on what I got. It is a similar to library system (it is a different program actually). Thanks alot ^^. Now I almost 80% done. So I need a little help 1. …

okay. Here's my problem. I have a form in which a Microsoft Hierarchical Flex Gid (fgdCompany) is used to display records taken from a database to relavent textboxes on the same form. When a record from fgdCompany is clicked, then the data in that record is shown on the textboxes. …

Dear,programer I use VB2008 and database access and Crystal report. my problem : when ever I change location the database. I will always change location in my report from crystal report. It's very difficults and waste the time because I have many report. Please help me how to set up …

hiii all, I am developing a website with a webform in it. i want that when user clicks the submit button ......all the data filled by user should come in my MS Access database table which have the same fields.. I have connected the database. webform i have developed in …

I have this code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.OleDb; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace Access_Database { public partial class Form1 : Form { private OleDbConnection myconnection; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string strconn = …

Okay, so here's my problem. I have a MS Hierarchical Flex Gird Control [fgdCompany] which is used to display records that are taken from a database. Everything works great but not the Delete button. What the delete button is supposed to do is when a record is selected in fgdCompany, …

I created an ms access database and a form to enter data to it. I want to launch that form without opening access. How can I do that? Thankx in advance.

Hi. So I get this weird error message out from a QT application that i'm creating: 0xc0000005: read access violation at: 0x0, flags=0x0 Basically what I'm trying to do is to set in a QT List Widget an item of type QList Widget Item in which I store two things: …

hello to all and thanks for giving all help to newbees, i have a form in visual basic 2010 with these specification 1 datagridview 7 textboxes 7 comboboxes 2 datepicker i use a connection with code to ms access. i am using this code to load data in DGV and …

Hi, I have email which contains some data and i want to update that into a database using MS access 2007 need help on creating a form and a database in MS access 2007 would appricate if some one can help me from scratch as i am noivice when it …

I have databse in access 2007. my date datatype is Date/Time. I have made function to insert values to database. But it is showingd syntax error(missing operation)..." for insering date. Please help me how should i do i have tried hash in front of date and tried to save with …

How can i check or see the print preview of datagridview where my file is an access file and pls give me sample code.

Situation: need to read a CSV (txt) file that has no header and has 4 fields (all numeric), the number of lines will vary. Sample data: 160827,00003,000000075,0000025 84144,00001,000000050,0000050 161060,00002,000000050,0000025 40015,00002,000000100,0000050 61955,00002,000000100,0000050 etc etc I want to read this file into a DataGridView for proofing and later insert all these lines …

Hi! This is my submission for code snippet contest. I also posted this code to help other members on how they can use compact & repair their MS Access Database within Visual Basic 6.0. You also need to add Microsoft Jet and Replication 2.6 in your project reference. To use, …

hello, im have problem with my code..im used access database, when i select combobox1, the textbox will appear data set as value member....but data not appear on textbox..someone can help me :) this my code Sub fillcombo() Dim acscmd As New OleDb.OleDbCommand acscmd.CommandText = strsql acscmd.Connection = acsconn acsdr = …

how to save records in listview into ms access database table using a button , i've tried with my codes but nothing is saved in the database `Inline Code Example Here` private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click Dim con As New OleDbConnection con.ConnectionString = …

How can i insert data from access file into listview in C#? Thanks

does anybody know how to create a login form in vb.net? I have an access database and I am trying to create a login form with a user name and password to have multiple users login. Please help.

i have a datagridview in my vb.net form displaying data from ms access file A , table A , is it possible for me to export the data in the data gridview to ms access file A table B?? i'm not using sql.

Hi, I am trying to check if the username entered by the user in the textbox exists in the Access database I am using. For some reason, I am unable to get this correct. My code is as follows: Protected Sub btnRegister_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles …

Hi, I have a complete ms access system build(tables, forms, reports, query). I am in the process of using vb to re-create the system. I managed to show every fields on my vb forms without any coding. However I have some wrong information in my combo boxes. For example I …

what is the equivalent of Access DMin and DMax function in VB.net?

Hi, I am trying to delete data from dataGridview, and update my Access database, but I am having trouble withe these code it keep stated that I have "Object not set to an instance of an object" and I don't know where my code went wrong, please help, I am …

im having trouble with this oledb commands im just a starter using this commands why can i not add to a microsft access is my insert declaration wrong can i give my code just for you to check it if something is wrong?

can someone please help me?.. how can I edit my database from microsoft access in a datagridview?please help me I need your answers

Hello all :) I am still a beginner at ASP.NET and VB.NET so I could use all the guidance I can get. So thanks in advance :) I am building a web application using Visual Web Developer as the IDE and Microsoft Access as the database. The application allows users …

In C# ... How can i search my access database by some column(other than the primary key).. for example if i want user to search entries by Entring last name in a textbox .. and this could have more than one entry and show the results in the grid view …

Hello - I'm looking for advice on the best way (or possible ways) to set up a project for work. I have access to our companies internal web server (for employees), and a MS access database that all users have access to, located on a shared network drive. I need …

Hi, I'm writing a database for a computer shop and need some examples to look at. (It's not for a real shop, just a little project of mine) Where Can I find some templates for Access Database templates for a business like this?

Hi, i need to know how to convert ms access database to work on sql. Any help would be appreciated. Thank you

Hi Guys, I've been asssigned to do a pharmaceutical supplies database using Microsoft Access in 1 week time. I only think of 3 tables, that is Clinic, Supplier and Items. Can I put supplies as a table too? If yes, what will be the content of the table? If no, …

Hi, I am using MS-Access 2003, VB.NET 2008, I am able to select and delete recordes. But how can I move between records? Imports System.Data.OleDb Class Window1 Dim cn As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.Windows.RoutedEventArgs) Handles …

hi, i made a form that its pupose is chatting... very simple one, one user talks with another one. so there is two INSERT simultaiously. Sure, i put the mdb file on shared folder, EVERYONE have full control, the mdb file is NOT read-only. when only one chat form loads, …

Hi all... I hope you have good time .... I have problem in the new program and I want to your help .. I want to back up the database type from Access, but my problem I could not generate code to determine the path of the database, I noticed …

Here is a class to SQL use an access database: Class MyDB Public DBName As String Private con As New OleDbConnection(ConStr) Sub New(ByVal DBN) DBName = DBN End Sub Private Function ConStr() ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DBName & ";" End Function Private Sub ConInit() If con.State <> ConnectionState.Open Then …

Hi, I have a MS Access 2003 (.mdb) database called "Assets.mdb" which I display in a datagrid. When I edit entries on the datagrid and click my save update/save button upon reloading of the application they have not been saved. What am I doing wrong? Private Sub btnSave_Click(ByVal sender As …

Hi, I 've been working in a VB project in which i need to check the size of a MS Access DB I need the code to perform this function Thanks in advance Andrew

Hi Can you please let me now how I can create a connection betwen my application to a Ms Access Database on the server using VPN connection method? I have a database created on a folder on server which is accesible just by VPN connection. Thanks for your time

I am trying to program the last part of an application which needs to take data from an Excel sheet and add it to an Access table. I'm using Excel 2003 on XP. Any and ALL help is appreciated. The problem I'm running into seems to be on connecting to …

<html> <body> <%@page import="java.sql.*"%> <form method="post" action="csea.jsp"> <table border="1"> <tr><th>Reg No</th><th>Name</th><th>Present/Absent</th></tr> <% String pa = request.getParameter("pa"); try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:Student"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from student_details"); while (rs.next()) { %> <tr><th><%=rs.getString("reg_no")%></th><th><%=rs.getString("s_name")%></th> <th><input type="text" name="pa"/></th> </tr> <% } st.executeUpdate("update csea set pa='"+pa+"'"); con.close(); …

Hi All, I have a access database with these columns. USER_ID,COUNT,TIMES Let say the current record is this: USER_ID,COUNT,TIMES STEVE20,24,1.5 Now I want to updated the current count record and times, but before updating I want the old record to be added to the new record. What should be my …

#**Can anyone please tell what are the differences between Microsoft Access and traditional DBMSes (i.e. SQL Server, Oracle, Postgres, and MySQL) in reference to how they handle record-locking, rollbacks, and database updates? **#

When I select few records from datagridview and insert into access database. First selected record will last insert into database and last selected records will insert first. I got give a number to each record. For example, I got 3 items. When I select this 3 items and insert to …

I want to update my database but the problem is that the driver is not taking any values from the preparedStatement. I am getting an error : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] You must enter a value in the 'ClassicRoom.Occupy' field. Press any key to continue... Here is the ActionPerformed …

Hi Guys, I have created windows application project in framework 3.5, vs2008 with Access database when i changed target platform to x64 it will give me an error like 'The microsoft.jet.oledb.4.0 provider is not registered on the local machine'. How to solve this thread Thanks in advance.

Dear All, 1. How can i enter data in flex grid and then press save button to enter data in access db with out using text boxes? 2. How to bind record set with flex grid? Please give me sample code which should for add edit delete data from db …

I HAVE MS ACCESS DATABASE OF 'STUDENTS' containing Their roll no's, names, min marks and max marks. As like schools publish results on their webistes, there is a text box in which roll no. is entered and the command button for searching the whole record of roll no. entered in …

I want to know how M/S ACCESS database can be connected to html page hosted on local host

How to link MS Access Database with an HTML Page...? If both data base and webserver are on same server.

I am trying to delete a record from a table by using dao recordset. Currently I am working with the code listed below. Unfortunately i've realised that this code only deletes the first record in my table, whereas I am looking to delete a record form the table with an …