Redundant Entry

Sep 14, 2004

Each pay period, I must enter data for each employee that worked an extra shift. The table is simple:

Name
Period Starting
Period Ending
Number of Extra Shifts Worked


Is there a way to bulid a form that will keep the dates I type in the period starting and ending fields until I change them?

To clarify, I have 17 employees who worked extra shifts, and I don't want to have to type in the Period starting and ending dates for EVERY record. Thanks in advance for any help. I really appreciate it.

KellyJo

View Replies


ADVERTISEMENT

Data Base Creation, (Redundant Value Entry)

Jan 2, 2007

Hello,

I am using the access program to create a mailer. The fields are really basic... Name and address....

Many of the fields are going to be identical. City, state, zip code for instance.

The way we had it set up on our first try was to create the data base with all of the fields empty and to input everything over and over. I imagine there has to be a way to set it up so you only have to enter "San Diego" or "CA" once and then simply do manual entry of the names and street address.

Any help getting me started would be well eppreciated.

Thanks

View 1 Replies View Related

Eliminating Keypunching Errors Through Redundant Data Entry?

Oct 15, 2007

I work with an Access database with about 20 tables that requires considerable manual data entry. Although it is time consuming, the bigger problem is the keypunching errors that inevitably occur. A colleague of mine said that some databases can be set up so that two (or more) individuals can enter the same data into the database (basically creating two separate, temporary databases). At the conclusion of this double data entry, the two databases can be compared to see where they differ so that corrections can be made...the logic being that it's extremely unlikely two people entering the same data independently will make the same keypunching error in the same field.

Just wondering if Access has this capability, or if a reasonable facsimile of this approach exists.

Thanks!

View 2 Replies View Related

Redundant Data Issue..

Jun 30, 2006

I wasn't sure where to post this, so here goes:

Very basically, I have two related tables that I'm working with.

TABLE #1:
tbl_MAIN

FIELDS:
REC_ID (Autonumber) Primary Key [PK]
EMP_NAME
EMP_ADDRESS
DEPT_ID (Foreigh Key [FK] from the tbl_DEPT table...)
ETC...

TABLE #2:
tbl_DEPARTMENTS

FIELDS:
REC_ID (Autonumber) Primary Key [PK]
DEPT_NAME(Text)
ECT...

Now, I'd like to create a form that can enter information on the employee, including the department that they're a part of. I'd like to avoid having duplicate departments in tbl_DEPARTMENTS, but I want new department entries to be created if an employee from a new department is entered into the form. I'd like employees from a previously existing department to get associated with the department entry already in tbl_DEPARTMENTS. Is this possible? What's the best way to do this? I've tried every way I can think of, but I can't get this to work.

Thanks for any advice you can give me.

- Corey

View 2 Replies View Related

Redundant Foreign Keys?

Jul 8, 2005

More on the lot materials management program.

I have a series of related table:

Builder
Subdivision
Lot Number
Lot Option
Lot Materials Details

The [Lot Materials Details] table is populated by appending data from the [House Type Details] table tree as follows:

Builder
House Type
Elevation
Options Per Elevation
House Type Materials Details

The filtered Option Table in both branches determine which [House Type Materials Details] records get appended to the [Lot Materials Details] table.

The question is:
Is there any advantage, other than simpler queries later on, to adding the primary key from the [House Type Materials Details] table to the [Lot Materials Details] table.

It’s redundant because the [Lot Options Table] contains the [Options Per Elevation] primary key.

Any thoughts?

View 2 Replies View Related

Eliminating Redundant Records

May 21, 2007

Dear All,

I have a table with several fields.

Concentrating only on few fields I'd like to sort out redundant information (unnecessary records).

(It is similar to using Ecxel: Data>Filter>Advanced filter>Unique records only)

So, I'd like to ask for your help how can I reduce my table to unique records.

thx

Csaba

View 5 Replies View Related

Removing Redundant Rows?

Jun 13, 2007

Hi All

Can anyone help me with this problem?

I have an 11 million row table that lists relationships between pairs of people. There are several columns, but the relevant ones for my problem are

personA, personB, a-b_strength, b-a_strength.

because of the size of the table i'm having all sorts of problems, and i could actually cut out half of the rows, because for every row listing eg

dave, steve, 4, 5

there's another row listing the same information, but flipped round, ie

steve, dave, 5, 4

