Forms :: Data Entry Form For Specific Assets

Jun 26, 2013

I have a bank of 8 machines, I need the user to enter one record for each machine in order. I currently have these machines in a combo box, but any other method would be fine.

When the user opens the data entry screen, I need it to open a data entry with that machine selected and the machine number pasted to the [Machine_No] field, when the user has finished entering the data (mainly yes/no tick boxes) I need them to click a "Next" button and have the data entry form to move on to the next record, the next machine on the list. This needs to be done in machine order as listed. I would then like the "Next" button to be hidden or disabled or changed to "Finished" (Close Form button)when at the last machine in the list.

Is this possible. I am using Access 2010 ...

View Replies


ADVERTISEMENT

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

Creating Dynamic Hyperlinks - Open Data Entry Form And Navigate To Specific Record

Nov 28, 2011

I have a form that lists records in a table. I would like to have a hyperlink beside each record that will open the data entry form and navigate to that specific record. Right now, the use can only open the form for all records and has to use the record navigation buttons to find the desired record.

View 1 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 :: 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 :: 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 :: 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

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 :: 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

Forms :: Data Entry Form To Add New Records To Access Database File

Sep 30, 2013

I have a data entry form to add new records to an Access database file called Claims. An auto-incrementing sequence number (SeqNbr) needs to be kept PER YEAR. If the user enters a date the sequence number pertaining to the year of this date needs to be incremented. The first record within a new year of course takes value 1.Records can be added at random for different years.

A simple SQL-statement can be made to determine the new sequence number:SELECT max(Claims.SeqNbr) + 1 from Claims where year(this.value) = year(Claims.EventDate)...this.value meaning the value of the date control in which the user entered the date.I need to return the new sequence number to another field on the form in which also the COMPANY CODE, YYYY and MM from the EventDate, the new sequence number and the USER INITIALS are concatenated.

View 4 Replies View Related

Forms :: Multiple Records - Export Specific Fields Depending On Entry

Jun 2, 2013

I am in the of designing an access 2010 database for data entry. Is it possible to create a button on a form in which a prompt asks a user for which records to export. Then depending on the entry export specific fields (First Name, Last Name, DOB) to a specific excel 2010 workbook (setup) and worksheet (template)?

For example, if the user entry is 1, only record 1: First Name, Last Name, DOB is exported to the setup.xlsx (more specifically the template worksheet of the setup.xlsx). However if 2,3,4 are entered then records,2,3,4: First Name, Last Name, DOB are exported to the setup.xlsx (more specifically the template worksheet of the setup.xlsx).

View 1 Replies View Related

Forms :: Open Form And Show Specific Data To Display

Apr 1, 2013

I have a form and this form shows some values from one table. One of the fields named as Key. I want to open another form and show the record that has the same value as Key.

I am able to make this with filter but the form opens and when the user navigates the record, it creates a duplicate value in related table.

I want to open form and find specific data to display and then stop at this record.

View 1 Replies View Related

Forms :: Access Will Not Open New Form With Specific Data Instead It Returns All

May 2, 2013

I am currently creating a database in a hierarchical system that is to be used by multiple users to enter information specific to them. The tables are arranged like this:

Owners
Modules
Tasks
Highlights

Theses are connected using primary ID's and Particular Entries in the next table so they form a hierarchy - when you expand owners it brings up a list of Modules attached to that owner, then expand each module and it brings up a list of tasks associated with that module, expand the task and it brings up a list of highlights associated with that task. This is all very straightforward of course but what I would like to do is create forms that basically match so that the users can navigate from their name, through their modules and tasks and then add highlights to each task.

For this I have been using continuous forms to list all the different entries and inserting a button in each entry that I would like to link to the next form and find the specific data, however when I try to do this the button always without fail will just return all the entries from the form rather than the specific ones requested. I set up the button using the wizard and select 'open form and find specific data' and then select two entries that are identical on each form. I have trawled the internet quite a bit to try and find why this is happening and have inserted various bits of code etc into the embedded macro in an attempt to make it work but to no avail.

I wonder if there is something I need to activate on the form that the button connects to aswel or if I need to connect these forms using the relationship that I used to connect the tables (I am still using a unique identifier).If I connect to a single form it will display the first entry on the list (and I can cycle through them all) on a continuous form it will display all entries starting with the first.I would like it to display all entries for the selected record on the form.

View 1 Replies View Related

Forms :: Default Entry Into Subform Based On Data Entered In Main Form

Apr 23, 2014

I have a form that request the User to enter a Parcel ID number (99-9a-99-99aaa-aaa-aaaa). The sub form asks for the subdivision number, block number, and lot number. The subdivision number, block number and lot number are normally part of the Parcel ID number but sometimes they can be different. I want the sub form to fill in the Subdivision number, block number, and lot number as a default but allow the user to change the value if needed. currently the sub form will only show what is entered into the table itself if a change is made on the main form the sub form does not reflect the change.

View 3 Replies View Related

Forms :: Data Entry Form - Drop Down List With Free Text Option

Aug 6, 2013

I have a simple data entry form with drop down facilities on 2 fields. One of these fields incorporates a drop down list from a table but there are occasions when I wish to make a free text entry for the single record, but do not wish to add it to the drop down list.

I have tried to achieve this with a Combo Box but without success, although I am sure that I have read that it is possible.

View 14 Replies View Related

Forms :: Password Validation - Message Pop Up With Specific Error User Has Made On Entry

Jan 6, 2014

I am looking at the public function routine, that validates the password entry. I want to know how i can make a message pop up with the specific error the user has made on entry.

Public Function ValidatePwd(varPassword As Variant) As Boolean
Dim blnValid As Boolean
Dim blnValidCriteria As Boolean
Dim intChar As Integer

blnValid = Len("" & varPassword) >= 4 And Len("" & varPassword) <= 12

[Code] ....

View 11 Replies View Related

Forms :: Create A Data Entry Form To Order Table Using 2 Cascading Combo Boxes

Jan 31, 2014

What I am trying to do is create a data entry form to an "order table" using 2 cascading combo boxes. I have created a data entry form based on a query. I can't get the cascading combo boxes to work properly.Here is the code:

Private Sub Combo0_AfterUpdate()
Combo2.RowSource = "SELECT L2_ID,L4_Element_name,L5_Category FROM qry_ord WHERE L3_ID = Combo0.Value;"
Combo2.DefaultValue = [Combo2].[ItemData](0)
Command4.SetFocus
End Sub

[code]....

View 2 Replies View Related

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

Forms :: Inventory Of Domain Assets - Search Button

Jun 24, 2015

I am currently the administrator of a fairly large network and am trying to keep inventory of all my domain assets. I would like to be able to search for these assets by a number of different ways such as computer name, location name (ie: CEO office, accounts receiveable, or human resources), slot number on my switches (I would like to know whats connected to where), and also what switch it is located on. Right now I am using a combo box to populate these fields but would like to implement a search function instead to be able to search with whatever information I have.

View 1 Replies View Related

Forms :: How To Hyperlink From Query To Specific Record In A Specific Form

Jul 23, 2013

I want to hyperlink from a query direct to the relevant record in a specific form. I have a hyperlink field in the form which shows up in the query. When clicked in the query, this hyperlinks to the form but I cannot make it select the correct record in the form.How do I get it to select the correct record?

View 3 Replies View Related







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