Search results

i have a search box which has a list of everyone, showing their 1st name and surname, with a txt box at hte top you can type any part of their name and i will display the results, when you either double click or press the view button it will display there record, but at the mo it is displaying...

nice thanks now for another prob... i have a search box which has a list of everyone, showing their 1st name and surname, with a txt box at hte top you can type any part of their name and i will display the results, when you either double click or press the view button it will display there...

Hello, i have an expiry date for my members and each year they need to renew it, so i would like to have a button that when clicked adds 1 year to the date. I currently have this query =DateAdd("yyyy",1,[Commenced Training]) as there membership will expire one year from their joining date...

ok i have them working, using subforms, for the grading section i think this i what you meant, in the attached file you can see that the grade and date will be displayed once the grade is selected from the combo box?? i can work out how to do that on the main form but not on a subform?

i deleted it as i fort i wwas being stupid then worked out i wasnt lol thanks for that i am gona try it out now... i think i have the emergency details working using a subform

i think they are... in the student table an autonumber to create the students ref number then in everyother table it is linked via that. attached is what i have which i most probs 99% WRONG #

basically all i have is member information for my TKD Academy so far i have 6 tables student infor membership infor rolling register emergency info grading info mandate info but most of this information will be on the same form, to me it doesnt matter where in a table it is stored as i will...

Hello all, in your oppinion which would you say was easiest to control through forms, more information per table, or more tables with less information in each? Thanks

hmmm i no this is in the rong place but its to do with the same thing. but on my main student form i currently have a button saying sales that takes me to the order form, what i would like is for that button to create a new order, and a combo box next to it to select the reference number for...

Thanks everyone for that... i finally went an bought a book Access 2003 Bible, that is helping me on my long journey. Thanks again, and i will probs b bk for more help in bout 10mins hahaha

thank you aleb i think i understand that i am going to give it a go now. the only thing i am not to sure on is the invoice number as it will be an auto number and every item will have a new number.... that how i was confused about grouping things via that. ps i just realised what you was on...

ok i think it may be because i have an autonumber as my sales id, but i would like it to do by reference numbers, which are created from the date+surname ie 20/1/2006Bannister, this views fine on the form but how do i get it to store in the database from there, so that i can get it to search via...

attached as the main report is the top half of the report which shows the top part of the invoice, and the file 2nd is the bottom half which only includes the payment details and footer. as you can probably tell i am a complete NooB i dont know what you mean by posting the SQL? how do i view...

Thanks for the reply Aleb but i am sorry i do not understand what you mean?

cool that is exactly what i want but how do i do it?

Hello, i have made an invoice from a order form, i would like everything that has been ordered at the same time to appear on the one invoice, where as at the moment each item appears on seperate pages. Many thanks to any help give on this topic Aaron ps the attachment shows what i have so far.

Hello, i am really struggling in access creating an order form and an invoice report. the attached example shows what i have so far. however for the order form what i would like to do is have a drop down menu at the top which will have a list of invoice reference number for that particular...

Many Thanks. Kraj.

Hello all, i am making a form to process ordering within my membership system, i would like to add what i believe is called a subform or table of somesort, which is all connected to the same table i am using, but i would like it to appear in hte table format so that i can add more than one...

i have updated my relationships but i cannot add the table martial arts information to it.. i have attached my relationships and the error message