Designing variable Form Help Needed

[alwayshouston@yahoo.com]

Hi All,
I am designing an application in MS Access for a grocery store to store
daily report information. I am stuck in implementation of Lottery
sales for the store. I have stored the lottery information in two
tables. First table (tblLottery) consists of lottery ID, Name,
EffectiveDate, and Price and second table (tblLotteryDeta il) consists
of SalesID, EndingNumber. I would like to create a form in which it
will look at the tblLottery table and create the text boxes for each
valid lottery for a specific day (report date) and also populate
yesterday's information in another text box for each lottery ID. Let
me clarify it by giving you the sample output for the form as below:

Lottery ID Beginning_Lotte ryNumber Ending_LotteryN umber

Please note that the beginning_Lotte ryNumber is the yesterday's
Ending_lotteryN umber and it should be populated.
If the above situation is not clear, please refer me to how to create
dynamic form based on a table. For e.g., lets say I have five types of
lottery on 1/1/2005. For 1/1/2005 daily report, the form should
populate five text boxes for each lottery. For 2/1/2005, I have six
lottery types. Therefore, the form for that day should populate six
lottery type.

Thanks!

[Mike Preston]

Re: Designing variable Form Help Needed

On 15 Mar 2005 11:39:36 -0800, alwayshouston@y ahoo.com wrote:
[color=blue]
>Hi All,
>I am designing an application in MS Access for a grocery store to store
>daily report information. I am stuck in implementation of Lottery
>sales for the store. I have stored the lottery information in two
>tables. First table (tblLottery) consists of lottery ID, Name,
>EffectiveDat e, and Price and second table (tblLotteryDeta il) consists
>of SalesID, EndingNumber. I would like to create a form in which it
>will look at the tblLottery table and create the text boxes for each
>valid lottery for a specific day (report date) and also populate
>yesterday's information in another text box for each lottery ID. Let
>me clarify it by giving you the sample output for the form as below:
>
>Lottery ID Beginning_Lotte ryNumber Ending_LotteryN umber
>
>Please note that the beginning_Lotte ryNumber is the yesterday's
>Ending_lottery Number and it should be populated.[/color]

Are you sure that today's Beginning_Lotte ryNumber is yesterday's
Ending_LotteryN umber? Doesn't sound right to me.
[color=blue]
>If the above situation is not clear, please refer me to how to create
>dynamic form based on a table. For e.g., lets say I have five types of
>lottery on 1/1/2005. For 1/1/2005 daily report, the form should
>populate five text boxes for each lottery. For 2/1/2005, I have six
>lottery types. Therefore, the form for that day should populate six
>lottery type.[/color]

You need a sub-form.

mike

[alwayshouston@yahoo.com]

Re: Designing variable Form Help Needed

Yes, the beginning Lottery Number is yesterday's Ending Lottery number.
Let me explain this. Lets say that "Lottery1" start number is 100
for 3/15/2005 and it sold 60 tickets for 3/15/2005. The ending lottery
number for Lottery1 for 3/15/2005 is going to be 160. But for 3/16/2005
the beginning lottery number is going to be 160. I hope this clarifies
my question.
Thank you very much for your quick response!

[Mike Preston]

Re: Designing variable Form Help Needed

On 15 Mar 2005 13:57:42 -0800, alwayshouston@y ahoo.com wrote:
[color=blue]
>Yes, the beginning Lottery Number is yesterday's Ending Lottery number.
> Let me explain this. Lets say that "Lottery1" start number is 100
>for 3/15/2005 and it sold 60 tickets for 3/15/2005. The ending lottery
>number for Lottery1 for 3/15/2005 is going to be 160. But for 3/16/2005
>the beginning lottery number is going to be 160. I hope this clarifies
>my question.[/color]

I still think you are confused. ;-)

If the Lottery1 start number is 100 and you sell 60 tickets, the
ending lottery number for Lottery 1 for 3/15/2005 is going to be 159.

But a subform would make this all clear, whether you can count or you
can't, because the computer CAN count.

mike

[alwayshouston@yahoo.com]

Re: Designing variable Form Help Needed

I am still confused? Perhaps :o)
If the lottery on HAND start number is 100 and lottery on had end
number is 160. How many tickets you have sold? You have sold 60
tickets (100, 101,102,...159) . Perhaps, I am confusing you with my
description. Regardless, how can you design a form that will allow you
to have different lottery types for a day and include beginning lottery
number and let the user type ending lottery number? For e.g, there
are three lottery types valid for the day and I would like to show
three lottery types on the form with beginning number from the table.

[Mike Preston]

Re: Designing variable Form Help Needed

On 16 Mar 2005 09:43:35 -0800, alwayshouston@y ahoo.com wrote:
[color=blue]
>I am still confused? Perhaps :o)
>If the lottery on HAND start number is 100 and lottery on had end
>number is 160. How many tickets you have sold? You have sold 60
>tickets (100, 101,102,...159) . Perhaps, I am confusing you with my
>description. Regardless, how can you design a form that will allow you
>to have different lottery types for a day and include beginning lottery
>number and let the user type ending lottery number? For e.g, there
>are three lottery types valid for the day and I would like to show
>three lottery types on the form with beginning number from the table.[/color]

You still need a sub-form.

mike