Data Entry Through Two Forms

Jul 6, 2006

Hi,

as many of us here, I'm new to Access...:o And running in some problems. Here's my biggest one:
I'm trying to set-up a sample managment system for a laborory. I have two forms linked to two tables.
Form1/Table 1 (just the interesting fields)
Sample ID
Lab ID
Date

Form2/Table 2
Sample ID
Names of the required tests (with yes/no checkboxes).

What I'm trying to do is to display Form1, let the user fill in the data, click on a button. Then Form2 should show up, sample id filled in from the previous form. I couldn't find a way to do so.
Using sub forms wouldn't help me, because from the second form I need to add more forms for additional info.
I tried to ovecome the problem by adding a filter when the second form opens. But of course there's no record with that sample ID, yet (they are uniq ID's).

I suppose there's a solution for this question. Could you point me to the right direction?

Thanks!

View Replies


ADVERTISEMENT

Forms :: Create Data Entry Form To Input Data For Field

Mar 5, 2015

I an trying to create a data entry form (IndividualsEntryFm) to input data for fields such as (First Name),(Birthdate) etc., these to be saved to the (IndividualsTbl)

I also have another table (NamesTbl) which has family names etc. The two tables are linked by a (MainID) field. I want a combo box on the individualsEntryFm so that I can select the family name. Then I wish the empty fields for the IndividualsTbl to be available to enter data.When I press the save button I then want this data saved, together with the MainID from the combo box to the IndividualsTbl.

I have set the IndividualsTbl with a (PersonID) field as an auto number each individual therefore has a unique PersonID but may well share the MainID. I'm trying to link many people to the same address.

View 1 Replies View Related

Forms :: Saving Specific Data From Data Entry Form Depending On User Selection

Dec 18, 2014

I am trying to save specific data from a data entry form to a specific depending on what the user selects from a dropdown/combo box.

So if the user selects "test company from the combo box, that data (from that form) will save to the Test company data table.

View 5 Replies View Related

Forms :: Switching Form From Data Entry Only To Data Editing

Feb 18, 2015

My aim is to have my forms open to a new record, which I have done, but if my users need to then update or edit data in previous entries, they can click a button that allows this.

My thoughts were to add a button, then put in code so that the necessary properties changed the form from displaying a new record or records entered since opening it, to showing all records in the associated table....

As an example there is a table for purchase orders. When clicking on this from the main menu form, it opens up the purchase order form to create a brand new PO. At times though, we will need to revisit an order to attach a copy of an invoice, or update the cost of whatever was purchased.

View 5 Replies View Related

Forms :: Display Existing Data On Data Entry Form

Sep 28, 2014

My db has multiple linked tables. As time passes and work on a project continues data needs to be added to a separate table that is linked to the first table to be populated.

i.e., Initial design data is entered first, when drilling is complete more data is added to a linked table, when drilling is surveyed yet more data is added to the second table.

What I want to be able to do is to query for a particular set of existing design data, display this on a form and on the same line enable data entry to other fields from other tables which are linked to the existing design data.

View 7 Replies View Related

Forms :: Creating New Rows For Data Entry In Access Forms

Dec 26, 2014

I am creating a simple data entry form wherein the user will enter the product id and on change the product description and retail price must be displayed.

When the order quantity is entered, the total cost need to be calculated. I am able to do this using DLookUp and simple multiplication.

However, after doing the above, I need another row to appear so that I can accomplish the same for another product.

View 2 Replies View Related

Data Entry To 2 Or More Forms, Help!!!!

Aug 29, 2005

Hi,
I am an Access beginner.

I am trying to set up an inventory system.

I have 2 tables, one is called item list which contain item description and item part number.

second table is a "shipping and receiving log" which contain date, item description (linked to item list), unit in/out.

I am trying to create a form with data entry function. this form will be called "new item entry form".

what i am trying to do is whenever i have new item to enter in to the table, I will enter the name and the part number of the new item to the "item list" table, then enter an entry in the log to initialize an opening balance.

I am trying to achieve this using only 1 form, but i can't figure out how.

the relationship between this two table is item -> log (1 to many)

if i didn't make myself clear please let me know. I will try to explain more.

I am not sure if it made sense

View 3 Replies View Related

