[microsoft:access] Forum Topics

please let me now the script how can i send the data from datagrid to access(.mdb) table

connecting access 2003 database from remote computer .I have a vb2005 application which uses access2003 database. I want to connect to this database via remote computer connected via internet.

dear all, i am creting internet lab management project for diploma ,I am trying to save web browsing history of google chrome,ie and mozila by the user in his login.. can you just tell me the way to proceed. not getting how to start for this.

Hi Guys, The reason for my message was to do with UPDATE and DELETE Statements from within C# when contacting a MDB file. I currently have the INSERT INTO SQL Query working perfectly The Code I used for this is below: else if (radioButton2.Checked == true) { //Creates new versions …

Hi guys, I am building a program which has 5 forms, 1 mainmenuform with 4 buttons and each of them buttons have a form corrisponding to that button and this program is connected to my access database. The problem I have is I've put all my code into my first …

Hi Guys, Right... I've managed to run select statements with associated Joins to show the data I want in DGV's which is great. Seems to be working fine. I'm not to the point where I need to be able to Insert, Update & Delete Rows in my Database. I am …

I want to access some data in an Access MDB but I want to make sure that nothing can be accidentally altered. I have tried: conn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB;Mode=adModeRead;") I've also used conn = New OleDbConnection(Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Test.MDB;Mode=Read;") I then run a quick UPDATE WHERE query and it still alters …

Good Day All I imported data into a Ms Access 2013 from SQL and all the data is there. I created a Query and also created a report that will use the Query. So the Query returns all the data. There are around 590 000 records that needs to be …

Hi guys i have this code which insert the data in the textbox Dim FilePath As String = "C:\Users\ezekiels\Desktop\New Folder\EBU 6.mdb" Dim conn As New OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & FilePath & "") conn.Open() Dim myadapter As New OleDbDataAdapter("SELECT * FROM Table_EBU6", conn) Dim dtset As New DataSet myadapter.Fill(dtset) myadapter.Dispose() Dim table …

Is there any way to create a meaningful list of all files on a device (drive, folder, usb stick), in such a way that they can be read into e.g. an MSAccess database, including directory structure, etc.? When using the DOS based Dir to create a text file, the actual …

Hi, I'm making a webpage where it allows users to online book like let's say on a hotel, how do I show the users on the site the unfilled slots (dates and time) on the database? I'm using MS Access.