I'm sure there must be an efficient way to delete, using a query or otherwise, one of each of these pairs (it doesn't matter which). I have another column (id) that simply has a unique number for every row, ie 1,2,3->11 million, so i was thinking of something like

delete
from table t1
where exists
(select *
from table t2
where t1.personA = t2.personB
and t1.personB = t2.personA
and t1.id < t2.id)

So, this should delete every row that has a mirror version earlier in the list.(i think)

What i'm worried about though, is performance: is this going to make a new temporary table for the nested select for each new row in the outer statement? I already created a table that listed the count of friends for each unique person with a make table query, and that took 12 hours to complete. I don't mind another 12 hour query, but not a 144 hour query!

Any advice welcome - thanks! (Sorry for the longwinded post)

View 4 Replies View Related

Merging Redundant Columns

May 13, 2013

I'm doing up a database of hazardous chemicals, based on publicly available information from various agencies. Each chemical has a name and a number, and has different hazards associated to it. The hazards are grouped into classes, and for each class the hazard is further broken down into categories. Hence for an explosive hazard (the class) I could have categories 1, 2 and 3 based on severity. For each iteration of the hazard class and category (for example explosive hazard category 1), there is a non-unique hazard statement. Another complication is that there is a qualitative element in the classification system, and hence agencies from different countries could classify the same chemical differently. This should be captured into the database as well. Thus for every chemical, I will have to enter the Japanese classification, the EU classification, etc.

I've managed to set up what I think is a correct relationship, based on my understanding of databases. However when I generate the report, fields such as the chemical name and ID are repeated for each hazard. I would like to merge these redundant entries, so the chemical name, I.D., and any other repeated fields appear only once. In essence, I'm trying to make it such that there is only one entry for each chemical+I.D/country, with multiple hazard subentries, rather than having multiple, seemingly duplicate entries.

View 3 Replies View Related

Modules & VBA :: Scheduling System That Automates Some Redundant Tasks - Expanding Subforms?

Jul 28, 2014

I'm working on a scheduling system for my fathers company that automates some redundant tasks. Most importantly the system manages the order of processes on different parts (ie, part "tubes" may be cut, then drilled, then welded, then shipped).

I'm trying to create a form that allows for the editing and viewing of all the parts and the processes for each part for a specific work Order. Ideally the information that applies to all the parts (Work order Number, due date etc) would appear at the top of the form with all of the processes to appear beneath (Separated into groups - all the parts to be welded shown together). My problem with using sub forms for this was that I need all the records to be shown without scrolling. Is there a way to dynamically change the size of each Subform to match the required size, or is there a better feature to use?

View 7 Replies View Related

Queries :: How To Trigger By Date To Create A New Entry In Database Based On Old Entry

Aug 6, 2014

I have a database that makes use of standing orders. That means that if a client has a standing order to receive products during for example 4 time as year (quartely at the end of the month). to automate the new entry by copying an old entry in the database.

Let's say I have a client where we will have to send a product at the end of June, it will look at a field where the next send date is, and when it reaches 2 weeks for that date, to create a new entry in the database based on that entry. This way, it will pop-up in our open cases and we are aware of it and also will be visible in our report.

View 1 Replies View Related

Forms :: Combo Box To Verify With Last Entry And Display Other Options Than Last Entry

Sep 8, 2013

I am working on creating an access database for tracking physical assets linked to locations. I need to make a combo box list to show items other than the current location of the asset. Basically I need it to refer to last enery of the user and define the new possible entries. so we have a unique relationship between location and asset. The assets and location will always remain fixed and there is never going to be any addition. I am creating a web form so that it can be uploaded into sharepoint.

View 3 Replies View Related

Only Allow One Entry.

Sep 24, 2007

Hi there, I'm fairly new to access. I hope you can help me.

I have an update query that creates an entry for my stock and the date. This runs every time I run access. I only want one entry per day though :confused:
At the moment, every time I run access another entry gets appended.

Thanks for your time,
Robin

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

Searching An Entry With VBA

May 12, 2006

Hello, I'm trying to search an entry of a recordset with VBA

The entry can only be found by searching 3 field values. In my case the correct entry can only be found if the data in the field Date, No_Employe and No_Project all match the data of the entry I want.

Findnext doesn't work, it only access one field and I need three.
Seek doesn't work since it need to search a key, and neither Date, No_Employe or No_Project are keys.

How can I proceed ?

Should I use multiples Findnext ( how do I do that ? ) ?