Data Entry Using Unbound Forms

May 20, 2005

Hi All!

I have written a call log system in Access 97 for a busy customer help desk. Now I never bind any of my forms as I like to use VBA code to verify the entry first before writing it to the table. However, every now and then that million to one shot occasion occurs where 2 help desk operators click "close call" on the form simultaneously and therefore one of them gets a debug error (ie the system is busy).

So to prevent this error I have included a "on error" statement within my code which utilises the "RESUME" command to go back to the top of my procedure (in effect trying again). Now I have coded this on error trap to present the user with a message box along the lines of "system busy click OK to retry" as I was unsure about just leaving the code to continually loop until succesful? Is my uncaertainty justified or can I just leave the code to keep looping until it carries out a successful write to the table? This would be preferable as really I dont want the user to even be aware as if they are presented with this message too many times they might start getting worried!!!

My final question is should I send the code back to a point preceding the "On Error" statement at the top or does the system still remember this and so I can send it to a point after this? This is only a issue as I can envisage a time when by the time the system has re-tried another user is also writing a record and so the "on error" (or system busy) may be triggered again.

Any help most appreciated.

Dalien51

View 2 Replies View Related

Search And Data Entry Forms

May 23, 2006

Hi all
I reread this and it was way to long. What I want to do is use a combo box to list values from a table field, when an option is selected, the rest of the fields update. Not sure what I have to do to achieve this. Any advise would be welcome.
Regards
Craig

View 2 Replies View Related

Clear Data Entry Forms

Nov 2, 2004

Hi!!All,

I'm completely new to Access and would greatly appreciate your help in this problem.

I have a form name frmDataEntry with 10 fields, which enters data through an append query in Access. Firstly I was wondering whether I could do mutiple data entries, say 5 different entries of 10 fields each at the same time? Secondly, I wanted the form to clear all the entries after the user has submitted the data(I have made a submit button for this). I would greatly appreciate it if you could help me overcome these problems.

Thanks a lot,
Vakul

View 3 Replies View Related

Forms :: Data Entry With Combo Box

Mar 31, 2014

In my database I have the following:

tables
-course
-programme
-trainer
-trainercourse

relationship
-trainer to course (many to many)
-course to programme(many to one)

I have created an input form to add new trainer. In the input form i have combo box to enter trainer's course n trainer's program.

Each time i save a new record. A new data is created in the course and program table. I dont want that to occur. I want the data to be saved in the trainer query with the existing course and program.

View 4 Replies View Related

Calculations And Tests In Data Entry Forms

Feb 22, 2005

Hi all,

I have a data entry form with several values that could be calculated and entered if I knew how. The FAA requires logging and tracking values that result in the following fields:
TimeSEL
TimeXC
TimeNight
TimeDay
TimeDual
TimePIC
TimeTotalFlight

My last flight resulted in entering 3.4, 3.4, 0, 3.4, 0, 3.4, 3.4

My question is: is it possible to add some sort of test expression in the TimeXC field which would examine an associated check box (i.e. "Was flight XC?") and if it was checked then would automatically calculate the flight hours (TachStop-TachStart) and enter the value in the TimeXC field?

Thanks for any help.

View 2 Replies View Related

Forms :: Combo Box In A Form For Data Entry

Jun 3, 2015

I want a combo box in a form for data entry. Is the best method in doing this creating a new combo box in the form and linking it to a table, or using a lookup field in my table?

View 14 Replies View Related

Forms :: Create A Form To Be Used For Data Entry

Apr 5, 2015

I have created a form to be used for data entry, Where i have identified standard data, I have set the Combo Box on the form to be a "Value List" so as to standardise the data entry.This creates two problems for me.

1. When Using the form, instead of saving the text value to my table it is entering a numerical character?

2. On two of my combo boxes, whilst they have been configured the same, when i try to select an option for the list, it does not accept it? when i try to type the same option into the field of the form it tells me that the option is not in the list?

View 2 Replies View Related

Forms :: Data Entry Items Only If Previous Has Value

Mar 7, 2013

