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 Replies


ADVERTISEMENT

Forms :: Open Form From (Edit List Items) Option In Data Entry Mode

Feb 4, 2014

I have several comboboxes in my database from which users select values. However, in most cases, I do want to give them the option to add an item that does not appear while simultaneously updating the underlying table which stores those dropdown values. I have made use of the builtin "allow edit list items" feature of Access 2007 but the form always opens on the first record of the form on which they are to add the new item. Is there a way to specify that it should open in Data Entry view apart from using VBA?

View 4 Replies View Related

Retaining Data Items In Previous Entries After Item Has Been Discontinued

Jul 7, 2013

I seem to be have trouble resolving an issue whereby data entered via a combo box based on another combo box from separate tables/queries is not able to be retained when the data in the original table has been "discontinued". The database in question has changing items that are continually updated and/or discontinued. However when these items have been checked as "discontinued", the old entry data is then updated and the fields are empty.

View 1 Replies View Related

Forms :: Increment Number For Items - Previous Value Plus One

Feb 16, 2014

Like other posters, I need the default value to be the last value plus one. I am using a subform, and the field I need to increment is ITEMNUMBER for items that are ordered for a specific project.

It is acceptable to me to replace ITEMNUMBER with 1 for the first item, I just want it to increment after that.

Clearly the use of DMAX in this situation will not work as ITEMNUM would continue to increment so that any given project might have ITEMNUM values as, for instance, 357-363 when it needs to be 1-7.

BTW - if I could use the maximum value I would set the default value of ITEMNUM on my form as:

(DMax("[ITEMNUM]";"Projects"))+1

View 4 Replies View Related

Queries :: Enabling / Disabling Fields According To Previous Data Entry

Aug 6, 2013

I need to create a form to enter data from a survey, and ideally some sections of the form would only be completed when the answer to a first question is "yes". How to do this enabling/disabling of fields for data entry?

View 3 Replies View Related

How Can I Configure A Table To Auto Data Entry Into Fields Based On A Previous Field

Aug 31, 2006

My situation is this. I have 3 tables that I have imported from my mainframe system, between these 3 tables I have the data of product code, description,supplier code, supplier name, order method, and ABC code.

I am trying to create another table that I can capture daily Out Of Stock data for products.

What I would like to do is to enter the product number in the first field of my new table, and then the remaining fields will auto populate with the correct details based on the product data stored in the parent tables that I have imported.

How can this be done?

View 3 Replies View Related

Forms :: Lookup Value Dependant On Previous Field Entry - Requery?

Jun 21, 2015

I'm creating a database which contains information for keeping dog grooming clients. It has 3 tables, table 1 is customer, table 2 is dog, and table 3 is booking.I want to be able to choose the customer table and within that you can see the pet linked to that customer and within the dog table you can see any bookings with that dog.What I have done is linked the pet and booking table to the customer details via mobile no. being the primary key.

I want a form called appointments which contains fields *ID, date, mobile, dog name, grooming stlye and other. What i want to happen is this, once the mobile number is entered, i then when it to lookup the mobile number in the dog table and pull the pet name from that, then in the dog name box it will then provide a drop down of dogs related to that mobile number.

