[microsoft:access] Forum Topics

Dear Senior, I want to make a small application for inventory Management for my store keeper into he will enter stockout/Expiry/Return detail and through which he can find detail of present available stock and can cross check their all report with actual available stock. i can use VB through VS2013 …

Hi, i'm really having trouble how can i make a sales report without using crystal report. I want to do daily, weekly,monthly and yearly report. I created a database with two fiels only, Date and Total Price, but i don't know how to code it, do i just use if …

database table : tblsale fields : id [autonumber], name[text], TOTALQTY [text], TOTALPRICE[text] lvlist column: QTY, NAME, PRICE this is my code sql = "UPDATE tblsale set TOTALQTY = TOTALQTY + lvlist.FocusedItem.getTOTALQTY AND TOTALPRICE = TOTALPRICE + lvlist.FocusedItem.SubItems(2).getTOTALPRICE where name = '" & lvlist.FocusedItem.SubItems(1) Dim acscmd = New OleDb.OleDbCommand(sql, Con) acsdr …

Hi, I know that there have been a lot of questions on this topic and I have followed the solutions however my code still does not work. No error comes up, even after using Try and Catch and the code does not break, but the values are just not in …

I wanted to call a value in database[ms access]. I have a table named tbltable1 and there are three fields, i,d[autonumber], tablename[text] and status[text]. And i have 4 buttons. Each buttons represents the table name. what i want to happen is,status [available, unavailable], when the status is = "unavailable" the …

i've a code that's inserting but it's not dumping into the database!!!! private void buttonX1_Click(object sender, EventArgs e) { if (textBoxX1.Text != "" && textBoxX2.Text != "" && textBoxX3.Text != "" && textBoxX4.Text!= "" && textBoxX5.Text!= "" && textBoxX6.Text!= "" && textBoxX7.Text!= "" && textBoxX8.Text!= "") { string s = …

Hello I am aiming to have an aspx file with a TextBox for the user to type in his email. When I leave the field blank, and press 'Submit', I get: "A password reset link has been sent to your email address" Why don't I get the error message: If …

when Register in this also will record the time in to access also is this code corrct this my code Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick lbltime.Text = "Time:" + TimeString If String.IsNullOrWhiteSpace(txtadmno.Text) Or String.IsNullOrWhiteSpace(txtcard.Text) Then 'MessageBox.Show("Please complete the on the box.", "Authentication Error", …

I have created an MS Access Query named **GetContactCategory** select GetCategoryNames(contactId) as CategoryNames from Contacts The Function **GetCategoryNames** is the function written in a module of same database. Now when i call this query in my c# application using ADO.net it throws error. Following is my c# code ` using …

Hi everyone. I want to ask a question on how to show pictures (jpg files) from access database to a form I have a database called DataBase, i have some fields there. One is called picture, and the data type is attachment. and i have the following code Dim ds …

please help me with my project titled,"STUDENT GRADING SYSTEM" where by the system should capture data using forms, you should be able to edit, compute total marks, total points, grade and position. The system should also show the top 5 students in each class, and also SHOULD PRODUCE REPORT FORMS …

if corrct this code it will come of the list in the datagridview in VB from access this my code: Private Sub ComboBoxadm_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBoxadm.SelectedIndexChanged Dim conn As New System.Data.OleDb.OleDbConnection() conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb" If conn.State = ConnectionState.Open Then conn.Close() conn.Open() Dim sql …

i have written a connectivity code for ms access to jsp but i get a error message root cause "java.sql.SQLException: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application"

If String.IsNullOrWhiteSpace(txtadmno.Text) Or String.IsNullOrWhiteSpace(txtcard.Text) Then MessageBox.Show("Please complete the on the box.", "Authentication Error", MessageBoxButtons.OK, MessageBoxIcon.Error) Exit Sub End If Using conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\temp\Database1.accdb") Dim Result As Integer ** Dim sql As String = "INSERT [Date Select] From tbl_studentadm values (@DateSelect) "*****in here shold i key in the admin …