I'm creating user form items (text boxes/combo boxes) for a user to enter data in. In this case it would be for a part. What I would like to happen is, if there is more than 1 part, then after the first part is entered, another part entry item is added below the first one but only if the first one has a value - for a virtually unlimited amount of parts. BUT if there is only say, one part to be entered, then the next section of selection appears directly below the blank next part. Sooo, something like this.......

Invoice:

Part1: (THE PART HERE)
Part2: (THE PART HERE)
Part3: (THE PART HERE)
...
...
...
...
Partn: (THE PART HERE) - blank

(aButtonThatProcessesThis)

OR.........

Invoice:

Part1: (THE PART HERE)
Part2: (THE PART HERE) - blank

(aButtonThatProcessesThis)

Is this possible?

View 2 Replies View Related

Forms :: Combo Box On Data Entry Form

Oct 9, 2013

I'm trying to create a Data Entry only form based on a small table called tblProject.

It consist of the fields Project_ID, Artist_ID, Project_Name, and Project_Notes.

I used the wizard to get me started and i know how to change the form to data entry only, but the problem is the vague data in the Artist_ID control. It shows up as a number, because it is an FK to another table (tblArtist) where more details on the artist are held. (including Band_Name)

I want to be able to make it a combobox with a list of the Band_Names from the tblArtist table. This would make creating "a new project" much easier.

View 4 Replies View Related

Forms :: Data Entry Into Database Though Form

Jun 18, 2013

I've just finished model of DB and it looks like this ( ERM.png )

Now I would like to insert some data into database though form, but if I for example add New contractor ( first name, last name ) with his location , it doesnt connect in table User-Location ... so it is not matched ...

View 2 Replies View Related

Forms :: Data Entry In Continuous Form

Aug 5, 2013

I have a continuous form that is populated from a query. The header has data entry text box for NCR#. I want to run a update query to have the header update each record found in the query.

I've tried a number of things and the closet thing I've got is the header entry updating every record. Something is wrong with my criteria but I'm not sure what.

View 1 Replies View Related

Compatibility When Sharing Forms For Data Entry

Mar 5, 2013

I created an access 2010 file containing tables and 2 linked forms to distribute to different people so that they can enter data for a project. The problem I am having is that the people receiving the file aren't able to open it, different error messages pop up:

-accessde.dll missing
or
-vba6mtrt.dll missing

Is there a way to export the access file so that regardless of the program, they are able to open the file? if not, what are the solutions to this?

View 1 Replies View Related

Tearing Hair Out - Data Entry Forms/Subforms

Jun 18, 2006

Hi Guys,

The asset managment system I have been developing is due to go live next week and I am really struggling with the data entry and search forms.

I have attached a picture of the main form (and outlined each subform) to give you an idea of my project.
The attached form is actually a Main Equipment Type Detail form with a child subform AssetMain which has a number of child subforms i.e. Asset Details, Purchase Details etc.

When a user clicks to add a new asset a popup form asks them to select an equipment type i.e. PC. When they click it opens the attached form. Their selection filters the equipment type detail values in the combo i.e. Laptop, Tower, Server etc.
When a value is then selected in the combo you can then add an asset for that equipment type detail. (One Equip Type > Many Equip Type Detail > Many Assets)

1st Problem)
I have set the Asset Main subform to allow additions only. When the whole form opens, the Equipment Type combo (at the top) does not display a value but does actually contain the first value.
How do I force my user's to select a value in the combo before it actually filters the child subform?

2nd Problem) The Asset Main Subform (filtered by selected Equip Type) should only be used for data entry. I set the data entry property of the form to True but when the value in the Equip type combo changes, it displays all the relating records in the subform. My only solution so far is to stick

Subform.DataEntry = True
in the Equip Type combo's after update event. However, this doesnt look to good as it flashes up with the data and then displays a blank record.
Any ideas?

3rd problem) Due to the fact that I am using a number of subforms, my tab order is such that values are entered for the main form (i.e. ID, Condition) then subforms (i.e. manufacturer) then back to the main form (i.e. allocated to). This means that:
a) I am having problems validating the record beforeinsert as I have had to change the required property to "no"
b) Once the user has tabbed through all the forms what is the best way to go to a new record? Alternatively if I add a new record button I need to check that the necessary fields have been filled in (on all of the forms/subforms).

