5,053 Topics
 | |
| | 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 "'" …  |
 | How to Offline to Online Database Synchronization - PHP/MySQL |
 | 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 …  |
| | Hi there i need help on how I am supposed to do this ER Diagram based on this question. I need to have entities, attributes, relationships and primary/foreign keys. here is the question You are given the following business scenario. SmartService is a newly setup car repair and servicing workshop … |
| | 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 … |
| | 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. … |
| | 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 … |
| | To start I want to make it clear I have no experiance with office 365 or the associated exhange stuff, and I would never personally recomend such a package to my clients, hence why I am totally in the dark about this. I have taken on the management of IT … |
| | 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 … |
| | 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 |
 | A long shot I know but a colleague has left, leaving behind a couple of access databases that query each other and a sql database, unfortunately one of the databases querys now takes a long time to run to the point that the excel report calling the query timeouts. is … |
| | I'm very new to visual basic 6.0 and I have a very less knowledge in it. My project is about airport boarding pass generator. In my first form,I have a text box for entering PNR by the user. Here, the program has to search for the PNR already stored in … |
| | i need help on this project it really makes me crazy... imnising access 2007 and vb6 together in my code im trying to make a report using sql query inner join on access database with aggregate function so sad the result is really bad.... the many to many relation ship …  |
 | To start I want to make it clear I have no experiance with office 365 or the associated exhange stuff, and I would never personally recomend such a package to my clients, hence why I am totally in the dark about this. I have taken on the management of IT … |
| | Is Mobirise GamingAMP theme compatibale with WordPress application? |
 | I would like to create a Microsoft Access database and integrate it into my VB.net application. I am also hoping to distribute this application to others. My concern though is whether or not users who download my application will also need Microsoft Access in order for the database (and app) … |
 | I have made the changes to the Apache http.conf file AllowOverride All Require all granted And added the Listen: 192.168.1.20:80 Save the conf file and restarted Apache But when I try to start http://192.168.1.22/wodpress I get the following error message This site can’t be reached 192.168.1.22 took too long to … |
| | I had made a Microsoft Office Access 2007 database with more than 2000 records. A copy of which was given to my friend. We both made a number of amendments and added new records in our respective copies. Now I want to compare both databases & merge the databases into …  |
 | Hi, For a school assenment I was tasked to make a small database solution for a medical clinic. I am wanting to select an access database table after gaining the ID for the table. I will be needing to read and write to this table as well if it makes …  |
 | what is causing this error here "Operator '&' is not defined for string "select * from Miscellaneouse whe" and type 'DataRowView'." provider = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source =" dataFile = "C:\Users\PrintServer\Documents\Visual Studio 2010\Projects\Hr and Payroll1\HR and Payroll.accdb" ' Change it to your Access Database location connString = provider & dataFile myConnection.ConnectionString = …  |
| | ##vbScript - Browse for Folder or File Please see my post [vbScript - The Basics](https://www.daniweb.com/programming/threads/516400/vbscript-the-basics) for more details on vbScript. Some scripts need input (other than from the command line) from the user. This can be read from the console (StdIn) or from a pop-up textbox (InputBox). This is fine … |
| | ##vbScript - the basics My plan is to post a series of hopefully useful and informative vbScript Functions and Subs. I started writing up my first code snippet and found that I was taking too many side trips to explain things about the vbScript syntax and language so I decided … |
| | Hi! My name is Jung and I'm new to VBNET I have already tried many ways to write codes for "btnSearch" but seems like nothing works.. I really need help for this as the deadline is around the corner :'( Below are my codes for Search button..  |
| | i want to convert my old desktop windows program to a language that is independent of microsoft .. don't ask why. ----------------------------------------------------------- .. my old program is written in visual-basic (vb.net) and works with microsoft access databases. .. the old program contains about 20 different forms for data input/output. .. … |
| | Hello, On my workplace in last 5 days there is some block when I open youtube.com or facebook.com. It looks like this: http://postimage.org/image/w01p35hif/ on **every** video I open. I don't use facebook so that is not big loss for me;) but I would like to know how can I "skip" …  |
| | Hi, i was working on a code for a vending machine and i do consider myself to be a beginner, anyway i feel my code is much longer than it needs to be and i want someone to show me a new, shorter way of presenting it. import time print … |
 | I have a question. Whenever I try to open youtube up, it shows up like this(except instead of facebook it's youtube and instead of "it took too long to respond, mine says www.youtube.com refused to connect). Pls tell me how to fix it. [Click Here](https://blog.yoocare.com/wp-content/uploads/2017/03/facebook-this-site-can-not-be-reached.png) |
| | |
 | Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature … |
| | So I have completely hit the wall trying to diagnose the problem with setting up Anywhere Access on my Windows Server 2012 R2. I am getting the infamous "Anywhere Access to your server is blocked" error. The error tells me to check that port 443 and 80 isn't blocked by …  |
 | Hello everyone, I will take this chance to reintroduce myself to the community. I was a member on the Daniweb forums back in 2006 and 2007. I can see a lot has changed on the site since then, and its great to see that the community is still alive. In … |
 | Happy New Year to all members of the web site. I am new on this site as i join here for study and gaining or sharing knowledge of the computers. Thanks to all!!!!!!!  |
| | My Windows Vista computer was freezing up a lot, so I wanted to perform a system restore. In a tutorial, it said that it would be best to do this in safe mode (which, it said, could be attained by hitting F8). Well, I tried, and F8 didn't do anything; …  |
| | We have an Access mdb database originally built in the late 90s. We currently use MS Access 2000 on Win7. Since switching to win7 from XP the database keeps getting locked and corrupted and we are unable to open it. We then have to revert to backup copies made days … |
The End.