[microsoft:access] Forum Topics

Public registration platforms often deal with users who are not technically experienced. This makes content presentation extremely important. A system may work perfectly on the backend, but if instructions are unclear, users will struggle. One approach that improves usability is simplifying explanations for processes such as the online ration card …

I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling …

i want to create table in ms acces database during run time......... Dim myConnection As ADODB.Connection Dim Conn As String Dim vtblNametxt As String Private Sub cratblebtn_Click() vtblNametxt = tblNametxt.Text myConnection.Execute ("create table " & vtblNametxt & " (id varchar2(3),pname varchar2(20), qtyp number(4));") End Sub Private Sub Form_Load() Set myConnection …

I have excel sheet where all pivotcharts are combined by slicers. i want to copy individual pivot charts from the excel sheet to a word document by image to placeholder Thank you in advance I have tried with win32 & openpyxl but error message came Object attribute charts is not …

Hi Last 15 years i am using billing software ( visual basic 6 )...Now i need to attach barcode scanner..Can anybody help me to add.. Database is Ms Access

Hi I am creating a employee management system with ms access and VB6. I need code for marking and view attendance. Can anyone help me ?

I look after the company's access database which records the company's products from different suppliers. The table's primary key is the product code and the table also contains a description of the item, the supplier, if discontinued, buying in price and RRP. The product prices are updated from a spreadsheet …

How can I add an audio to a Access database. I have a Access "greeck dicionary" and word "Relaxed with the phrase in Greek and its audio

Good day every body. I want to develop a database program that will be used in school to input information about students and all the staff of the school. I want the program to be able to retrieve any required information and also display the total number of students in …

ciao a tutti, qualcuno mi può dare una mano...vorrei fare un form con un pulsante che al click inserisce i dati in un db access, avrei bisogno del codice per la connessione al db, e lo statement per il pulsante grazie

Hello, I am fairly new to VBA development trying to upgrade my employee training database in VBA from a single listbox with single line select/add/edit capability to one that pulls employee data from listbox1, searches training available by job title in listbox2, and combines the data into listbox3 also adding …

It's running but it deosn't read any data from the access(blank grid view), what's wrong please help me Private Sub rrrrr(sender As Object, e As EventArgs) Handles r1.Click, MyBase.Click, Button9.Click, Button8.Click, Button7.Click, Button6.Click, Button5.Click, Button4.Click, Button35.Click, Button34.Click, Button33.Click, Button32.Click, Button31.Click, Button30.Click, Button3.Click, Button29.Click, Button28.Click, Button27.Click, Button26.Click, Button25.Click, Button24.Click, Button23.Click, Button22.Click, …

i want to do data validation with excel combo box.....i made reference....but when i delete the reference the code will execute error

How to add audio files (eg: the pronounciation of Spondylolisthesis or the chinese word: Wǒ ) in a Acces database. Step by step.

hello i am new to the coding world and i am trying to get this login code to only accept the names and passwords in the access database, current any can login. please assist Imports System.Data Imports System.Data.OleDb Imports System.Data.DataTable Public Class Form1 Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal …

Good afternoon, I'm haven't coded in a very long time, and now I have some time in my life I'm actually coding a Quiz application in vb.net using ms access for the question/answer database. This project is what the student will see when their taking the test, and my issue …

I want to be able to write an SQL statement that pulls the sum of revenue and expenditure for each day and gets net income for each day with the distinct dates available in the Income and Expenditure tables. I have tried the following statement, but I'm not getting the …

I have an access Database with Chinese and German words. How can I had their audio prononciation wich I get from Forvo or Google translate?

