Blocking Data Entry

Jan 14, 2008

Sales information can be added against a customer record. What I would like to achieve is for users to still be able to record new sales information, but historical sales information (e.g. before 2007) can be viewed but not be able to be edited or changed. Is there a way of achieving this.
Thanks in advance...Paul

View Replies


ADVERTISEMENT

Blocking Data Input

Jun 11, 2005

In my data input form I have several boxes. In one case i wish to allow data to be input if a certain box is marked. that mark will allow any of six boxes to be checked. This works for me. However, in the event that the certain original box is marked in error, how do I allow the box to be unmarked and make the six other boxes closed to input?

such as: (box) do it
(box) one (box) two (box) three

box do it is marked. It allows any of 1,2,3 to be chosen. Box do it is marked in error and reclicked to blank. Boxes 1,2,3 need to close up so they cannot be marked. How do I get them to close up?

Thanks

View 1 Replies View Related

Blocking A Query

Jan 8, 2005

How can you block a query from getting new information from a table? but yet keep it's current values.

View 1 Replies View Related

Blocking Design View

Jun 15, 2005

How can I get Design View off the toolbar? I have users getting into it and making changes. I need to keep this from happening.

Any ideas?

Thanks

View 3 Replies View Related

Blocking Security Warning When Access Starts

Apr 18, 2007

When I open my DB (I use Access 2003), Access flashes a window 'Security warning : This file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel the operation?'
How do I stop this annoying message so that my DB opens directly?

View 1 Replies View Related

Data Entry - Auto Fill Data For Exisitng Accounts In Records

Mar 9, 2006

First I would like to give thanks to all the knowledgeable folks here who have helped me with my DB to date. It is working and every one is very happy and I have learned a lot.

So now I would like to add some more functionality to this existing project.

My DB is for data input of customers for a drawing. It has the following fields: Id, account number, first name, last name, date/time, score1, score2.

I t is taking a great deal of time for the users to enter in hundreds of entries a day. Most of the entries are customers who are already in the DB. I would like to get the fields to auto fill the data for existing customers say after the account number is entered. So after you put in the account the name and any other pertinent data would shows up saving users from typing it in again.

The first problem I am having is that this is still a data entry form and I can’t figure out how to be able to see the account information and still add new data to the record? The new data is a daily score they get.

Second I haven’t figured out how to call up the customers information from just the account field.

I’ve googled this and haven’t found anything terribly helpful.

View 2 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

Modules & VBA :: Datasheet Mode Form For Both Data Entry And Data Retrieval

Feb 9, 2015

I want to use the same form in datasheet mode for data entry and retrieval. When retrieving, all controls are disabled and locked. I am trying to enable and unlock them for modifying but that isn't working.

<code>
DoCmd.OpenForm "PO_Practice Data", , , , acFormEdit, acHidden

Forms![PO_Practice Data]!PO_Name.Enabled = True
Forms![PO_Practice Data]!PO_Name.Locked = False
Forms![PO_Practice Data]!Practice_Name.Enabled = True
Forms![PO_Practice Data]!Practice_Name.Locked = False

[code]...

View 3 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

General :: Updating Table Data With Data From Preceding Entry?

Jan 5, 2013

My question is this: I have a table where I'm entering employees' hours worked. Basically, it's something like this:

ID WorkerNumberDateworkedTimeStartTimeEnded
121/2/201310:00:00 AM3:00:00 PM
221/3/20132:00:00 AM11:00:00 AM
321/4/201312:15:00 AM11:30:00 AM
421/5/201310:25:00 PM11:00:00 AM
531/2/201311:00:00 AM3:30:00 PM
631/3/201312:00:00 PM10:00:00 PM
731/10/20137:00:00 AM4:00:00 PM

I have a query that (easily) determines how many hours an employee has worked on any given day. What I can't figure out at all, is how to write a query that can figure out how much time an employee had off in between shifts.

Thus far I'm able to run a query that separates this main table into individual workers by their id numbers, but can't figure out how to determine time off between shifts - as the last hour worked one day, and the first hour worked the next day are on two different lines (they are two different table entries).

View 4 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

Multiple Data Entry Clerks Inputting Data

Mar 5, 2008

I have a shared db where there is a requirement for more than 1 user to enter data in the same form and hence the same table. Up till now there has only been 1 data entry clerk so there has not been a problem.

Would accessing the same form by different users cause a problem, assumming they are inputting different records?

View 9 Replies View Related

Refreshing A Data Entry Form After Saving Data

Jul 6, 2005

This has most definitely been asked before but I really cant find anything on the forum! Ive created a data entry form which has a save button which the user must click each time to save the record. However how do I refresh the form i.e. empty all data from the previous record without exiting the form. Ive tried to combine the undo macro but that simply deletes the previous record. Any help please!!!

View 3 Replies View Related

Data Entry Req

