Search results

I have Access 2000 at home, and 2003 at work. I can still open my file at work, but the same file at home cant be opened. It keeps giving "microsoft access has encountered an error" etc.. send error report.. Any suggesstions? Thanks!

How would I make a query find a person like this: Inputted Data: Smit Outputted Data: Smith, Smithy etc.. The formula I have entered in the criteria of my query is: Like [Enter the person's last name] With this formula, if I type Smith, then the data that comes out is Smith. But if I type in...

In the screen shot, I calculated the total cost by multiplying cost per lesson by no. of lessons using the formula below: =[Number of lessons attended]*[Cost Per Lesson] What formula would I use to make the program add up all the total costs? so in this case 265+378. and then display it at the...

how would I make my reports show up on seperate pages? I would like a seperate page for each StudentID, and when I click the next arrow on the bottom left screen (see screenshot), it would go to the next page. Thanks! http://img352.imageshack.us/img352/2300/rptsinglepagepf4.jpg

how would I add a button to increase/decrease the value of my field "nmuber of lessons attended"? Thanks!

So basically I click the search students button (circled red), and the window pops out fine and lets me searches the students. Okay i searched for the student and its a success. The problem is, 2 windows appear now, the original main menu form where I clicked search students, and now the...

Any reason why some of the queries do not display the info correctly? as in the many to 1 or 1 to many relationships etc.. its just blank lines. How would I fix it (if nessicary) Thanks.

I have been using access 2003 at my work place. When I bring back my access 2003 project from work back home, i open the project at home, I am using access 2002 or 2000 format. Then I notice if I save a copy of my work using access 2002, while initially using an access 2003 database, the file...

The data that is to be entered in the field "Rank", is either RK1, RK2 or RK3 How would I make the validation in a table make the user enter the format RK(Number), with only numbers from 1-3? Thanks!