Hi! I found this code in one of the threads [here](https://www.daniweb.com/programming/software-development/threads/125119/auto-generate-id-number#post611289) I converted it into an access kind of code(?) and unfortunately, it won't increment, nor find the top/max in my database. Someone please help? ` Private Function GenID() As String Dim dr As OleDbDataReader Dim com As OleDbCommand Dim …

Hey , I am a begginer in vb.net and I want to retrieve my data from access database as well as manipulate indivial record according to my choice..Can you help me with this Thanks & Regards

Would you mind if I troubled you for some help? I’m working on an NDA’ed project and we’ve been asked to try and address a problem which is currently causing some pain. Imagine there was a merger between two blue-chip communications/media companies, and Company A was offering discounted deals to …

1. 4 text box 2. 4 label 3. 3 command 4. code A. draw and label the object B. write the following step (data base) C. write the following codes

Daniweb was kind enough to send me an email reminding me that my account was still active. So I decided on a random day to come back in and see what's going on?! I haven't programmed anything in over one year and I'm not sure what/if I will make in …

I have a database form in Access 2016 with a field, with a pulldown menu of standard issues, that have been fixed then a field for Notes. If the issue in non-standard then the user picks "other" from the pulldown menu and makes a note of the fix in the …

Hi all, I've been having a problem adding a record to an Access database using datasets and da.update etc. I'm trying to create a simple program that displays the records of a database table in a series of text boxes. I've managed to get my next and previous buttons working …

Hi, I have one Win Form app to load Excel data into DataGridView. I want to store DataGridView data into MS Access database. Everithing works great, but in some cases inside ExcelFile I have single quote mark, which breaks SQL Syntax. My question is, How to find & replace "'" …

I normally use SQL as the backend database however for a new project I need to use MSAccess. I am trying to insert a new record, this works fine if I only have on fielid on the row but as soon as I have a second field I get an …

So i need to make a program to my final year of college which will count on the grades and it is obligatory, im doing a program to search for recipes in a access database trough its ingredients, what i mean by this is selecting some ingredients and in a …

Hello, Can someone assist me how to create here buttons - Button7 - First - Button5 - Next - Button6 - Previous - Button8 - Last To search in database and display the results. Here is my project until now: - Also if there are mistakes or suggestions to make …

Hello, Ive basically finished a program for my A level CS cousework, but with a few days left in the deadline I want to make my database accessible online. When the app is done and compiled it should be able to access the database on the server from anywhere and …

PLease help me. I'm doing a login form with ms access but this line of code having problem "Dim dr As OleDbDataReader = cmd.ExecuteReader" Below is the source code Imports System.Data.OleDb Public Class Form1 Dim con As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\leong\documents\visual studio 2010\Projects\WindowsApplication4\WindowsApplication4\coursework.mdb") Dim cmd As OleDbCommand Private Sub Button1_Click(ByVal sender …

Hi helpful people. Its been a while since Ive been here, ever since I employed someone who knew about IT to look after it for me. I'm back on my own again, and looking for a bit of guidance please? I run a small sales company and receive daily sales …

I don't know whether this questions fits here or not, but if it doesn't let me know. I'm very much beginner in programming, and I've started it in vb.net for a project I've to do for my college work. To add the data of a user from a form, when …

Hello. At work, I have to count about 5k in a day for products. When someone takes out or puts in products for example 450 I have to recount again. So I want to create a system that when someone puts some kind of product on the shelf they would …

I am looking to create a database to record when students' work has been handed in to the office. I have created the form but it needs to be able to record who signed in the work. There are several people working in the office and will use the database. …

I looking to create a database form for people to create receipts to issue to customers but I need to be able to lock the record so that it can't be edited once it has been printed and saved. How can I do this?

Hello to all. I am developing software in vb.net for sales invoices. Where i need to import invoice data from excel file to vb.net Grid Data View and then save into access db. I will use db data in future for creating customer invoices. I have code that import excel …

So, I created a program in VB.Net with Windows Form and I want the user to be able to create a new user, limited to 5 user accounts only. I also want to know if it's possible to change password and delete user accounts. Can I make it so that …

Hi, I'm creating a project using VB.Net Windows Form and I want to create a Log-In form that can **Add New User (Limited to 5 User Accounts), Delete User Account, and Change Password**. I want to use Microsoft Access with it. What are the codes I should use to create …

Compress and fix access data in C#, I have to look for examples on google network but it's not running examples, how to compress and fix data in C# ?

Hi guys, Am developing a clinical management system in VB.net and using Microsoft Access for the database. Everything else is working very well. But the login code is not working. It's throing an error message "Object reference not set to an instance of an object" on line 12. Below is …

Hello! I have a question and I don’t know whether the title is actually descriptive. For some background on the matter, we use Sage 50 as our merchandise information system and for our reporting and controlling tools we run Access queries. Since our database had been reset at some point …

This was a query raised by one of a forum members at another site, where he had a worksheet filled with random numbers, and I have already answered that query [at my post here](https://vbacoder1962.wordpress.com/2019/07/15/extracting-cell-phone-numbers-from-random-strings-of-variable-length/). You may go through that post and read the logic behind the code. 

Hi. Im doing a login form with decryption. So i did a modification to my login code for decryption. Before i did the decryption, the login form is functioning well. But after i edit it to insert decryption code it suddenly cannot connect to database. Im still a begginer in …

Hi All, I have 7 tables in my access database. i wrote a code to select the data table using the combobox and to display the selected table in the datagridview. Now i need to add,edit or update, delete the data into the selected tables. In which the text boxes …

Hello, I wrote some codes for student login. the codes checks for the "username", "password" as well as their type of "status", from the database. once this input are met, the student logs in successful, otherwise a message pops up. The problem i encountered is this, i have 11 student …

Hello, im glad to have this forum. Please help me with my problem, I am developing a pos system and my problem is i want to display my data including the picture of my product, and i want to display in a datagridview like a thubnail display. I have table …

I want to calculate the total conditional in the month but remove the records that are not the same month and not the same year, the condition that eliminates the view on the sql access because the result is true or false in the excel file http://www.mediafire.com/file/kq2mr2v6px1uxan/exercise.rar DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]),[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) …

Please I'm trying a simple connetivity with VB.Net to Microsoft Access Database and it keeps giving this erro message.... Please i need help Thisis the error it gives The 'Microsft,ACE.OLEBD.12.0' provider is not registered on the local host

Hi Mr Dani first i would like to thank you for help always for a lot of hard issues , i always check your site to have some help and now plz help me to get thime and date from server , becouse the clients in my school has a …