Forms :: Force Users To Enter Data

Aug 4, 2015

My database is tracking Job/Project information. The users must assign the Job Contacts which can be both internal and external (ie: Contracts is a Client Contact, while Engineer is an Internal position)..

tblContactTypes which defines each of the 10 types of job contacts.
fldTypeID: fldTitle fldClient fldInternal
1 Contracts True False
2 Engineer False True
3 Other True True

The Job Specific data is stored in tblJob_Contacts

fldJobID (PrimaryKey)
fldTypeID (from tblContactTypes)
fldEEID for Internal Contacts (from tblEE)
fldContactID for External Contacts (from tblClientContacts)

My question is this...How can I force the user to enter the Contact information for Contact Types 1,2,3, and 4 while leaving the remaining contacts types as optional?

I would like a form with combo boxes for the first four Contact Types which must be assigned for every job and then a continuous subform where the user can assign the remaining contact types if needed.

Initially, I planned to store the first four Contact Types as separate fields in the main table (tblJob) - however, distribution lists are needed and it makes more sense for all the contact information to be stored in the same table.

View Replies


ADVERTISEMENT

Forms :: Password To Enter Data For Users

Mar 12, 2014

I am trying to set up a password on a for different users to have to enter pins to enter data. When a user selects his/her name from the combo box the next field will be something like pin. When they enter the corresponding pin this will allow them to edit and start or continue (if they left) fill out the rest of this form.

The reason being this way is that if one of them goes back to a previous record done by another user (which I want them to be able to view) they can view it but cannot edit it because they do not have the users pin (or password). Is this able to be done, only allowed to edit or create a new record if you enter your pin every time.

View 4 Replies View Related

Can Multiple Users Enter Data At Same Time?

Aug 20, 2013

I have several forms will be filled out on a daily basis by 50 different people. Does Access have a way of allowing multiple users to fill out the forms at the same time and still track the data? Or is it like Excel and can only be viewed as "Read-Only" once opened by someone else?

View 5 Replies View Related

Mandate Users To Enter Data In Textbox Before Proceeding To Record On Form

Nov 21, 2012

Any way (VBA script, etc) to make it mandatory for a user to enter data in a textboxes in a form before proceeding to the next record on a form? I know I am able to do this in the table by selecting the value "Yes" in the Required area in the General Tab but I was wondering if there is a VBA script you can enter it in a form instead.

On attachment is an Access Database in winzip. In the __Property form, I want to make it madatory for users to enter data in the County Shapefile Gross Acres, Township, Mineral Severance Tract, and Unit name fields before proceeding to a new record. If data is not entered in these textboxes for these field, then a person will not be allowed to go to the next record.

View 7 Replies View Related

Allow Users To Enter Hyperlink Addresses

Aug 30, 2006

I have a database set with user level security (via the wizard) and I want to give "Full Data
Users" the ability to enter hyperlink addresses. Currently only I can do
this as I am set to "Full Permissions / Admin"

The associated table is set to accept hyperlinks, and the relevant text
boxes are in place and unlocked on the forms, however when logged in as a Full Data User, you currently can not set or add a hyperlink address, only follow the hyperlink path's that i've already put in.

It's driving me nuts.... help please!

View 2 Replies View Related

Forms :: Can't Enter Data Into Form

Jul 1, 2014

I was able to enter data into my form but I made a few design tweaks and added another table into the form and now, in form view, I''m unable to enter data into any field.

View 11 Replies View Related

Forms :: Enter Data To Subform With Autopopulate

Jun 24, 2015

I know the way to SELECTDISTECT on a combobox referring to a table so the value will autopopulate in the combobox. But is that doable in a subform?

I have a table with 3 columns. First Name, Last Name, Relationship.

I want to let the user adding data directly to the subform, but when typing RICHARD in the first record of First Name, then on the second record, when they type R, it will suggest RICHARD, a kinda auto fill if desire.

View 11 Replies View Related

Forms :: List All Records Then Enter Data

Jul 29, 2014

I'm working on a database that tracks students and grades. I have a tblStudents with Personal details, tblStudentsAndClasses which allows me to have a one-to-many to many-to-one relationship, tblClasses with all the class info, plus a tblGPA.

