473,327 Members | 2,069 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Entering multiple records on an access form

Hi,

I'm an access newbie. It is a great little toy and I'm trying to get better at it all the time.

I am trying to design a form that will feed into a table. For example sake we will say there are three fields:

1-Unique #
2-Container #
3-Cartons

The Unique # is a number generated from earlier work and will be manually entered.

The Container # is the # of a particular container.

The Cartons are the count of cartons.

Okay, here is where I'm running into issues. The Unique # is the way I'm going to link up all the various parts of my database. I have tons of data coming from all over the place and there is nothing that links. I had to create a number that will I'll be able to run my queries and reports off of. On this form I'm trying to build there could be anywhere from 1 to 15 entries. I want them all going back to the same table and I want to be able to see them as I'm entering.

The problem I'm having is that the when I enter the Unique # on this form for a second time it is pulling up the data for the other fields also. The Unique # will be used for multiple records on this form but the Container # and Cartons will be different for each different record. Any thoughts on what I should do?

Thank you in advance for all of your help. This looks like an awesome site.

Eddie.
Feb 6 '07 #1
2 2392
lwwhite
16
Eddie,

Can you give a little more information about your db? For example, from what you say here, it sounds like a given container can have X number of cartons in it and that's what you're trying to capture. But it seems that there is a larger entity that can encompass multiple containers as well and that's what the Unique# refers to, maybe? What are the "1 to 15" entries that you refer to? If you can provide more details on what you're trying to capture and what the "tons of data coming from all over the place" :) is, that will give us all a better idea of what you're trying to accomplish.

lww

Hi,

I'm an access newbie. It is a great little toy and I'm trying to get better at it all the time.

I am trying to design a form that will feed into a table. For example sake we will say there are three fields:

1-Unique #
2-Container #
3-Cartons

The Unique # is a number generated from earlier work and will be manually entered.

The Container # is the # of a particular container.

The Cartons are the count of cartons.

Okay, here is where I'm running into issues. The Unique # is the way I'm going to link up all the various parts of my database. I have tons of data coming from all over the place and there is nothing that links. I had to create a number that will I'll be able to run my queries and reports off of. On this form I'm trying to build there could be anywhere from 1 to 15 entries. I want them all going back to the same table and I want to be able to see them as I'm entering.

The problem I'm having is that the when I enter the Unique # on this form for a second time it is pulling up the data for the other fields also. The Unique # will be used for multiple records on this form but the Container # and Cartons will be different for each different record. Any thoughts on what I should do?

Thank you in advance for all of your help. This looks like an awesome site.

Eddie.
Feb 7 '07 #2
NeoPa
32,556 Expert Mod 16PB
Just posting to register this thread in my list so I can keep an eye out.
Feb 8 '07 #3

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

Similar topics

1
by: andree | last post by:
Hello, I have a form where a user may paste multiple records. The form has an AfterInsert procedure. The procedure copies the newly inserted record into a different table for audit purposes. ...
14
by: alwayshouston | last post by:
Hi All! I am working on this very small database and I am confused in the designing a simple form. I only have three tables in the database. First Table: tblExpense Columns: ExpenseID ;...
12
by: shank | last post by:
I'm trying to use online samples for submitting multiple records from ASP into a stored procedure. Failing! Through the below form, a user could be submitting many records at a time. I'm not...
6
by: Jack | last post by:
Hi, I have an Access application which need to be converted to asp-sql server application. This Access application uses a single form. This form has got a SS number with names and age. The form...
5
by: Kaur | last post by:
Hi, I have been successful copying a vba code from one of your posts on how to copy and paste a record by declaring the desired fields that needs to be copied in form's declaration and creating two...
1
by: make1circle | last post by:
Hi all, It's a novice question and hopefully someone could help me out. I've designed an access form for entering patient information. Right now it needs to be modified in the way that the...
1
by: marylipscomb | last post by:
I have a form that has a place to enter Adjacent Properties, which I only have room for like 6 right now to be entered.. Sometimes their could be 100 entries. Where you enter that info on the...
4
4Him
by: 4Him | last post by:
First off, let me say this is a great site! I've just started working with Access and much of my success is from what I've read here! Background: I have a form, driven off a single table. Goal:...
2
by: J Dillard | last post by:
I need to tie multiple records to one autonumber. For example, I am entering vendor savings into access. I need access to autonumber my first record for each vendor. Each vendor has multiple ship...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.