Forum Topics Tagged [microsoft-access]

What's the best cloud accounting software for small businesses that handle multiple sales tax rates? Or is there an affordable web-based small business accounting software?

How can read line in file that line have recordor examplethe file: date new_cases new_deaths 2020-07-30 665 10 2020-07-31 590 9 2020-08-01 - 0 2020-08-02 - - 2020-06-04 738 8 2020-06-05 779 - 2020-06-06 770 5 4 line it is not record new_cases or new_deaths so wae ignore the line also line 5 but line 6 we read because it has record> after read this file the reasult is: 2020-07-30 665 10 2020-07-31 590 9 2020-06-04 738 8 2020-06-06 770 5 How can read read this line by java????

Petya loves lucky numbers. Everybody knows that lucky numbers are positive integers whose decimal representation contains only the lucky digits 4 and 7. For example, numbers 47, 744, 4 are lucky and 5, 17, 467 are not. Petya has a number consisting of n digits without leading zeroes. He represented it as an array of digits without leading zeroes. Let's call it d. The numeration starts with 1, starting from the most significant digit. Petya wants to perform the following operation k times: find the minimum x (1 ≤ x < n) such that dx = 4 and dx + 1 = 7, if x is odd, then to assign …

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 field for Notes. Is it possible to to set the Notes field so that notes can only be entered if "other" is selected in the issues field? Can this be done with a validation rule or a code?

Dear all i want to know how to show particular records from database by select any record from combobox what is the coding and how to display record in another textbox by selecting from combobox like if you choose any record from combobox it will appear in textbox, in image is attached kindly help me thanks and regards 

What is great about Amazon is that there is no one way to start an Amazon business. From the business model you choose the products you decide to sell, there are many ways to succeed on the platform. However, the steps required to get up and running on Amazon remain the same, regardless of the type of business model and the product you choose. ## 1. First, start by deciding which business model you want to use ## * **Private Label**: Private label is the process of a retailer rebranding/renaming a product that is already being manufactured on their own …

how do i connect to internet how do i connect to internet

Java is necessary in every field.

'call it like List1.Clear List1.AddItem RDMature(Val(Text1.Text), Val(Text2.Text), Val(Text3.Text), 12) List1.AddItem RDMature(Val(Text1.Text), Val(Text2.Text), Val(Text3.Text), 2) List1.AddItem RDMature(Val(Text1.Text), Val(Text2.Text), Val(Text3.Text), 4) List1.AddItem RDMature(Val(Text1.Text), Val(Text2.Text), Val(Text3.Text), 1)

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 correctly and my update button works correctly too. The problem occurs when I try to add a new record. I keep getting a "Syntax error in INSERT INTO statement" whenever I click my add button. My database table has JobID(number), ElectricianID(number), CustomerID(number), Price(number), Date(date), Time(time), Paid(yes/no) Eventually I will have …

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 error. "Syntax error in INSERT INTO statement." can anyone point me in the right direction? Dim sql As String = "INSERT INTO TblReelResults (ID , Section) VALUES(@ID ,@Section)" Using conn = New System.Data.OleDb.OleDbConnection(_connectionstring) Using sqlCom = New System.Data.OleDb.OleDbCommand(sql, conn) conn.Open() sqlCom.Parameters.Add("@ID", OleDbType.VarWChar).Value = Me.lb_id.Text sqlCom.Parameters.Add("@Section", OleDbType.VarWChar).Value = Me.txtSection.Text Dim icount …

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 datagrid view present all the possible recipes with those ingredients , i think is a great idea however im having many problmes trying to do it , cant get a a way to save ingredients into the recipes and so on , its being very difficult for me and to …

Hello Programmer

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 it better i'm open for ideas to learn too :) <pre> Public Class Form2 Private Sub Form2_Load(sender As Object, e As EventArgs) Handles MyBase.Load Using con As New OleDbConnection(ServerStatus) Using cmd As New OleDbCommand("SELECT * FROM Table", con) cmd.CommandType = CommandType.Text Using sda As New OleDbDataAdapter(cmd) Using dt As New …

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 any device. I guess I can copy the database onto an old PC and run that as a server, its just I have no clue how to do it. Im using VB.net on Visual Studio 2019. The database is Access and I'm using Oledb to do all the communicating with …

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 which is located at Kuala Lumpur’s Golden Triangle. The strategic location, customer oriented services and reasonable price are the main reasons of the workshop gain popularity within a short period of time. There is an average of 50 cars daily are being sent to the workshop for repair or/and servicing. …

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 reports on Excel. I need to use this data for several tasks, currently I am using a pivot table to tell me what person has sold what product and I then manually type this into another Excel spreadsheet which has a tab for every week. I use this to tell …

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 …

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. How can I record who logged in to the database to accept the work on the form itself?

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) …

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 …

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 …

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

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

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. 

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 …

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 …

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 …

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