how to add data into table ?

D

Dlovan-IT

Registered User.
Local time
Today, 07:26
Joined
Oct 9, 2013
Messages
84
hello all fiends

i create a form and two table one table is order for form another table it store the information look my database in the attachment , i want when the user input more than one data and when input price the price is used for all of the data when the user was input , look my database you get more understand , if any body knowing how to do it please check my database and solved my problem , thanks for all of the best member
 

Attachments

Last edited:
thanks my friend for your reply but it is not my solution my database exactly like that look my attachment
 

Attachments

Last edited:
There are few rules for DBs.
One of them say to NEVER store in the DB something that you can calculate.
Another one say: Do NOT store the same thing in more than one place.

Your DB broke both of this rules.

What is your logic behind the "Add to Store table" ?
Why you wish to store a record in Store table ?
There are records that should be stored in Store table and others that should remain only in Table1 ?

Try to explain, in plain English, your DB business.

It is easy to define an Append query. But is hard to obtain a good structure for the tables.
 
my friend when all the records stored in the table , after that i want to calculate all the records that stores in the table , my friend reality i'm from kurdistan region of iraq maybe you know that ! and i'm create a database for my friend he has a company about a big Store item , then i created a program by access using and the database would be worked with barcode reader terminology , the database is content of what ! content of many table i'm sorry for the project because maybe you don't understand because i'm created by kurdish language so .. one table is for store information another table for ordered when the user wanted how much the count of item finish , then i create like above database before you see it , know i want when the customer buy any new item then the supplier want to how much i sell in this month what is your idea for that ?
 
Lets take it easy.
Yes I heard about Iraq and the kurdistans. First time when I read "1001 nights" Sheherezada's stories. The second time about the "Golf war".
Your and my English is not very good but I hope will can understand each to other. So, please, use very short sentences when you write.

When I ask about "business" I ask about your DB business. What your DB should do. At what questions should answer.
Think that your DB is your employe. What should do this employe ?

From what I understand (correct me if I am wrong) your employe should:
1) Input a barcode and associate this code to a product.
2) If the device fail to read the barcode, the operator should be able to manually select the product.
3) If the product quantity = 1 then go to the next step. Else, the operator should be able to input the quantity.
4) The DB should "know" the price for each product at the sell date.
5) Based on the product, the quantity and the price, the DB must calculate the total price for that product.
6) In a session, more than one product can be sell. So, the DB should calculate the total price for that session.
7) The DB should print a report that contain step 5) and step 6)
8) My DB should calculate, at any time, the stocks.
9) My DB should inform me about the quantities for each product that I sell between 2 dates.
10) etc.

This is what I name "the business".
So, define in very short sentences your "business" and I'll try to help you to develop a good DB.
 
yeah my friend i'm glade that you know Kurdistan and i'm glade you are reading stories , my english and your english is normal i understand if you are understand me :)

my friend all the point you are describe above is correct and some of them i doing it from my database such as : any product have a unique barcode when the user input the barcode show name of item and quantity then calculate each product with quantity give the total price , my friend i want that database formation you are describe all above point , you are very smart my friend all that i want you knowing that bravo bravo
 
Dlovan-IT said:
yeah my friend i'm glade that you know Kurdistan and i'm glade you are reading stories , my english and your english is normal i understand if you are understand me :)

my friend all the point you are describe above is correct and some of them i doing it from my database such as : any product have a unique barcode when the user input the barcode show name of item and quantity then calculate each product with quantity give the total price , my friend i want that database formation you are describe all above point , you are very smart my friend all that i want you knowing that bravo bravo
Click to expand...
Thank you for this, but I think that I am only more experimented.
Ok. Take a break and I'll sketch a structure for your DB. You will have this soon.
 
Hope will be skilled guys/girls that will take a look to this DB and share with me their criticism.

@Dlovan
Fill the DB with real data. Use English, please.
Test, test and test again in order to find any bug.

If something is going wrong, upload your DB and say us what is wrong.

Good luck !
 

Attachments

oh my friend i don't no how to say thanks i'm proude you teacher , ok my friend i show person skilled then i called you by private message , another again thanks so much good friend
 

Attachments

oh my friend thanks so much really it is very nice design very nice think , you are very smart but my friend i have asked , about the table when i input the data from Mihail.mdb automatically all the data transfer to Mihail_be.mdb and from Mihail.mdb not saved ? i think it is very smart my friend
 
The "BE" (Back End database) store all the tables, so all the data is stored here.
The other DB, named FE (Front End database) store the interface (Forms, reports, queries, VBA modules).
You can continue work in order to improve the interface while your users work by using the old one.
When / If / After you have a better interface (as aspect and/or logic) you can send it to the users.
All they have to do is to replace their (old) interface with the new one and to restore the tables links (if they use other path than you for the BE)

Do a try:
Open the interface.
Open the Navigation Pane
Right Click on a table
Choose the "Linked Table Manager" wizard.
Follow the steps.

After you will understand this wizard you will be able to rename the DB (I speak also for the BE) and to move it anywhere in your computer.
Until this you must use the path where I designed the DB.

Warning !!!! Always work on a copy of the DB.
 
thanks so much for your information i gain it , so my friend the database is ready to work ?
 
I hope so.
When you will translate in your language, translate only the labels (what the user see).
Keep all other names in English.
This way you will be able to ask for help if something is going wrong.

Good luck !
 
ok my friend i know i'm not change everything from macro and name of textbox ... etc , i'm very happy my friend thanks so much
 
You must log in or register to reply here.

Similar threads

H
Solved Dlookup Or SetValue not working
Replies
17
Views
603
mike60smart
mike60smart
W
Solved From with One-To-Many Relationship table
Replies
19
Views
512
wmix
W
J
Unable to delete record due to record lock
Replies
6
Views
439
The_Doc_Man
The_Doc_Man
B
Form writing to wrong table
Replies
7
Views
260
The_Doc_Man
The_Doc_Man
L
Making a form to update multiple tables
Replies
6
Views
548
LakshinK
L

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom