Hello,
We operate a food concession as a fund raiser once a year for a benefit.
I wish to have the cashier at the food concession check customres out with a form screen that contains each food item ( Hamburger), a left and right arrow button for incrementing and decrementing the number...
A table is being filled from a form.
At the bottom of the form is the record line showing 1 of 10 records.
The form is closed and then reopened later.
This time the record line is showing 1 of 1 records and you can't scroll to previous records. The table continues to be built from this...
Hi,
You have been a big help and I thank you very much.
If you would like to consider this other matter - -then here it is as well.
In that main horse form again is the control Horse and Owner.
The format in the table representing these fields has format set to >.
So no matter what...
Hi again.
Well, I think we have it solved.
The end result is - - -
You have left the cursor in the third table data field in the subform -
When you then reach up onto the main form and tell the form to advance to the next record...the next horse entry.
But here on the Main Form on...
Hi and thank you for your reply.
I will clarify a bit here.
We have the Main Form with its controls. It is a form entry and controlled by tabbing from one field to the other. Upon the entry into the last control ( a text box) I then tab again and the tabbing order continues into the...
A set of records in a subform is actually a subset of records that relate to the current record in the main form..
Be sure you have the following relationship established as follows - -
The Main form is collecting data to a main table.
The subform is collecting data to a sub table.
You...
Hi,
I have a mainform for registering data about a horse entering a show. The horse can enter many class events. After the horse data is entered in the main form, the tab control moves into the subform where the class entries for this horse are posted.
Let's say you enter the first class...
There has been a bit of discussion regarding the following --
A text field on my main form must be tested that it has not been left blank. If it was, then a msgbox must be displayed notifying this fact, and returning the focus to this control. Here is my solution.
On my main form is a...
Hello everyone.
My first name is Bob and I am a bit new to Access 2003 but learning fast.
As a community service project to my Kiwanis Club, I created a database to register horses and riders for our annual Horse Show. First I had to read up on the Access 2003 Bible as not knowing a stitch...