[microsoft:access] Forum Topics

I have two forms "Sales" and "PurCh". The datagridview in the Sales form is being populated by a stored procedure that is carried out when the form loads and it works perfectly. But the datagridview from the "PurCh" form has refused to populate when the form loads. I initially thought …

i have a problem here. Here is my case: I want to update the Quantity value from program based on the value given from program and minus it to the database. For example: i have 100 in Quantity in the database, once i run the program and update the Quantity …

please how do i code a search button in visual basic. my database is microsoft access and i am using a binding source to connect to the database.

Im doing an application n c# and using Ms Access 2003. i want to check whether a product id already exist in the database. Below is part of my code[code]string sql; OleDbCommand cmd; OleDbDataReader rdr; mDB.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Path.Combine(Application.StartupPath, "..\\..\\Company.mdb"); mDB.Open(); sql = "Select COUNT (*) ProductID …

hi i am vishal i need to know source code on how to add datas in combobox in a form dynamically at run-time with ms access as it's back-end

Dim connect As String connect = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" & Application.StartupPath & "\segdata.accdb" Dim conn As New OleDbConnection(connect) Dim sr As System.IO.StreamReader Dim entirefile As String sr = File.OpenText(Application.StartupPath & "\SEG1.txt") entirefile = sr.ReadToEnd() ' Read the whole file Dim OriginalValue As String OriginalValue = vbTab Dim ReplaceValue As String …

I have created a Login form and coded as below (Before that.. I am very new to VB I have the knowledge only of the basic.) I got the code from this forum itself But it is not working properly Can anybody help me... My form contains two textboxes 'TextUserID' …

I have an existing Access database that works well using Access. However, the HR department has convinced management to change to Java as the programming language of choice. I have done very little programming in Java, and have NO CLUE how connect to an Access database (2003), how to read, …

Hi everyone, I have a list of an unknown number of Microsoft Access 2003 databases. All of my databases have the same tables but obviously different recordset data. I am able to open one table from one of the databases (select a table from one database) and edit one recordset. …

Is there any way to show the highest value from a access db column in a textbox which you put in the load of a form? Found something by searching around, but did not get it to work at all. Maybe because i cannot open a connection in the load …

Hello Community, I was wondering if there is a way to use some kind of local server such as Wamp, Xampp, easyPHP etc... something like that and set it up so everyone on the same network can access the database on the server. The server will be running on a …

i need a code to enter data into a textbox and update an access database table which must be displayed in my listbox, please help i also want to know hoe to search data in the table

I am working on MS ACCESS database and I have to combine multiple entries in the table into one as for example, min 1 2 3 8 9 11 max 2 3 5 9 10 12 and the result should be min 1 8 11 max 5 10 12 How …

Hi All, I have a an error: "Type Mismatch" on the line that has the stars next to it. Can someone please help? I appreciate all the help. Option Explicit Dim cn As ADODB.Connection ' Establishing a Connection Object that provides a connection to the data Dim rs As ADODB.Recordset …

Hi guyz I'm trying to create a logIn form in VB6 to check against an access database for login details and grant if the username and password exist in the database or deny access if they don't. Any help Please!

Hello all, I am having an issue with saving data entry from a vb6 form to a microsoft access 2003 form. Can anyone please help? I am getting the error "Operation is not allowed when the object is closed." I appreciate all your help! Option Explicit Dim cn As ADODB.Connection …

Running VB-2012 on Windows8 PC using MS-Access 2010 (.accdb) and ACE12, I am now getting this error on the database connection. When I used Vb-2010 on WSindows8 PC, the error did not occur. Any ideas on what I can do the Access database to clear this problem?

hi all i want to ask you how to connect java to remote ms access in another computer thanks in advance

Imports System.Data.OleDb Public Class LoginForm1 Private Sub OK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK.Click Try Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0;data source=C:\Users\Documents\VodStore\VodStore\bin\Debug\VodStock.mdb") Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Users WHERE userid = '" & UsernameTextBox.Text & "' AND password = '" & PasswordTextBox.Text & "' …

hi, i have a datagrid which looks like: subject students eg1001 182737H 29837B 29837C 19282W eg1002 192837C 32810H so on and so forth. how can i do a counter and put into a column between subject and students? like: subject numberofstudent students eg1001 4 182737H 29837B 29837C 192823W eg1002 2 …

i want to retrieve data from Access table but i don't know where i am going wrong.here i am going to show my work which return errors:- Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset Public Sub procedure1() con.Provider = "Microsoft.jet.oledb.4.0" con.Open(My.Application.Info.DirectoryPath & "\Database1.mdb") End Sub Private Sub …

hi all, i have a java program that store arabic data in ms access to let the arabic writing apper i should change the uni code of the operating system but when i give it to my friends to insert data on thier laptop but they forget to change the …

Hello Friends I have a software developed in vb6.0 the software has few textboxes and we have to type in it and the query is fetched and matching result is displayed It uses MS Access 2000 MDB format Somehow i have managed to open the access file but when i …

I add user account and i add Again with same username and password how to make error message sample MsgBox("Account is already registered")

Hi friend , I am new in programming. I am having a table named as bill and i wanted to generate crystal report for invoice purpose,and report will contain Sr.No,ProductName,Weight, Rate, Total ,VAT and a final GrandTotal as final amount sum of the Total of multiple product.Bill will be generating …

