[microsoft:access] Forum Topics

how to insert , update and delete records in vb.net Database and Access as the Back End

Hello! I've got a question here that has me scratching my head - I've got a table of IP addresses. Each octet has its own field (OCT1,OCT2,OCT3,OCT4). The first two octets are fixed, and will never change (so, the IP addresses on my table are between X.Y.0.0 and X.Y.255.255). As …

I am using Like operator in ms access query to get part of string.This query runs well in ms access query wizard but when I use this query to retrieve records in recordset,recordset is null. Also I am using update query with like operator.Records are not updated and also no …

I am having trouble getting the codebehind to execute properly. I am new to c#.net, what I have is a web-based log in form that when the user enters their username and Id it will check against ms access to verify the username and password. I am getting this error …

Hey Guys, I'm an A level student studdying Computer science, and hence using VB.NET for my coursework. Therefore I'm very novice at VB! While trying to update Data in a Microsoft Office, Access table (Office 2010) - I get this error. (In VB) Bare in mind, I've read all this …

Hello everyone. I am building a small database that will hold information about volunteers and their talents. I have created a search form, in which the user can enter a keyword and it will search the tables for any match. Currently I am using a criteria of: Like "*" & …

Hello everyone. I have build a simple MS Access database to keep track of volunteer info (contact, address, phone etc). I have a report that displays each record in a list: record1. Last Name, First Name, phone, email record2. Last Name, First Name, phone, email etc... What I want to …

I found a tutorial online that so far has been aswesome. I downloaded the access db and so far can read and browse through it. However, when I try to write back to it (btnSubmit_Click), nothing happens. All other buttons work fine, I can still browse, and I get absolutely …

Why do I get an error creating a temporary table with something even as simple as this:"CREATE TABLE #Results"? But this "CREATE TABLE Results" works. I thought we put # when we need to create temporary tables (Access), its like I've once done that. Help on that please? Thanks!

Hello , I'm trying to make an Update query but keep getting the following exception : "Data type mismatch in criteria expression" Here is the query : UPDATE PatientData SET PatientData.[Transaction Stop Time]='6/26/2010 1:07:12 PM' WHERE PatientData.[Patient ID]=6 AND PatientData.[Parameter name]= 'Temperature' AND PatientData.[Valid start time]='9/7/1999 12:00:00 AM' additionally, when …

Hi every one I'm trying to retrieve UserID (which is autonumber in ms access database) using C# and assign it to string u.I'm totally new to C# and trying to get more skills.... here goes.. string connStr, selectCmd; connStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=..\\library.accdb"; selectCmd = "SELECT * FROM users WHERE First_Name …

Sub empno() ComboBox2.Items.Clear() sql = "select empno from tbl_empinfo" If rs.State = 1 Then rs.Close() rs.Open(sql, conn) Do While rs.EOF = False ComboBox2.Items.Add(rs(0).Value) rs.MoveNext() Loop End Sub how do i write this for an access connection???

Actually I'm doing a project to maintain the company info, here i wanted to write a code to check whether the company id already exists or not. that is if the id 123 is already present in the access database then it shuld show the msg that it already exist. …

Creating a Report in Visual Studio 2008 In this section, you create a report that draws its information from the sample Microsoft Access database that ships with Crystal Reports. To create a report with secure data from the Your database follow these steps . 1. In Solution Explorer, right- click …

Hi All, I have Code on PC1. and Access DB on PC2 . I have shared Folder on PC . And very much able to access from PC1 with full ownership. Now I was trying to connect Msaccess from PC1 using below code. cnn.Provider = "Microsoft.ACe.OLEDB.12.0" cnn.Open "Data Source=\\192.168.0.1\Public\tels.accdb;Persist Security …

hi. im developing an inventory system. my problem is i need to create a datareport with date range so i created a query in ms access and i got the result but to get the result i should run the query first then a dialog box will pop-up to get …

Hi All, Sorry if this isn't the appropriate place to put this question, but I'm new to the forums. My issue relates to ASP and a DSN-less connection. I have a website, which was built quite a while ago using DSN connections to an Access database, which ran on a …

