[microsoft-access] Forum Topics

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 …

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 …

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 …

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 …

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 …

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

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 …

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

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. 

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

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

Is Mobirise GamingAMP theme compatibale with WordPress application?

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 …