I'm wanting to list all the Student's names listed with their current class and have blanks for data entry for Grade, Grade status, and have a current timestamp in another field. So the teacher can enter the Grades and Grade Status for all students on one day in a single form (think EXCEL). The way I have it now, is that (x number) grades that have already been entered shows up as (x number) copies of the same student. So my relationships are probably set up incorrectly also.

I can't filter out IS NOT NULL because I wouldn't get any students with grades already entered in.

I've found a post on another bytes.com that is REALLY close to what I am looking for, but I don't know anything about VB to be able to adjust it to fit my requirements. I would have tried to do a forum search here, but I'm not sure what terminology I would search for.

View 1 Replies View Related

Forms :: Opening A Form To Enter New Data Only

Jun 7, 2014

I have been having problems with opening a form to add new records only. I have gone through all possible solutions but somehow the problem persists.I want to add new records only and not view any of the existing records. I have set the form properties to Date Entry Yes, Allow additions to Yes, Allow Edits to No. The form opens through a command button on another form and the vba code is the following.

DoCmd.OpenForm "FormInvDetails", acNormal, , , , acDialog

View 14 Replies View Related

Forms :: Using A Form To Enter Data Across Related Tables

Mar 3, 2014

I have a database I made to store a list of users and information about each user.

I have a UserDetail table, languages table, previous experience table, current experience table.

UserDetail table as follows:
UserID (PK)
First Name
Last Name
Full Name (calculated)
Department (using a multi select combo box. There are 3 departments and some people are in both).

I need to do the same thing on each table and each table is very similar so I'll just list one. This is the Previous Experience table:

PreviousXPID (PK)
Previous experience (e.g. IT, Marketing, Chemistry)

I have three junction tables. One for each Previous Experience, current experience and language table. The Previous experience junction table has:

ID (PK)
UserID
PreviousXPID

I created a relationship between the userdetail table and the junction table then the junction table to the Previous Experience table.

Now what I'd like to be able to do is edit people to add previous experience, current experience and languages to each. I already have a form that lets me add a new user to the database. It's just based on the UserDetails table. If I could have a way (perhaps using 3 multi select list boxes. One box for previous experience, one for current experience and one for languages) on that form to add the other details to that person, that would be ideal. I'd like to create a new user. E.g. Joe Bloggs in department 1 who speaks Dutch, used to have Marketing, Chemistry and aeronautical experience and now works in IT.

I can create the new user by putting last first/last name and selecting the department. But to add experience or languages, I have to go into that junction table and add the numbers myself. e.g. user 1, has experience 1,3,4 and 5. I'd like to see the name that relates to the ID and be able to select it from the list in the table I have.

View 11 Replies View Related

Forms :: Forcing User To Enter Data Into Certain Fields?

Nov 23, 2013