I am currently working on a report and I am trying to build a query that keeps giving me this error: `"Data type mismatch in criteria expression"` In my first query, I am calculating the difference between two dates to get a day until our ship leaves port (ex. 6/12/13 …

Hey guys Im doing some testing on a few database conversions from MDB format to accdb. I packged up my files so when the exe was ran it would install MS runtime as well as the databases needed for the app. I was trying to get it so that I …

I am trying to connect to the Ms access database using PHP. The database, that I created has '.accdb' as an extension. I tried the following steps. but I get this error "The specified DSN contains an architecture mismatch between the Driver and Application". Any ideas?? 1. Go to your …

**Bold Text Here** hey any one can help me sort out my problem.. when i enter the customer id then in tabular format i want its all detail. how to do.. like in textBox i enter customer id as 1 then pressed ok button then in new frame or in …

I've built an application that displays the contents of an access database in a datagrid and also a form which allows a user to add a new record to the database. When I tried to run the exe in the bin folder on another computer it displays an error when …

Hey guys Im doing some Research on the artical title. Im wondering if it is possible to have an Access database set upfor a company, but instead of installing microsoft office on every client machine, can you create an .EXE excutable file that will access the database that will be …

hi all, i have a program that insert arabic language to ms access when i create .jar file for the program and move it to another computer and run the jar file it store the arabic data in the ms access database like that ?????. note: you must know that …

Hello guys, I have a problem with data type.I want to store a field with a currency format in access with vb.net.i did it by using the format built-in function in vb.net but it only stores the field in access if it's only in text data-type.If the field is in …

I need to export data from access into a tab delimited file. The hard part is two of the fields need to be 0 filled. I have looked all over access (and google) on how to do this, and can find plenty of import information, but no export information.

help guys, i need to know how to add images and video files (if its possible or just its file path) on access database to be retrieve in vb6 with every images and videos filename included (can be displayed on a separate label for example)

Hi All, I am developing a windows application which uses Ms Access Database. The code is working smoothly in Visual Studio. But, when I create a setup for that project and install it on any machine. I am not able to write data in that datbase. I think its because …

I have the code below in VS 2012. It dynamically allocates a DataGridView and an Update button, then it binds the grid to MS Access database table. That all works well. When I click the Update button btnUpdate_Click() is called, which calls the DataAdapter's Update() method. That produces the syntax …

I'm using VS 2012 and coding a try/catch block in an MS Access database project, but VS says OleDbException is not defined (see line 3 in the code). Anyone know why? I got some of this code from [here](http://social.msdn.microsoft.com/Forums/en-US/Vsexpressvb/thread/c822d48c-fd90-44a1-a186-a15e16966233/), and according to MSDN OleDbException is valid in vb.net Try data_adapter.Update(CType(binding_source.DataSource, …

I have no idea why the program isnt working, its practically the same code I used in the last project so why wont the database update? The code for the program is as follows: using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; …

hello, i am trying to save data in my listview item to access database.. i am new to programming and i am currently working on a project i need to submit very soon, this is really urgent and i will be much happy if i could get assisted as soon …

I am trying to create a form that allows the user to search (Access database) for a record by last name or customer number. It can be a partial last name or customer number. The SQL statement and code are below. This is the same method used successfully for a …

hi, i am working on development of a software project. i have used VB6.0 as frontend and MS Access as backend. In my project i have made a form in which i have to add,delete,search,move first,move last,move next and move previous options to keep tack of employee details. I want …

help guys, i need to know how can i add multiple images in a single add button click for example and display it in multiple imageboxes..the project is also associated with an access database that when the user clicks on the button save..all the images inserted will be saved on …

I have a combobox with 5 coloums of which coloumn 1 is DataGridViewComboBoxColumn I want to populate / add items to DataGridViewComboBoxColumn with data from access database using datatable. i am not getting how to add items to DataGridViewComboBoxColumn. How can i do it. Thanks

17 May 2013 | I am trying (with no success) to connect an Access 2010 Table (.accdb).to a Vb6 ADO data control and having no luck at all. I have downloaded and installed the Microsoft.ACE.OLEDB.12.0 (as i read that this would solve the problem) and to be honest had expected …

I am using ms access 2010 to build a database and need to include a login within the form to link directly to various online database that have different logins.

I want to populate combo box with particular field value of a table in ms access. datafile = "D:\database.accdb" With cn .Provider = "microsoft.ACE.OLEDB.12.0" .ConnectionString = datafile End With cn.Open Set rs = cn.Execute("select * from mytable") Do Until rs.EOF combo1.AddItem rs!name rs.MoveNext Loop cn.Close I am getting runtime error …

I Have created a movie database in visual studio 2008, and its just not saving my records to my access database, Can anyone help me, if it helps if you send me a PM i can send you the file Thanks Michael

Does anyone here can show me a sample query on ms access database?

I am trying to populate combobox from access database but not geting populated only message 1 is displayed message 2 ,3 & 4 are not displayed, nither any eror is shown ------------------------------------ Imports System.Data.OleDb Public Class FrmPlPostCodeNl Public acsconn As New OleDb.OleDbConnection Public acsdr As OleDbDataReader Public strSql As String …