OK, I've exhausted my searching, so if someone can point me to a link with a good example, that would be super. I'm simply trying populate a combobox with data from an Access table (it's a simple contact list with Name and Number). Every example I find and try, I …

hi i'm very much new to vb. can any body solve my smaaaall problem...? my problem is; i have a form, in that, two textboxes and a button are there. that is connected (i dont know how to connect, excuse me) with a table in ms access 2007. when i …

Hi, I just need some help on how will I retrieve the last row ID(auto-increment) value of my database(ms acccess) and display into a textbox? thanx in advance

Hi, I have an access database where in i have 3 separate fields for day, month and year which are comboboxes. I have an separate field where i need to combine these 3 fields into that single field(dd/mm/yyyy). can somebody help me on this please.

As title show. I still not able to connect my ms.access login database . Please help me ~ Dim con As New OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\leong\Documents\Visual Studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.accdb") ' Dim cmd As OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM AdminUser WHERE Username ='" & Usernametxt.Text & "' AND Password ='" & Passwordtxt.Text & …

I'm trying to search on how to store the image in a local folder and save its path and filename in ms access using vb.net but a lot of topic makes it more confusing for me. I'm just a student and working on my baby thesis. I'm currently building an …

Please help me solve these errors that I usually receive. I've created an application that reads, updates, and inserts a record into an Access database. But every time I press the **Update** button to update a record, I usually receive this error message "**Syntax error in UPDATE statement**". On the …

How can i link database from microsoft access 2003 with VB.NET? can i use anything from eg. Form1 and display them on Form2? thx u very much.

Hello everyone. I am trying to build a inventory and pos software with vb 6.0 and MS-Access as database. In one of my form I have the following code to call my inventory of a certain invoice number to print tag for my products. I am using a MSHFlexgrid with …

Hello experts i am using following code in order to truncate a ms access table Dim con As New ADODB.Connection Dim rec As New ADODB.Recordset con.Provider = "Microsoft.Jet.OLEDB.4.0" con.Open App.Path & "\db.mdb" Dim query As String query = "truncate table tbl" rec.Open query, con, 2, 3 con.close but its producing …

Hello DaniWeb, I personally work with SQL databases for web development work however I need to learn about Access databases for some upcoming AS Level exams. I asked my teacher, whether Access was vulnerable to Injection attacks and she looked at me with a quizical expression on her face so …

I have a volunteer database and having trouble with genuine password protections. I have a "delete" button with this current code under Build Event: Private Sub delete_Click() On Error GoTo Err_cmdDelete_Click DoCmd.SetWarnings False If MsgBox("Delete this VounteerRecord. Are you sure?", vbQuestion + vbYesNo + vbDefaultButton2, "Delete?") = vbYes Then DoCmd.RunCommand …

Hi, Could anyone solve this for me. I'm using VB 2010 and Access Database file. The database consists of a table called 'usertbl' with 'username', 'type' and 'level' fields. The records are as follows: Record 1 - Username: admin Type: admin Level:1 Record 2 - Username: user1 Type: user Level:2 …

Microsoft Office VBA is a language many of us love to hate. I am no exception, but I know better than to kick the cash cow that feeds me. As it is, the grand and spacious realm that is DaniWeb lacks a VBA forum. There's VB.NET, VB4,5,6 and Legacy Languages. …

I have a calculated field that takes the ID field of a table and pads it with leading zeroes. So far, I've gotten this to work: `String$(4-Len(Trim$(Str$([ID]))),"0") & Trim$(Str$([ID]))` Broken down, it takes the ID field, and string-ifies it. For some reason, this pads it with a space, hence the …

Greetings, DaniWeb! I have an Access DataBase with a Form I need to modify. When the user moves between records, I need to trigger an event. Is there an event that triggers, and what is it? I know it's not Form.Load. Thanks, DaniWeb!

I'm creating a password protected Volunteer Database and everything is going well. I have created a 'password protected' form before entering the hidden database(seperate form). How though am I able to prevent a 'user' to find out the password by going through "Build Event" in Access?

Hey all, I am having trouble with a query and nonquery in C# while accessing an Access database. The query I am having problems with is using the LIKE statement in the query. sqlString = "SELECT * " + "FROM Convocations " + "WHERE Name LIKE \"*" + txtFilterParameter.Text + …

hi friends. i want to add a picture a picture in crystal report from database at runtime and show in crystal report using VB.VET . i'm using Microsoft access database, visual stodio 2010 and SAP crystal report 2010. please help me i m so abset.

Hi, I have a database (OLEDB) on which i perform operations like insert, delete and update. When i carry out these operations, the changes are reflected in the database during runtime but when i close the form everything goes back to normal. How can i get these modifications to relfect …

I am totally new to vb.net, still I am planning to try it for a project, in which there will be standalone machine using an access database to query and update different tables. While in VB6 I was able to define recordsets using Microsoft.jet.oledb.4.0, in VB.net I have become a …

Hello everyone. I am developing a inventory and pos software myself with vb 6.0 and ms-access as database. In my sales invoice I want to generate the sales invoice number serially. I mean when I load the sales invoice form the txtsinvno text box will automatically generate the sales invoice …

Hello, I have been struggling a little bit with an issue in a relational database that supports queries. Originally I was going to use an OleDB data adapter and connect to an Microsoft Access database (created with Access 2000). The problem is that when I use a connection string like: …

Hi geeks!! im working on a project (in visual studio 2008) where i need to create a reminder which will prompt every month for showing the actual state of fees a number of customers have left to pay. the project uses access as database and will have a fixed amount …

I'm having a problem updating records from my VB.Net application to the database (Access Database). I've tried all sorts of update technique and i keep getting either "syntax error in update statement" or "data mismatch in criteria expression". heres the code i'm using: Public Function save1stsemester() 'this code updates 1st …

FOR FOLLOWING CODE <%@language=VBScript%> <%Option Explicit%> <html> <body bgcolor="aqua"> <% Dim myConn Set myConn = Server.CreateObject("ADODB.Connection") myConn.Open = ("DRIVER={Microsoft Access"&" Driver (*.mdb)};DBQ="&"C:\Inetpub\wwwroot\tizagASP\razor.mdb;") myConn.Close() Set myConn = nothing %> </body> </html> I GOT FOLLOWING ERROR The page cannot be displayed There is a problem with the page you are trying to …

hi, may i know how to compile visual basic 6.0 file with access 2007. I can link but when i save it in an external device and try to run th exe. in other computer, it could be run, but the connection is lost, i tried to change the location …

I'm trying to use Microsoft Access to produce a contacts database for a local charity. Unfortunately I can't get my head completely round relational databases. I understand the basics but can't solve a particular problem. Can anyone help? I currently have four tables (Contact, Organisation, Children, SpecialNeeds) that need the …

Hi, I have a Vb.Net solution that contains several forms that read/write to an MS Access database. My problem: When I copy my Vb.Net solution and Access database to a new computer, the data source connection string needs to be changed. Currently the data sources wizard sets the connection string. …

I need some help to make a order form in C#. My development environment is: Microsoft Visual Studio 2010 Ultimate SQL Server Express Edition 2005 Programming Language C# Sample Database = NorthWind (Tables Orders and OrderDetails) I've create a form for order entry, which contain a textbox for OrderID, a …

PLEASE HELP !!!! I MAKEING A PROGRAM FOR MY SHOP........... BUT I DON'T NO HOW TO SAVE MY ALL SALES INVOICE MS ACCESS THANK YOU IN ADVANCE

Hi All, I would like to thank this community for the enormous help to develop my skills. Thanks. I have 2 databases and a single report form and a crystal reportviewer. The User can select the database which he want to work (Each of them belongs to different warehouse) So …

I wrote a C# code called parent. When i run the program and try to add parent details to the database( microsoft access 2010), it gives me this error: Exception in DBHandlerSystem.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement. 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) …

hi, can anyone please check why im getting dataype mismatch error... im using combobox and msaccess db which consist of formNo(autonumber) LastName FirstName MiddleName Address (text) ... if i use address as valuemember there is no error,, but if i use FormNo as valuemember then there this datatype mismatch error.. …

hi dears.. i have really big problem with save values of checkedlistbox in one field but i can't do it..what can i do?? is it a database or code problem?? i want the data save like this: 1;2;3 for example..is that possible?? plzzz help..

Being somewhat new to VB.NET, I built a data solution by using wizards and drag-and-drop on forms. My data is in an Access DB and I opened up those tables with Server Explorer and dragged them into my dataset. I connected the tables to datagridviews. Worked like a charm. Then …

how to get null field value from access in vb6 in my 2 record field the value is empty but i'm not able to get that empty field in vb6 ... .... set rs = new adodb.recordset rs.open ("select * from table1 where id = '2'") text1.text = rs!name please …

Hi, It is possible to make a software with a database such as MS access and make it available for everyone without need of a server or without a need to install the database software and/or make the database from scratch? Thanks Mario

trying to create table in Access2007. CREATE TABLE user (id Text(8), last Text(25), first Text(20), class Text(10), dob DateTime); but table is not being created. ERROR: query must have at least one destination field.