i have a form with various tabs and a number of fields. If I could I would just select all fields to "required=Yes" in the table design mode. But some fields should only have data entered if another field has a certain value. So, I think I just want all visible fields for this data requirement (I set some fields to visible=false if I don't want them to have a value).

So far I tried to do this on click of the Submit Record button which I created using the "docmd.gotorecord, , acnewrec" statement, but I can't seem to make it work when combining it with if then msgbox statements. Plus I typed an if then statement for every required field.

Here's my code below:

Private Sub AddNewRecord_Click()
On Error GoTo Err1
DoCmd.GoToRecord , , acNewRec
Me.Label216.Visible = False
Me.CM_2A.Visible = False

[code]....

View 14 Replies View Related

Forms :: Forcing User To Enter Data Before Allowing Save

Dec 23, 2013

I have a form that a user fill out to populate fields in my database...how can I make it so that user MUST fill in certain fields before they are allowed to save data?

I need to stop users from taking shortcuts when entering data, and skipping a lot of fields. So i would like to be able to specify the minimum fields, and an error message must show when they try save incorrectly to alert them to this.

View 1 Replies View Related

Forms :: Limit Amount Of Data That Users Need To Input

May 23, 2014

We have a database where we are trying to limit the amount of data that users need to input.

We have a form, which contains order information. Where a customer has specific requirements, we add those requirements to a separate document review table MasterSpecification and DetailedSpecification.

When a customer has specific requirements, we can open the frmMasterSpecification and search for the document.

Assuming a review has been done the requirements will be shown on the subform Frmsubcoverage. I would like to be able to select the record source from this form and have the details entered into our order entry form.

Under the specification form there could be many sub coverage records depending on the type of item ordered to that specification.

View 6 Replies View Related

Forms :: Restrict User To Enter Data If Dsum Exceeds Total

Sep 8, 2014

I need to be able to restrict users enter a value in the text box (on Form B) called "FTE Assigned" if Dsum of a field called "FTE Allocated" in another form A is less than what is going to be sum of FTE Assigned after the value is entered.

Both these forms are used by users to enter data in the 2 separate tables which are linked together through a join.

Master table - having FTE Allocated values and secondary table having FTE Assigned values.

Basically a message box would do if Dsum (of FTE used) is coming out higher than FTE allocated.

View 4 Replies View Related

Forms :: Unable To Enter New Data In Form With Fields From Multiple Tables

Jan 6, 2014

I had an existing database with 2329 records entered into it. All of the fields (220ish) were all in one table. Myself and my co-workers wanted to rebuild the database without losing the data. We wrote queries to transfer the data from the original database to the new database and split the data from the original 1 giant table to 9 smaller tables.

The transfer of data worked so I went to start making forms. When I went to add fields from different tables I had to built a relationship, which I did. All of the data that transferred over from the new database is in the form (now multiple forms linked by button) but I can't add new information. I get an error stating, "You cannot add or change a record because a related record is required in table ..." and the table referenced keeps changing.

View 2 Replies View Related

Forms :: Can't Enter Data Into Blank Field On One Side Of Outer Join

May 21, 2014

I think I have just finished designing my database and I tried to test it and I couldn't enter any new records as it says "Can't enter data into blank field on "one" side of outer join" whenever I try and enter info and I don't know much SQL to work out what has happened. It probably causes this too but I also cannot select check boxes.

The form where I try and enter the info is called Crisis_support_workers v3. I have attached my database so you can look at what I have done.

View 1 Replies View Related

Switchboard Front Page - Users Able To Access Forms For Data Input

Dec 8, 2011

I have created a switchboard 'front page' through which I hope for users to access the forms for inputting data.

Within this front page I have an 'enter' button - successfully created - everything.

However, I am unclear as to how you activate this, or any other button. I have linked it to the appropriate form and stated the action I want it to undertake, but nothing is happening.

What further instructions do I need to provide ...and where?!

View 5 Replies View Related

Modules & VBA :: How To Force Save And Maintain Integrity Of Data Input To A Form

Jun 15, 2014

I have a button that when clicked moves a piece of data to a subform. I have put the whole sequence below. The trouble I am having is :

- The event will not happen until the form is saved. I think this is because fkTaskID is a new record (auto) number which hasn't generated yet.
- If I force the form to save it does work but then I get an error on the INSERT command when not all required fields of the form are complete (see sample in second part below).

Is there a way to save the record and maintain the integrity of the form input - and still have this code work?

BUTTON CODE
==========
Private Sub BTNAddReasonRw_Click()
Dim dIndex As Long
DoCmd.SetWarnings False
For dIndex = 0 To Me.LISTReworkReasonsUnselected.ListCount - 1

[Code] ......

View 1 Replies View Related

Forms :: Force Value In Unbound Combo Box?

Mar 26, 2013

Ive got a database with a combo box, called "combo1" (with 2 columns). It is unbound but uses a query as its row source. When i select a value in combo1 is places the data from combo1.column(1) into a textbox (text1). I then click the next record button (button1) and it then keeps the same value in combo1 because it is unbound. So i need it that when i go to the next record it displays the value in combo1 that relates to text1.

View 2 Replies View Related

Forms :: Force A Start Place In A Textbox

Jun 26, 2014

I have a textbox (Odour), that contains one of four words (Cadaver ( ), Drugs ( ), Explosives ( ) or Money ( ) ), the word is written in by pressing one of four buttons, this works fine.

I now want the user to write in between the the brackets and only the brackets. For example:

The textbox contains Cadaver ( ), I want the user to be able to write between the brackets "Blood".

I seem to recall that there is a way of only allowing the user to type in certain places within a textbox.

View 2 Replies View Related

Forms :: How To Force Execution Of A Query When Changing Record

Jul 13, 2014

I have the following tables:

Supplier
Supplier# [Other columns]

Material
Supplier# Material# [Other columns]

DeliveryHeader
Delivery# Supplier# [Other columns]

DeliveryDetail
Delivery# Supplier# Material# [Other columns]

I've created a form based on table DeliveryHeader with a subform based on table DeliveryDetail. The two are linked by Delivery# Supplier#.

On the form, Supplier# is a combobox that lists all suppliers from table Supplier.
On the subform, Material# is a combobox that lists only the materials supplied by the supplier selected with form's Supplier#.

The problem is that this second list always shows the materials of the first listed supplier. For instance, when the form is loaded, it shows delivery #1 with all its details on the subform. Suppose supplier loaded to form is #1.

1) If I use subform combobox, it shows correctly supplier's #1 materials. But then, whatever delivery I navigate, it always shows supplier's #1 materials.