Hi, I need a little help here. I'm Using vs 2005 with ms access 2003 database and finding myself how to get rid of this error "Syntax Error on UPDATE Statement" can you take a look at my codes below and tell me what's wrong? Thank you. Public Class Transactions …

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); PrintWriter out = response.getWriter(); try { int c=0; String u1=request.getParameter("u1"); String e1=request.getParameter("e1"); String user=request.getParameter("user1"); request.setAttribute("u1",u1); request.setAttribute("e1",e1); request.setAttribute("user", user); out.println("welcOme"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con =DriverManager.getConnection("Jdbc:Odbc:db5"); String str = "select * from Table1 where email=?"; out.println("welcOme"); PreparedStatement statement = con.prepareStatement(str); statement.setString(1,user); ResultSet …

I am trying to insert new records into an Access DB and getting some weird stuff. I get the data from a DBF table and load that into a dataset table and DataGridView with no problems. Then I loop through the ds.table and insert it into the DB with this …

hi i need some help, i need to creat a file in access 2003 running a aplication asp.net (c#) using a sql query, if anyone knows that plz tell me:) thanks

In MS Access2007, I want to query ([I]q_Notes[/I]) a table ([I]t_Notes[/I]) in which one of the fields ([I]t_Notes.Topic[/I]) is populated from a Combo Box based on a field in another table ([I]t_Topics.Topic[/I]). I will have a table of several hundred records. I want to use the q_Notes query as the …

hi every1 i m creating a simple ms access project. i created a report ,when the user opens it,it opens a query which askes user to enter name. the user enters the name and the report by that name generates. is there a possibility that when the name is asked …

Hi all! I need help with Visual Basic I am trying to build a program in which the user types a question into a text box. Then the program looks for that question in a database (access database to be specific) and returns the appropriate answer from the database. I …

How can I connect my msacces database and use SQL query command like "Select Field FROM Table Where Field1 = foo AND Field2 = foo2" in Visual basic 6 and display the query result to a textbox.

Hi i am using java code to connect to MS access using following url jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/login.mdb Now if I need to connect to the run this java code from some other machine in network then how will I write the path "DBQ=C:/login.mdb"

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 …

Hi. I'm fairly new to VB.NET programming, and i'm currently developing an application for the sake of experience. What i know about Visual Basic programming might be considered dangerous, but none the less, i'm trying. I'm having difficulty getting past the idea of how to update a record in a …

I have a problem that hopefully someone can shed light on. My OleDBdataadapters and OledbTableadapters have gone on strike!! In a simple vb.net 2005 pro project I have an Access 2003 .mdb with 2 tables each with 1 primary key and all other fields allowing zero length and not required. …

I learnt to create a exe file of a project from this link [Click Here](http://www.fordevs.com/2009/07/steps-to-create-setup-and-deployment-project-in-dot-net-vs-2008.html) The app that i am creating requires a database...i.e, it has a login form which verifies the data entered with a ms access database...how do i include that database file in the exe??? to create …

HELLO. IF I CLICKED BUTTON "SAVE" MS ACCESS ITEM WILL BE UPDATE FROM LISTVIEW.

as i declare the first one field is combobox and another one is text box. then if click the combobox value then corresponding text value to be displayed on text box.how to proceed to coding in ms access.

I wish to save and retrieve image in access 2007. in our search module , if employee number typed, it could retrieve all information of the employee including the image saved in database(?) if this can be happen?

I have a situation where that i want to make a system where i can generate **multiple unique number** for **lucky number**. Example : Name: John Resit Amount : **$50** **Lucky Number** : **1000 , 1001 , 1002 , 1003, 1004** John bought something that is $50. For **every $10**,he …

Hi all, I have a form on my program, and I have two comboboxes that I want to fill with data from columns in my database. I've tried three or four different ways that I've found searching around the web, but none of them seem to be working. They don't …

NEED HELP! in making this hope someone can help me in this project,,, am not a good vb programmer,,,in other word i am a newbie... i need to pass this in 2 days,,,, i attached the user interface and the access to make a database of a payroll system... ,,,, …

Hey guys, I am working on an application for my school and work. I work for the It team that maintains and checks the AV equipment we have around campus and solve the problems associated with them. We usually just mark them down with pen and paper etc. Im trying …

I'm having trouble deploying packaged access programto the web for download. If I zip the package and upload it, when it is downloaded it will not unzip because it shows as not being an archive? If I upload the entire package, including Access Runtime, I can't access the package because …

Hi Guys.. I've found a little tutorial which seems to show exactly what I have been trying to do which seems to work upto a certian extent. The code I am using is the following: **Code:** using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; …

I need to update my Microsoft Access database 2003 from my server automatically. but i don't have any idea how to do it. Please help i really need this for my thesis. Thanks!

how do i link ms access 2007 with microsoft visual basic 6.0

In my program, I have a section to insert information about a customer into an Access database. I get the error below at the .ExecuteNonQuery. Message: System.Data.OleDb.OleDbException (0x80004005): Field 'Customer.Business_Phone' cannot be a zero-length string. at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& …

Hi, I am writing code for connecting to an access database in my windows 7 machine. Am using visual studio 2010 with access 2007. While debugging the code am getting the exception **"The 'Microsoft.Jet.OLEDB.4,0' provider is not registered on the local machine"**. Below is my code, Try connection = New …

Would be implementing a system which database is shared accross LAN nextweek. Scenario: All 5 units are of the same OS (Windows XP) * 1 Server * 4 Client Database is MSAccess 2007 * (but 2003 format in case of compatibility issues) Now here's my checklist: * Make sure all …

hey friends,i need ur help.i need to knw how to insert or add a row to datagridview(using oledb) where the values inserted must be automatically updated in access database. thanks in advance...

hi Folks, I haven't used access in a very long time, so i'm a little behind the 8 ball with it. I've got a date selection form (frmWhatDates) with txt boxes txtStartDate and txtEndDate. I want to send those values to report rptAccuracy rptAccuracy pulls from query qry_report_totals_sorted (which just …

Private Sub cmddelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmddelete.Click If Not acsconn.State = ConnectionState.Open Then acsconn.Open() End If 'sql statements strSQL = "DELECT * FROM Table1 ([Item Code], [Item], [Sale Price], [Purchase Price]) values ('" _ & txtid.Text & "','" _ & txtname.Text & "','" _ & …

First, if I am not in the correct place, please let me know. I am a novice needing help. I have a single DB (Contractor) with 17 various fields. The purpose is to track the type of license they have, i.e. plumbing, electrical, HVAC, general, etc..... One contractor can have …

Hello guys, i am facing problem while updating database. I get "data type mismatch in criteria expression" error when click update button. Necessary info: *The database i am using is creadted ms office acess appliaction. *I have created a module where i have putted connection data in a sub function …

Hi I just completed my database hospital application and now i'm ready to export it into a JAR file. I palced the DB in the classes subfolder and played with ClassLoader but got nothing! I used the following code String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; String url="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=f:hospitalDb.mdb;}"; any idea …