in the reisgter how i put it togeter time and date of the code when i keyin the admin No and admin card then it record the the access datatbase. Private Sub btnRegister_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnRegister.Click If String.IsNullOrWhiteSpace(txtcard.Text) Or String.IsNullOrWhiteSpace(txtadmno.Text) Then MessageBox.Show("Please complete the …

Hello I have some hash and salt code I intend to try out (not used it before) but I am not sure of a couple of things. I have a new user aspx Register form page and a Log-in form. Do I use the hash and salt code on both …

Hello all, zoidmaster here. I have a question regarding work with a MS Access database. I have the code written out from a tutorial I found online for a basic database, however all it can do with the database is read, add and delete lines from it. I'm trying to …

Good day!~ May i know the difference between creating database using Visual Data Manager and using MS Access. which is better?

I have two listbox and two button, one button is assign another is unassign in listbox1 have adminNo I wan the listbox1 of adminno go to listbox2 one by one when pressing button assign and i also can unassign go back to listbox1 one by one also is it: *listbox1.item.forword(sqlRead("AdminNo").ToString)*

How can i add selected picture in access table.

I have create a project that control an student database. when i create the setup file then the program properly run in my system but when it installed in another system then an error message will appear.The message is "File not found". I want to create a set up file …

i cant add in the data? code of add info: Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click If String.IsNullOrWhiteSpace(txtadmin.Text) Or String.IsNullOrWhiteSpace(txtname.Text) Or String.IsNullOrWhiteSpace(txtcourse.Text) Or String.IsNullOrWhiteSpace(txtic.Text) Or String.IsNullOrWhiteSpace(txtgender.Text) Or String.IsNullOrWhiteSpace(txtaddress.Text) Or String.IsNullOrWhiteSpace(txttel.Text) Or String.IsNullOrWhiteSpace(txtemail.Text) Or String.IsNullOrWhiteSpace(txttpye.Text) Then MessageBox.Show("Please complete the on the box.", "Authentication Error", MessageBoxButtons.OK, …

Hi Friend, Could you please help me with Row level Access Data reading? What I mean to say is(PFA Screenshot) [Click Here](http://postimg.org/image/cultofmhv/) Suppose I only need to read the Row with "EmpID" AA/0141/D/12749, how can I do it? Keep in mind that It is always going to be a random …

hi do you all have any info of student attendance checking system using VB with Microsoft access woth the simple, guide, referenc or simple code on this

hi all i VB how to get the student inforamtion when the user have login from the access database?

Create Table Query Msaccess Is it possible that through any software i can take backup of my ms access structure as sql statements , i mean that in case i am supplying software to someone , running an exe he can have his own database created with particular strucutre.. I …

this is my code i dose not work: ( help me i am create for new user from VB with access) Public Class newuserForm Private Sub btncreate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncreate.Click If txtword.Text = "" Or txtid.Text = "" Then MessageBox.Show("Please complete the required fields..", …

<html> <head> <title>Entitled Document</title> <script language="JavaScript"> function getCount(){ var cn = new ActiveXObject("ADODB.Connection"); var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = F:\PhoneGap\bloodGroupDataBase.accdb;Persist Security Info=False"; //is there any wrong in this connection string cn.Open(strConn); var rs = new ActiveXObject("ADODB.Recordset"); var SQL = "select count(*) from sheet1"; rs.Open(SQL, cn); alert(rs(0)); rs.Close(); cn.Close(); } </script> …

I am adding data to a table in MS Access (2010 Version) from VB 2010 (using INSERT INTO statement) but when I exit the database and enter again the records are lost. Is there any known condition that causes that loss?. Thans in advance.

A question for VB.NET - Access DB folks here, although some might consider a strictly DB question. Is there an order of operation when a SQL query 'does its' thing' relating to the 'WHERE" clause with multiple parameters? In other words, could you rearrange the elements [filters] of the WHERE …

I needed help for the codes in displaying data from access by searching a keyword and display the other info on labels. something like: textbox(surname as keyword) commandbutton(search) lblSurname lblFirstname lblMiddlename thank you

I currently only have access to a this older laptop because my new one crashed do to an update by microsoft. (And yes, it was caused by an update) The laptop was a dell venue 11 pro. Which is one of those 2 in 1 computers which is better then …

Hey! I'm trying to connect my backend (Ms Access) to the front end (VB.NET 2010). I'm trying to retrieve data and I get these errors. I have two problems: 1. For i = 0 To dt.Rows.Count - 1 when typed the above code in the load form I get the …

1. Form created in VB2008 3 Textbox [Name(string), Company(string), Contact(number)] 3 Buttons [New Record, Update Record, Delete Record] 2. Database created in MS Access 2003 File Name: Contact.mbd Fields: ID [Primary key] Name [Text] Company [Text] Contact [Number] How to Create Connection? How to get data on form load from …

how to display msaccess data in vb.net textbox

Hi guys, am a newbie. I want to add a code to my search bar i designed to retrieve and display results from my access database. I don't know how to go about it. I need help

Hello everyone!!!! Good Day ... I am having trouble on how to retrieve 2 fields of every tables in my Database .... I have 3 Tables saved in my MS Access, namely: RegularPassenger, DisablePassenger, and VIPPassenger ... and every tables has 2 fields each, which are SeatsNo and Filled .... …

I need your help i'm using access database create simple login form in the database record Username is Admin or Password is Admin so i wanna need this add username and save record ask me record already available how to do this on vb.net 2010 or 2012 looks like this …

How do you link list view with ms access using visual basic 6

I have an Access Database on which I have tables with similar structure and columns name columnA and columnB.I can use the below query on tables created design time to get this output. Table | result -------|-------- SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1 UNION SELECT …

Good day! I have problems running my union all query..It only executes the first select statement but the 2nd and 3rd union was not executed. My backend DB is MSAccess 2003.. If rs_dailySales.State = adStateOpen Then rs_dailySales.Close SQL = "SELECT SUM(NetAmount) AS totalCashSales FROM InvoiceMain WHERE InvoiceType='Cash' AND DateOInvoice=DateValue('" & …

Im having a problem here, i dont know where to start, im just a begginner i already finished my window forms in visual studio and now i want to connect it to my ms access database, i dont know what to do. Please help.

i can connect msaccess database over lan but not able to update changes made on other computer.

i am connecting to ms access database from lan but not able to update ! ple

I have to design a computerized based system for a pre-primary school on Access. What are the advantages of having a computer based system rather than a manual one? Could you please help me identify the tables necessary that needs to be created.

Hi There, This comes under a few forums on DaniWeb, so I've guessed and posted it here... I have two computers, both connected to the internet and running Windows 7 (Home Premium + Professional). One is my main one, the other is one I do not use. If I installed …

I have written a program using Visual Basic within Visual Studio 2008 which occasionally needs to load data from two MS Access database files into datatables for selection purposes. This all works perfectly on the built 'release' version but when I publish to Public_HTML via CPanel to my website and …

Hi Guys, If you have a Text Box which you are putting in the Decimal Places such as "15.50". Then Submitting this to a Access Database then on re-fresh the data shows in the grid view as "15.5". Where abouts should this be modified so that it shows Decimal Places? …

Hi, I want to develop RFID access system. I create a user database using Microsoft Access.When system and connection are ready, user will swap the card on the RFID reader and the card id will show on retrieve data column. The card id will use to compare with the data …

I have vb.net application with MS access database. I use following code to autocomplete textbox from database. the problem is that, although its working but more frequently it gives an error "AccessViolationException was unhandled----Attempted to read or write protected memory. This is often an indication that other memory is corrupt." …