2) If I navigate to another delivery without using subform combobox, suppose I stop on a delivery where the supplier is #4, then subform combobox shows correctly supplier's #4 materials. But then, once again, whatever delivery I navigate, it always shows supplier's #4 materials.

I've spread Me.Requery here and there but without any success. What trick must I apply to force the execution of the query of the subform combobox Material# each time I navigate to a new record on the form?

View 4 Replies View Related

Forms :: Force Update Of Field Before Record Is Saved

Aug 1, 2013

How can I force a field in a form to be updated before the record is saved / changed?

For instance I have a form with information on it and I want to ensure that any time the form is updated the user fills in a section providing the date and by who it has been updated by. I dont want the record to save unless that information has been filled out, and I also want it to take you to the field if you press save and it hasnt been filled out along with an error message.

To try and be a bit clearer. At current I have a Save and New button. This saves the form if dirty and opens a new record.

I want to add in the step that if record has been changed and FieldA has not just been updated then go to fieldA (Showing a message box). If FieldA has just been updated then save record and open new as normal.

My current save & new button properties are as follows (in Macro Editor)

On error Go To Next
If [form].[dirty]
RunMenuCommand Command SaveRecord
End If
If [MacroError].[Number}< >0
Message =[MacroError].[Description]
Beep Yes
Type None
Stop macro
On Error
Go To Fail
Go To Record
Record New
Go To Control
Control name Resort Code

View 3 Replies View Related

Forms :: Force Unique Set Length Field Value OR Exceptions

May 2, 2014

Is there any way to force a field value to be unique and of a set length, but with exceptions?

Let me explain... I have a text field in my table called "employee_number" and this value is always one of the following:

NULL
an 8-digit number
the word "External"

What I want to do is to force that field to either be NULL, the word "External", or a unique 8-digit number.

Is this possible? Obviously I can't set the source field in SQL to accept unique values only but I wondered if there was any way around it at form level?

View 8 Replies View Related

Queries :: Enter Data Not Less Than Certain Data In Another Table (field)

Apr 22, 2013

I have a query called "Stock" containing field like (Item, Description, product_qty)

Another is a table called "Sales" with fields like (Sales_ID, Item, Sales_description, sales_Qty, date_Of_Sale) Item field on sales is a foreign key.

Now what i want is how can i make when the user enters new record, in field "Sales_Qty" the data entered here to be less than product_Qty.

NB; this is because you can not sell more than what you have.

View 4 Replies View Related

Can't Use Data Access Pages To Enter Data

Apr 14, 2012

I am trying to set up some data access pages as data entry into a table with access 2000. I can see the records in both the data access forms and the HTML forms, but cannot create new records into the table. I have tried to change the property to DataEntry etc... but nothing seems to work.

View 2 Replies View Related

Cannot Enter Data

Sep 3, 2007

I have built a database which has been running OK for 3 or 4 years. Something happened the other day (error - rebuild d/base) and now there are certain fields that I cannot enter any data into. Others are fine and I can see what is already there.
Any suggestions very welcome.

View 2 Replies View Related







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