473,569 Members | 2,790 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to add multiple recode in one data entry

1 New Member
HI i am ajitvyas . i am using ms access 2019 . i am preparing for data entry programe in access for my business(small)
my data entry has following head ( bill no. party name , name of item qty in bag weght and amount) ,Now one pary brings more them one item at the sametime for exmample in the same bill
Expand|Select|Wrap|Line Numbers
  1. bill no.  partyname  item  qtyin bag  weight   rate (20kgs)  buyer name
  2.     1           xyx  onion    40      7425 kg   425          vry pvt.ltd
  3.                      chna     10       825 kg   825          srz  firm
so each party as state above bring more then one item and buyer of each itme is different .

so my question is that how can I solve this problem in access by vba
if anybody wants, to see the work created by me ple.send me mail id and i will send details

thanks in advance
ajit
Apr 19 '23 #1
2 12091
NeoPa
32,564 Recognized Expert Moderator MVP
Hi Ajit.

As far as I can tell from your question, it seems to be about how you manage storing of your data. If you have multiple items then you need to store certain details at one level (One table.) and other details at another level (Other table). A bit like a table for Orders and a separate one for Order Lines. Further tables are required for other entities such as Customers/Clients and maybe even Suppliers. Have a look at Database Normalisation and Table Structures for a more in-depth discussion of how to store information in a database so that it works best for you.
Apr 19 '23 #2
XPS35
4 New Member
As you may have read in the other forum, this is a design issue. You need several tables and a main and subform. There's no point in asking a question again if you already got the answer.
Apr 22 '23 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
6605
by: IanCraft | last post by:
I am new to Access 2002 and have a questions regarding using a form for data entry. I have 15 items I need to keep track of that are listed individually on a form as follows: Item#1Name AmountOut AmountIn Item#2Name AmountOut AmountIn etc. Each day, the user opens this form and records the amount they have taken or put in for...
5
3104
by: Aspnot | last post by:
Background: I have a data entry form that is bound to a DataSet. This DataSet contains 9 tables and the form displays data from each table in textboxes, not a DataGrid. One of the tables in the ParentTable and the rest are children. For Example: The form shows the Customer and their most recently added Contact (in textboxes, not in a...
3
5374
by: sunilkeswani | last post by:
Hi How do I set an access form in such a way that it keeps some field values constant in an open session? It is a multiple user data entry form, so I prefer that once a user inputs his name, the form should display the same name all through so the user does not have to put it in each time.. Any help would be appreciated.
1
4768
by: NumberCruncher | last post by:
Hi All, I am struggling with setting up my first system of tables, forms,and reports, and could use your help! I am setting up a database to keep track of the production of a produced item. The item is a panel, with a specific texture. There are standard panels that are then produced in a limited number of specific textures. The number of...
2
2868
by: Certys | last post by:
Hello, I have a form where I only allow new records to be added. I enable this by setting the form property "Data Entry" to Yes. I want to access other records in the same table- to autofill the new record with a user select previous record. Dim rs As Recordset Set rs = Me.RecordsetClone
8
2922
by: Wingot | last post by:
Hey, I have a program I am trying to write using Visual C#, SQL Server 2005/2008, and Visual Studio 2008, and one part of it includes a Schema called Client. Inside this schema, three tables exist named Country, MedicalCondition, and Customer.
1
1728
by: AlisonP | last post by:
Hi, I am a relatively new Access programmer, but have programmed computers in Fortran and done complex modeling for years. Am learning quickly, and have managed to figure everything out so far, but now am stuck. Sorry if this is a basic question. I am using Access 2007. I have a form for data entry. Database is biological samples. One table...
4
3715
by: jtmm | last post by:
I have a data entry form that uses a control button to process multiple "samples" using Private Sub GenerateRecords_Click() Dim mn As Long Dim Rec As Long Rec = (Me.Text2 - Text1) + 1 For mn = 1 To CInt(Rec) DoCmd.GoToRecord , , acNewRec
1
1143
by: tinamiller1 | last post by:
I have a main form and data entry subform. When the main form is selected, the user can view records that exist in the main table in order to determine if they want to complete a data entry form or head over to the update form. The data entry form uses unbound for comboboxes because they need to select from other tables where they can see all...
0
7609
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7921
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7666
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7964
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
1
5504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3651
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3636
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2107
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
936
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.