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 (tblLotteryDetail) 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_LotteryNumber Ending_LotteryNumber
Please note that the beginning_LotteryNumber is the yesterday's
Ending_lotteryNumber 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!
5  1550 
On 15 Mar 2005 11:39:36 -0800, al***********@yahoo.com wrote: 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 (tblLotteryDetail) 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_LotteryNumber Ending_LotteryNumber
Please note that the beginning_LotteryNumber is the yesterday's
Ending_lotteryNumber and it should be populated.
Are you sure that today's Beginning_LotteryNumber is yesterday's
Ending_LotteryNumber? Doesn't sound right to me.
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.
You need a sub-form.
mike
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!
On 15 Mar 2005 13:57:42 -0800, al***********@yahoo.com wrote: 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.
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
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.
On 16 Mar 2005 09:43:35 -0800, al***********@yahoo.com wrote: 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.
You still need a sub-form.
mike This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: SuryaPrakash Patel via SQLMonster.com |
last post by:
Dear All,
How to reach to the highest level of normalization for database designing?
Guide Lines Needed.
What will be the characteristics of a database of a completely normalized databae?
...
|
by: Aaron |
last post by:
Complete code follows.
I am new to .NET programming (and programming in general) and I am having a
difficult time understanding how to fill a variable in one sub, and then
access it from...
|
by: slonocode |
last post by:
I'm wondering if there are certain processes that I could follow to
learn to design better classes? Where could I find these processes?
Is designing classes more of an art that comes from...
|
by: John |
last post by:
Hi,
I can't find a simple example for a simple(?) problem.
I am working on an application with a variable in form1, that variable
is needed in form2 for a calculation but i can't get that...
|
by: UniSoft |
last post by:
Hello,
I have created one form in vb.net 2005 and i need its printout on A4 size
paper, but its leave some space on top and bottom, i have also tried to
increased the size of that perticular...
| | |
by: puttypapyrus |
last post by:
I am having trouble designing the tables and establishing relationships
for a survey database for the purpose of evaluating speakers for a
variety of events. After every event, the attendants are...
|
by: Mohammad Hashemian |
last post by:
Hello
In writing an application I should design an options form like the MS
Office Options form. this form has too many controls in some tab pages.
the problem is when I add these controls to the...
|
by: sap0321 |
last post by:
This should be kindergarten stuff but for some reason I am having trouble with it. I do 99.9% web programming and this is the first windows app i've done in years - probably the first ever in C# ......
|
by: Twayne |
last post by:
Hi,
If ever a newbie wants to know how much he has to learn yet, he only has
to look here<g>!! ANYway:
PHP 5.2.5; XP Pro SP2+, local Apache Server
My actual question is: How do I get a...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