and finally the 4th)
I have a search form that queries the assets. The search results are displayed in a list box. When you dblclick the list box I need to show the asset details.
Question: Can I use the above form to do this? My only problem is that I need to open the AssetMain form which is a sub form in the above. If I try and use the existing form it will not open as many of the controls refer to the form as a subform. Do you think I need to create a separate form for showing the data to entering it?

Would really appreciate some help (not that you havent heard that before :) )
My head is going to pop in a minute!!!

Thanks
Ben

View 5 Replies View Related

Forms :: Data Entry Form - Set Focus On Tab Control

Sep 10, 2014

On my data entry form I have a tab control with three pages

At the bottom of the first page I have a sub form with 3 fields

Currently, when tabbing, the focus runs through the fields as per the tab order

BUT

Once it gets to the subform (datasheet view) it jumps into the first field of the first record rather than the first 'empty cell' thereby starting a new record in the datasheet.

Once the three fields in the datasheet are completed the focus tabs back to the top of the first page of the form rather than onto the next page of the form

How to correctly reference controls using VBA so I could SetFocus where I want?

The Main form is called frm_Admissions

It has three pages called Patient, Treatment & Service Providers

Patient has a subform called sub_Cluster (which may or may not hold Cluster Information)

I would like the tab order to jump from the last textbox on the form into the first field of a new record in the datasheet (rather than the first field of any existing records)

Once it has finished in the datasheet I need to tab to the first field/textbox in the Treatment's page of the form rather than back to the first field/textbox in the Patient's page.

View 3 Replies View Related

Forms :: Data Entry - Pop Up Search Form Disappeared

Aug 29, 2013

I am around 2 months working with access. I created an application/dataentry form and it was working very well. suddenly today, I got an error which says. Run-time Error 5 "Invalid Procedure Call or Argument. together with that or may be independent, a pop up search form just disappeared. I put a msgbox in form load of pop up form and the msgbox appears but the pop up form just disappeared.

I was about to give the application to use and thats when all these happened ...

View 3 Replies View Related

Forms :: Creating Data Entry Form With Hierarchy

Dec 6, 2013

I am tasked with creating a scientific database of fish catches at various different sampling stations. I envisage the entry form having a hierarchy, ie year, season, date, sample station, species caught, and then the specific associated data with each species (weight, abundance, length etc) will be a distinct record.

As fas as data entry is concerned, I would like the user to not have to re-enter the same information over and over when entering multiple species entries at the same sampling station, on the same date and so on up the hierarchy.

View 2 Replies View Related

Forms :: Deleted Appears In Data Entry Fields

Aug 6, 2013

On a data entry form bound to a single table, there is a subform displaying all the records in the source table.If the user accidentally adds a record that they didn't mean to add (or if I add a record to test the form's functionality), and then right-click and delete the record, "#Deleted" appears in all the input controls.

View 5 Replies View Related

Forms :: Limit Data Entry To One Of Four Available Combo Boxes

Apr 29, 2015

I have a form with four combo boxes on it, the four boxes all open the same form and return a record based on the selection from a different column from the same query.

To make it work smoothly I think I need to make it so it is only possible to enter data in one combo box at a time. I could also do with some error handling.

View 2 Replies View Related

Forms :: Creating Form For Data Entry On Three Tables?

Nov 19, 2013

How do I create a form that will allow me to enter data into three different tables?

I have a rather simple database for tracking students. When I get a new student I need to take information off their paper application and enter it into three separate tables, Student, Families, and Demographics. Each of these tables contains the fields StudentID, StudentFirst, and StudentLast.There is a relationship between the StudentID field on each table, with Student being the main table and Families and Demographics coming off of it. All relationships are one to many. StudentID is the key for the table Student.

I want to create a form to add a new record to each of these tables. I want my data to be displayed in the Columnar style. I only want to enter StudentID, StudentFirst and Studentlast once and have it populate to all three tables.

I can create a form and a query that displays existing entries exactly like how I want to enter them, but of course I can not edit or add to them. I have tried using subforms, but they don't seem to link up. Once I enter the Name, I want it to be on all the forms. I don't want to have type it three times. I also tried creating three separate forms and connect them with the Navigation Form. The issue again is that once I enter the name in one form, it is not automatically on the next form.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved