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...

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...

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

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...

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...

Hello, i have managed to get my form button to open another form to a specific record but this doesnt always work, i have used to wizard in access to do it some times it works other nots. could any body help at all. i believe it could be a problem with my relationships. i have deleted them al...

Hello, in my memership system everything uses forms for ease. in the main view of the student record, you have the option to delete the member. how every some of the information is linked to another table, how would i go about deleting this information as well, when the button is pressed. Aaron

Hello, i am creating a database for a membership of my martial arts academy, so far i can add and search members. i would like to have a mail merge feature on this, so that i have a list of all the people with a check box next to their name, if the box is ticked their name is added to the...