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 enter the quantity they are putting on the stock. For example, TOM puts 150 pcs of -product1- in stock. Then Bill will take 50 pcs of the same product1. So the system would do the calculation: 150-50 = 100 pcs left in stock. When TOM will put again 110 pcs …

Member Avatar
+0 forum 0

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 data into GDV successfully, but i d'nt know how to save data in access db. Access db Name "MyInvoice" and table Name is 'InvoiceData'. Please help me to write correct code. Thank You. Imports System.Data.OleDb Imports System.Data.SqlClient Public Class MainForm Private Sub BtnImpExcelFile_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Member Avatar
Member Avatar
+0 forum 1

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 each User has their own MS Access database? For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1. Here is the log-in form that I created that can only have one user account: Public Class Form3 Private Sub Register_Click(sender …

Member Avatar
Member Avatar
+0 forum 1

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 it? I also want each User to have their own database. For example, User 1 can only access Database1 but not Database2. And User 2 can only access Database2 but not Database1. I am a beginner and I only see MySQL tutorials on YouTube but I don't have MySQL. On …

Member Avatar
Member Avatar
+0 forum 2

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# ?

Member Avatar
+0 forum 0

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 I am missing some history data. I need to find the creation date for each article. But the only query covering the whole period since the beginning will return a table like that: `PK | ART | DATE` `3262 | 000 | 17.05.2013` `3262 | 000 | 23.01.2019` `3150 | …

Member Avatar
Member Avatar
+0 forum 5

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. ![vbacoder_Code_20190715.jpg](/attachments/large/4/160efbe4e4d0a8400d04653a6e420c7b.jpg)

Member Avatar
+1 forum 0

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 records in my database and only the first 6 students can login successfully. the remaining 5 students cannot login. Despite entering the correct username, password and status for the last 5 students in the database, the message "Invalid username and password" comes up. I don't know where my code went …

Member Avatar
Member Avatar
+0 forum 6

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))) DOANHTHU2: Sum(IIf(Not IsNull([DONGIA]) AND (SELECT COUNT(*) AS DEM FROM HDMUABAN WHERE (((HDMUABAN.HD)='M1101') AND ((HDMUABAN.LOAIHD)='FBAN') AND ((Month([NGAYGIAO]))=1) AND ((Year([NGAYGIAO]))=2019)) GROUP BY HDMUABAN.HD, HDMUABAN.NGAYGIAO, HDMUABAN.LOAIHD) AS NUM <=0,[SOLUONG]*([DONGIA]/1000000),[SOLUONG]*([DONGIATT]/1000000))) TONGDOANHTHU2: IIf(Not IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[DOANHTHU2]+[BSLN],IIf(IsNull([DOANHTHU2]) And Not IsNull([BSLN]),[BSLN],[DOANHTHU2])) My example only removed one record, I designed the problem of removing many records if …

Member Avatar
+0 forum 0

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 it easy for any body to see what might cause it to take so long to run or how i could possible speed it up the SQL for the query is attached below SELECT [Machine Rates].Group, [SFDC time transactions log].Machine, Calendar.FFPDATE_0 AS [Date], [SFDC time transactions log].TranTime, [SFDC time transactions …

Member Avatar
Member Avatar
+0 forum 1

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 with aggregate function gives me the wrong result... Please give me any idea on this... thank you so much on advanced....

Member Avatar
Member Avatar
+0 forum 2

Is Mobirise GamingAMP theme compatibale with WordPress application?

Member Avatar
Member Avatar
+0 forum 1

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 respond. Search Google for wordpress ERR_CONNECTION_TIMED_OUT My Windows 7 machine is 192.168.1.20 My Windows 10 WAMP64 server is at 192.168.1.22 I can net use back and forth between the systems. Sounds like a networking situation, just not sure on which machine.

Member Avatar
Member Avatar
+0 forum 1

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 one. There is only one table in the database, so basically both the tables need to be merged with the amendments made by both of us. How do I do it?

Member Avatar
Member Avatar
+0 forum 3

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.. ![btnsearch.PNG](/attachments/large/4/76be068c625e23d9a57e969a97509bee.PNG "align-center")

Member Avatar
Member Avatar
+0 forum 2

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" this blockade because I need access to youtube. Many thanks in advance for prompt replies! Adi

Member Avatar
Member Avatar
+2 forum 17

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)

Member Avatar
Member Avatar
+0 forum 1

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 of customers with fields of your choice -Nomenclature of items with fields of your choice -Nomenclature, which represents individual prices for certain items pertaining to specific customers. When selecting a customer, the database must show all items with the respective prices depending on whether a customer is using it individual …

Member Avatar
Member Avatar
+0 forum 4

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 my ISP. My router is a ASUS RT-AC66R I have done the following and still cannot get Anywhere Access working: * Doubled checked and triple checked that port 443 is open with TCP to the IP Address of of my sever. As well as the following ports 25, 80, 987, …

Member Avatar
Member Avatar
+0 forum 7

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!!!!!!!

Member Avatar
Member Avatar
+1 forum 4

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; so, I used F12 while starting the system to go to the boot manager. Unable to find anything of use (as far as gettings into safe mode) there, I chose some option in the boot manager that sent me to the Setup window. In this window, I didn't change anything …

Member Avatar
Member Avatar
+0 forum 7

Hi, I am looking for advice about internet service providers. My questions here may seem silly but please do reply. I am an entrepreneur. I am about to start a new business. This business handles a lot of confidential documents and if any of these are leaked it could bring huge financial problems. So currently I am studying the ways my documents could be compromised and I have a few doubts. Could there be a security breach through my ISP? If yes, is there any way to prevent this? How can prevent my data from being leaked? I became paranoid …

Member Avatar
Member Avatar
+0 forum 5

Hi I am useing Lazarus and a odbc connection to connect to a MS Access database I connect fine and get all records displayed in a dbgrid . My problem is to get the changes written back to the db. When i try to write the data back to the db I get the error : DBConnection: No update query specified and failed to generate one. I do the changes in the dbgrid and do a SQLQuery1.ApplyUpdates; Please help Thanks

Member Avatar
Member Avatar
+0 forum 1

Hi, I once tried dazah. I could login into my old account on daniweb. But once I tried after a while I couldn't, even when I used forgot password. I was expecting that i would be given a link to change my password which didn't happen. I had to register with a new account to gain access. Truth be told, I don't think am enjoying this **dazah** whole idea. Please I need help as to our to regain access, using my old login. Thanks.

Member Avatar
Member Avatar
+0 forum 9

I forgot my password on my Toshiba Windows 10 laptop. Now every time I turn it on it has a black screen with a white box that says 'enter password' but I don't know the password.. I need to somehow reset my whole laptop. I've tried EVERYTHING, INCLUDING calling tech support, the Toshiba company, the windows company, watching YouTube videos, searching all over the internet, etc. Please I need desperate help. I need this laptop to do my school work and if I don't so my school work on this than I won't graduate High school. :( Someone please be …

Member Avatar
Member Avatar
+0 forum 8

Hi I Have an App that connects to an 2010 access DB (.accdb) using OELDB Driver. In my dev pc the application works fine. I also tried installing it on different pc and it worked fine using a access database runtime. Now when Installing it on a pc running access 365 I get ''Unrecognized Database format error'' even after installing the same access database runtime I still. What could be causing this error?

Member Avatar
Member Avatar
+0 forum 2

My laptop drive has WIN 10 installed. I am try to use the same drive as an external drive. So basically I take the drive out from the laptop and put it in USB enclosure and the put some folder with files on the drive. Then I put the drive back on my laptop and start the laptop. Everything looks good and I navigate to the directory where I put the folder. When I click on the file to open it I get the message below and the folder disappears "Location is not available is unavailable. If the location is …

Member Avatar
Member Avatar
+0 forum 3

Hi, New to the forum and I hope I can get some help in the venture in achieving my CCENT/CCNA. I have done lots of research and been have come to the conclusion of using: 3x 2621XM's or 3x2821'S (Routers) 3x 3750 / 3350 (Switches) I eventually want to venture into CCNP onwards and was looking at the Cisco 2901/2921 etc but would that be overkill as would like to futureproof myself by spending the little extra. In all fairness the model hierarchy really confuse me in the Cisco world so any advice would be greatly appreiciated. I have looked …

Member Avatar
Member Avatar
+0 forum 7

Hi there, I’m doing some research around cybersecurity — specifically access management. Does anyone have a moment to answer the below please? 1. Since Windows Active Directory is nearly ubiquitous in enterprises, what are IT professionals doing to secure access? What are the biggest challenges to securing user access using native Active Directory? What kind of employees do you think are most likely to open an organisation up to access risks? 2. How big a security concern do you see access security in your organization. Do you use Windows Active Directory? 3. What Microsoft tools bundled with Active Directory do …

Member Avatar
Member Avatar
+1 forum 2

Hi good day guys.. i am doing a POS in Microsoft access for my thesis.. the problem .. i create a button and i want to enter a data to the list box.. if you click the menu button it will automatically add the item on list box.. and i also have the table of my product it include the product name, price and quantity..thanks for you're help

Member Avatar
Member Avatar
+0 forum 2

The End.