EDIT :

Also please note that I'm searching for 400-500 entries in a row, so speed is an issue.

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

New Entry In Table

Nov 23, 2004

I have an input box that gets a string from the user. I want to put that string in a table. How would I do that?

View 4 Replies View Related

Most Recent Entry

Aug 11, 2005

I have a table called Tests that contains 80+ tests that need to be performed on our system. A second table is Test_Data. It contains the test results. I need a query that will pull the most recent test data for each test in the Tests table. So supposing there are 83 tests, I should only get 83 results from my query. I am will need to join the tables as I need to get some of the descriptive information from the Tests table. Another problem I have is some tests have not been performed even once, so not every item in the Tests table has a corresponding entry in the Test_Data table.

Any thoughts on how to do this?

View 4 Replies View Related

Wildcard Entry

Aug 17, 2005

Hi,

Im having a little problem with the following code in one of my queries

Expr1: IIf(IsNull([Forms]![editLookForm]![Company_Name]),True,[Company Name]=[Forms]![editLookForm]![Company_Name])

What this does is, it take an typed entry from the form (editlookform) and seaches for that entry in the query

i want to add wildcard entrys to this so that the person operating doesnt have to know the complete company name - i just dont know where to put them

Help please

View 2 Replies View Related

Not Go To Next Screen Without Entry

Oct 6, 2005

i am editing the user interface for operators.

here is the issue:
operators are entering data but sometimes forget to put the part serial number. they then go to the entry.

this is what i want to do:
the operator will not be able to go the next screen (complete the entry) unless they enter the part serial number. where and what should i enter that will prevent the issue?

much thanks.

View 10 Replies View Related

Sort By Last Entry

Feb 3, 2006

Hello,

Is there any way to sort a query by last entry? Unfortunately, this would be the only solution to a design error. Thanks much.

Pat

View 1 Replies View Related

Sort By Last Entry

Feb 3, 2006

Is there any way to sort a query by last entry? Unfortunately, this would be the only solution to a design error.

View 5 Replies View Related

Retrieving The Very Last Entry

Nov 5, 2006

Hello All,

Is there a way to retrieve the very last entry to a table (via a query) without passing a value to the query.

Lets say I have a table Pets

ID desc
==============
1 Dog
2 Cat
3 Lizard

For example lizard was added last, is there a way I could pull just this out using a query? (keep in mind that I don't know wahat the last entry is, so I cannot pass any kind of value to the query)

Cheers,
Aaron

View 2 Replies View Related

Check If Their Is A New Entry

Jan 24, 2005

Hi..

I have a form with a subform where the user has to enter some data in them. when the user moves to the subform the data in the form automatically get saved in the table(you all know that i suppose).
In the form i have a back button where the user is able to go back to the main form.the code of the button is:


If MsgBox("Do you want to save before exit?", vbYesNo, "Save") = vbYes Then
DoCmd.RunCommand acCmdSave
MsgBox ("Data has been saved.")
DoCmd.Close
DoCmd.OpenForm "Main"
Else
DoCmd.RunCommand acCmdDeleteRecord
DoCmd.Close
DoCmd.OpenForm "Main"
End If
Else
DoCmd.Close
DoCmd.OpenForm "Main"
End If


my problem is when the user hasn't entered any data and wants to return i would get an error (because i'm trying to delete a record which doesn't exist
) how can i check if a record has been eneterd.
if new entry then
deleterecord,close,open mainform
else
close,open main form
endif

thankxx in advance..
hope my grammer is correct

View 3 Replies View Related

Repeat Last Entry

Aug 2, 2005

Hi,

I would like to know what code I need to populate a field with the last record information - similar to the Ctrl apostophe.

I can upload the database in question if required.

Thank you

View 11 Replies View Related

Help.. Entry Form

Mar 5, 2006

I have a data entry form and some records in it. What will I do so the entry form and records will not be edited when viewed?

View 2 Replies View Related

Message If No Entry?

Apr 30, 2006

I tried using a message box to try and validate text entry on a form into a bound txt box 'PaymentAmount', If there is no payment entered, using the properties box Validation Rule ,- 'is not null' then entered a validation text ="Please enter an Amount" but this does not work. How can I get a message box to appear if someone leaves the entry field empty so that they have to make some entry to move on. I have already entered this in the table validation field as well as 'Required - yes', but the message is an Access one not my own. Where or how do I do this ?

View 14 Replies View Related







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