I understand a query needs to be made in the dog name field, so in that field i created a query to look up the mobile no. in the appointment table, and to then lookup the pet name in the pets table. This kind of works. The two problems are this, the drop down in the dog name field shows all of the dogs in the database not just the ones assigned to the mobile no. in the field before. If i choose one of the dogs not related to that mobile it changes the mobile number in the field before to the relevant one (but i don't want to be able to see the dogs which arent related to the mobile no. in the field before.The other issue is that on one of the customers there are two dogs, now on the drop down you can see both dogs, but it will only allow you to select the dog that was entered first into the database. If i select the other dog it simply chooses the data for the one first entered.

I have read about doing Requeries on the afterupdate of the field and attempted this by choosing the dog name field and in the afterupdate telling it to requery pet name (I've also tried mobile), this hasn't worked. I have a feeling I'm getting a bit confused by which fields i'm supposed to use etc.

View 1 Replies View Related

Forms :: Access 2010 / Showing / Hiding Fields Based On Previous Entry?

Mar 26, 2014

I am using Microsoft Access 2010.

I have a form, having following fields

Nationality, Combo box, Options are Indian/foreign State: With list of States in India.

What I want is, when data entry operator , select, Foreign, State field automatically hides.

And when data entry operator , select Indian, State field shows in the form.

How this can be done in Access 2010

View 5 Replies View Related

Forms :: Can A Field Auto-fill From Previous Entry In Separate Field

Mar 21, 2013

I've just returned to work after kids and started managing a large Access database related to health, back-tracking over many years.

Currently in filling a form we physically enter:
Apples 2.2
red apple 2.4
red apple cut 2.45
Oranges 5.6
Cucumbers 8.5

Is it possible to get field 2 to automatically fill with a number code due to the text typed in field 1?

FWIW, I'm confident at more basic Access e.g making follow on default value = Dlast("field""table") type stuff but the more complex stuff I haven't touched since Uni over a decade ago and you will need to be gentle while I blow away the cobwebs

View 3 Replies View Related

Reports :: Access 2003 / Report Show Items From Previous Invoices?

Apr 15, 2013

I am building a replacement Access 2013 database for our ageing Access 2003 database. I have an invoice form with a subform with a combo box that allows me to select which jobs to invoice based on the customer selected in the invoice form, which is working fine. I have designed my invoice and have the criteria [Forms]![Invoice]![ID] in the report query so that it just selects the record that is open in the invoice form. I have an ID (which is the invoice number) group on the report and it is then sorted by date and then job number. I thought it was all working fine when I tested it, it is the same method as I used in the 2003 database. However I have a problem, when I make up and print the customers first invoice it works fine, but when I go to make up a second invoice for the same customer the invoice includes all the jobs from the first invoice as well, and if I then go to reprint the first invoice all the jobs from the second invoice as there as well.

View 1 Replies View Related

Reports :: Generate A Report For Items In Previous Sentence Not Completed To Keep Track Of Workload

Jul 29, 2013

I'm completely new to Microsoft Access. This project was thrown my way. I have an accounting database to track payables, receivables, financials, and deliquencies/collections. Is there a way to generate a report for any of the items in the previous sentence that haven't been completed to keep track of workload.

View 5 Replies View Related

Forms :: Concatenating Listbox Items - Column Data

Mar 18, 2013

I saw the following code on the forums...

Dim i As Integer, c As String
With Me.ListBox.Column(0)
For i = 0 To Me.ListBox.ListCount - 1
c = c & Me.ListBox.ItemData(i) & ", "
Next
End With
c = Left(c, Len(c) - 2)

This works great!! Now I am trying to concatenate the column 3 of the listbox.

Tried to use the code below (pointing to the second column) but it always returns the first column data.

'Dim i As Integer, d As String
With Me.ListBox.Column(2)
For i = 0 To Me.ListBox.ListCount - 1
d = d & Me.ListBox.ItemData(i) & ", "
Next
End With
d = Left(d, Len(d) - 2)

ItemData does not allow pointing to my 3 column of the listbox.

View 4 Replies View Related

Default Value From Previous Entry Into Field

Apr 4, 2008

Hi,

I have a user who would like the value from the last entry into the form's title field text box to show as the default value when he clicks on enter new issue button to bring up a new record. I do not know if this is possible but I thought I would check for him.

View 14 Replies View Related

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

Valildation Based On Previous Cell Entry

May 8, 2006

I'm new to this forum and I'm sorry if this is a repeat question...I looked in previous threads, but could not find my particular questions.

Here's the situation:
I enter a bird name in my form (I've set up a combo box of 200 choices). Each bird species has an max and min possible wing measurement. So when I enter a newly captured bird in my form, the wing measurement must fall between the minimum and maximum for that particular species. I've done similar things with cascading combo boxes, but can't figure out how to the do a between-type statement in this situation.

Thank you much,
Erik
LSU, Baton Rouge, LA

View 9 Replies View Related

General :: How To Get Single Table Entry View For % Allocation Of Items

Dec 28, 2014

How could I create a single table (matrix) type input view to allocate bank transactions to categories, noting one transaction can be allocated multiple categories with an associated percentage? What approach should I use in Access to get this? So say I have the following tables:

* Transactions
* Business Category
* Transaction-Business-Allocation (which includes)
- Transaction ID
- Business Category ID
- Percent Allocation

But in terms of the means of reviewing bank account items and allocating I really want a view like this (see attached image)The specific business category could be either selected specifically, or all included.

View 1 Replies View Related

Forms :: Can't Edit Or Add Any Data In The Subform Results With Previous Setting

Mar 28, 2015

i've got a Form that contains Subform with an embedded Query that contains 2 tables only (Payments & Invoices) the Join properties between them show all records from payments and what matches it from Invoices where the joined fields are equal (Invoice no).. So, when i enter certain data in the main form the Subform show the results for it from Payments table and only one field needed from the Invoices table !!

The problem is.. i can't edit or add any data in the Subform results with the previous setting, but when i completely remove the Invoices table from the embedded Query then swift to the Form and it's Subform.. i become able to edit and add data in the Subform easily... !!

So, how to enable the edit/add in the Subform with the 2 tables in the embedded Query ?! Cause it's really needed to show that field from the Invoices table.

View 3 Replies View Related

Forms :: Display Data Based On Previous Record But Not All Fields

Jan 22, 2015

There is a form which the user fills in 8 fields and saves it. Once saved, a new record opens.

However, I want to modify the save button to save the previous record and display a new record with only a limited no of fields to display from previous record, say 4 fields display from previous record, and the user fills the remaining 4 and saves it. Thus, the save cmd should continue to display 4 fields from the previous record.Already tried below code for save button but it displays all data of previous record as it is, doesn't display blank space for combo.118 and text2

DoCmd.GoToRecord , , acNewRec
DoCmd.GoToRecord , , acPrevious
Combo118.Text = ""
text2.Text=""

View 1 Replies View Related

General :: Setting Default Value For New Entries As Previous Entry

Jan 17, 2013

Is there a method of setting the default value for new entries to the same value as the previous entry?

For example, I have a quality control information table that stores QC data for different lot numbers. It is annoying to enter in the lot number and product code field over and over again if there are dozens of records per lot number. Is there a way for Access to easily display the previous entry as the default value?

View 1 Replies View Related

Forms :: How To Auto-populate Section On Form That Corresponds To Previous Data

May 30, 2013

Ok, this is what I have, I have a database that has 3 tables, a year table, that all my forms get inputted into, a table that has manufacturer addresses on it and a table that has sampling locations.

On my form, I have it where there is a drop down box, so you can just select the name of the manufacturer and select the name of the sampling location. But what I want it to do is, that you select the name from the drop down box and then in another box or two it auto populates the corresponding street address, and city for both the manufacturer and the sampling location.

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 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 1 Replies View Related







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