Help with database pleasee

[mmm455]

Hi,
On the database I have created I am having trouble creating a calculation.
I want a field on a page to calculate the two fields before it. How do i do this?
I want Price of a lesson x number of lessons = total cost

Also, I cant get the current date to appear in one of the fields on my form. Please will you help me with this aswell

 

[asanjose]

To create a text box with the current date, type
=now()
in the control source of the text box.

 

[Khalid_Afridi]

You can create an unbound control on the page and name it TotalCost, then in the data source of the control just write:

=Sum([lesson]*[number of lessons])

 

[mmm455]

thank youu

Also, how do i get it so that on my database, when i enter a name in the first forename box, the rest of their information appears without me having to type it in??

 

[Khalid_Afridi]

sorry about the double post. i thought the first one didn't go thru because it hanged. how can i delete that?

Go to Edit (bottom right of the post) open it in Edit mode and delete

 

[Khalid_Afridi]

use combo box to lookup for your data and find the record you want to search for.

 

[mmm455]

thank you

Might need some more help in abit

 

[mmm455]

how do i get it so that on my date field, the little calender icon appears so i can chose a date?

 

[Khalid_Afridi]

how do i get it so that on my date field, the little calender icon appears so i can chose a date?

If you are using Access-2007 with a date field, then it would appear automatically on the form once it is highlighted.

 

[mmm455]

ok thanks for the help... its been great. let u know if i need more help

 

[mmm455]

how do i get buttons of a main menu page to link to other forms within the database?
and how do i get buttons on forms, such as exit and back to link to the required pages?

 

[Khalid_Afridi]

how do i get buttons of a main menu page to link to other forms within the database?
and how do i get buttons on forms, such as exit and back to link to the required pages?

create button on the form and follow the instruction wizards such as:
Form Operations:
Close Form
Open Form
.....
.....
Refresh Form Data.

I would suggest you to go for
http://www.access-programmers.co.uk/learning2/tutorial.htm
http://www.learnaccessnow.com/