Jobs & Education1 min ago
Access 2007 help needed
5 Answers
Hello, I am relatively new to the programme and I need to set up a database as part of my course. I need to implement forms to search then edit records. Does anyone know of the best way to go about doing this? I have created a form to search but the query results display in a datasheet. I would like the query results to display in a form where they can be opened up in a further edit screen. Is this possible and if so what is the best way or is there an altogether easier way? I would very much appreciate any help at all and thanks for taking the time to read this!
Answers
Best Answer
No best answer has yet been selected by casarose. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Most Microsoft product contain a tutorial. Have a look on the Help menu or search the help to see if there is a tutorial.
Or search the web for Access Tutorial, there are loads around.
You sound as though you need to start from basics and it would be difficult to explain what to do if you have litle knowledge of Access.
Here is one example of what you can find online
http://databases.about.com/od/tutorials/ss/cre ateaccessdb.htm
Or search the web for Access Tutorial, there are loads around.
You sound as though you need to start from basics and it would be difficult to explain what to do if you have litle knowledge of Access.
Here is one example of what you can find online
http://databases.about.com/od/tutorials/ss/cre ateaccessdb.htm
When I started programming in Access, I got a lot of ideas from the Allen Browne site
http://allenbrowne.com/tips.html
http://allenbrowne.com/tips.html
If you have a continuous list form (one that displays data for each record one after the other on a scrolling screen), you might use the wizard to create a button at the bottom of the screen and set it to open an edit form. This form will display a record for editing if you double click on a field within a displayed record on the continuous list then click the edit button you created. Hope that's clear.
Apologies, I have re-read your question and it seems you only want to display data in a form and be allowed to edit this. If so, go to the Forms section of Objects and click on New on thye toolbar above. Select Design View and then select the table or query which you want to use then OK. You will see a blank form and the field list of the table/query. Either select individual fields by dragging and dropping from the list to the form, or select all by double clicking the title at the top of the list and dragging the lot over. This will allow editing of the form on display. Navigate through records using arrows at the bottom of the screen. This is a very basic form but can be used as a base for more advanced forms.