Apr 19, 2006

How do I make data entry required, I've sent it to be in the table but it doesnt seem to work in the formI've tried the below with no luck Private Sub Command14_Click() If tbName = Null Or tbTelephone = Null Or tbAddress = Null Then MsgBox "Please complete all details.", vbExclamation Else DoCmd.Close DoCmd.OpenForm "frmInvoice" DoCmd.MoveSize , , 5100End IfEnd SubCheers

View 1 Replies View Related

Data Entry -- Many To Many

Jul 18, 2006

Hello,

I'm looking for opinions on how people like to enter information into a many to many relationship.I understand how a many to many works as well as a Main Form/Sub Form.

Subforms is what I currently use. Would you do anything different? Below is a sample of fields I currently have. Any advice? I keep wondering if there is a better way. I'm not a huge fan of sub forms. I also build lookups from the Junction. Is this correct?

tblProjects

ProjectID PK
Project
Date
Budget

tblProjectsandManagers

ProjectID PK FK
ManagerID PK FK

tblManagers

ManagerID PK
FirstName
LastName
Phone#

Thanks

View 1 Replies View Related

List For Data Entry

May 18, 2005

I've got two tables, Properties and Valuations. Every six months the properties are revalued. I want to have a datasheet list of all the properties with a blank field for the new valuation so that the user can just go down the list and enter the new amount without having to select every property individually. Can I do this?

View 5 Replies View Related

Data Entry And Relationships

Jan 31, 2006

Hi everyone,

I have a relationship between Market data table and Trade table which is One to Many. Market on the One and Trade on the Many.
However I just found out that I am unable to enter information into the Trade Form without entering information into the Market Form first.
I would like to enter info. into Trade Form/tables independent of whether I enter info. into the Market Form/table, but I still need to have the relationship of One Market data to Many Trade date.

Thanks

dfuas

View 5 Replies View Related

Data Entry Method

Aug 3, 2006

I want to have my records in my form show the latest entry, not a completely new form. The user will click on the new record button to create a new record but I want the user to be able to see the last record. Anybody know how to do this?

View 14 Replies View Related

Allow Data Entry Only For Few Controls

Mar 31, 2008

i have a data access page, which as a querry in it.

When i set dataentry true, none of the recrods are visible.

but, when i set dataentry false all the records are visible, here i have to change a value (ex; change a value in drop down ) which should get saved into the data base,

Please help.

View 2 Replies View Related

Auto Entry Of Data

Apr 6, 2008

I am new to Access and I am trying to update our existing database. Presently our database is used to report incidents that have multiple subjects per incident. Is there a way to have a field recognize the data ie. the last name of an individual, and automatically fill in the remaining fields for that individual without having to fill in each field over and over again?

Your help would be greatly appreciated.

View 2 Replies View Related

Restricted Data Entry

Aug 23, 2005

Hi,

Im copying information from Excel to Acces. As I enter the information in fields in Access, this goes just fine. The problem is that sometimes I have to change the information I put in. So for example I first copied 10 record(cells), but now I discover that I have 20 records/cells. But Access refuses to let me enter more than ten. Does anywbody know why it does this and how I can fix it?
Thank u,
Stacey

View 3 Replies View Related

Automatic Data Entry

Jul 2, 2007

Hi there,

I have a table called Cars and a table called Rent

In Cars i have Car ID (Autonumber and primary Key) and Price Per Day

In Rent I have Rent ID, Car ID and Price Per day

The Car ID in Rent is a lookup from the Cars table, but is it possible to make it so that when i enter the Car ID in the Rent table, it automatically fills in the Price per day field for me?

Sorry if something like this has already been posted, i didnt know what this is called so didnt know what to look for.

Thanks
Chris

View 5 Replies View Related

Auto Data Entry

Apr 11, 2008

Hello All,

I was hoping someone could tell me the correct method of performing my intented function.

I would like for Access to Auto Input data from another table based on one entry in the current table.

Table 1 consists of Field 1 (Part Number), Field 2 (Serial Number) & Field 3 (Description).

Table 2 has Field 1 (Part Number) & Field 2 (Description).

Based on the info from table 2, how do I get the program to auto input Field 3 from table 2 (when I type in Field 1 in table 1)?

Thanks in advance

View 7 Replies View Related

Data Entry With More Than 255 Words

Feb 10, 2005

Hi, if i have to input a entry that have more than 255 words, but my table could only handle 255 words, so how do i go about it... pls advise, thanks...

View 3 Replies View Related

Lock Data-entry

May 10, 2005

When a order (identified by orderid) of products reaches a certain status I lock the article numbers (with an orderrule number 1 to many to that order-id) from changing. This works ok, the user can't change the article numbers and quantities. What doesn't work is the fact that they can still add records to that order. How can I get Access that far that they can't add records?

View 3 Replies View Related







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