Prev: Positioning a form on the screen
Next: Option for fields to show up in datasheet view
From: Krykota on 22 Dec 2009 00:00
In Access 2007. I have table that records sales. I have a form that allows
for entry of last year's numbers one week at a time. I have a second form
that IS SUPPOSED to allow for entry of the current year's numbers when they
happen for that same week. The forms are supposed to populate the same
record in the same table (Last year's numbers are already present).

When I test, I end up with two records with the same date, but one has last
year's numbers and the other record has this year's numbers. I need both
numbers in one record. When I try to base the second form on the query that
displays the current week's numbers, I cannot enter data. When I base the
second form on the table, I cannot bring up the previously entered data for
that date unless I click through the records.

I would like to use the calendar control to select the date and be the
criteria to locate the record so that the user can update the record with the
current year information. Any ideas on how to do this?

TIA
From: Tom van Stiphout on 22 Dec 2009 09:25
On Mon, 21 Dec 2009 21:00:01 -0800, Krykota
<Krykota(a)discussions.microsoft.com> wrote:

Let's start at the beginning. It sounds like you have this table:
tblSales
Weeknumber integer PK
LastYearsSales currency
ThisYearsSales currency

That would be a violation of an important relational database design
rule that says "no repeating groups". Change that first, then see how
you fare.
tblSales
YearNumber integer PK
WeekNumber integer PK
SalesAmount currency

-Tom.
Microsoft Access MVP


>In Access 2007. I have table that records sales. I have a form that allows
>for entry of last year's numbers one week at a time. I have a second form
>that IS SUPPOSED to allow for entry of the current year's numbers when they
>happen for that same week. The forms are supposed to populate the same
>record in the same table (Last year's numbers are already present).
>
>When I test, I end up with two records with the same date, but one has last
>year's numbers and the other record has this year's numbers. I need both
>numbers in one record. When I try to base the second form on the query that
>displays the current week's numbers, I cannot enter data. When I base the
>second form on the table, I cannot bring up the previously entered data for
>that date unless I click through the records.
>
>I would like to use the calendar control to select the date and be the
>criteria to locate the record so that the user can update the record with the
>current year information. Any ideas on how to do this?
>
>TIA
 | 
Pages: 1
Prev: Positioning a form on the screen
Next: Option for fields to show up in datasheet view