Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

access examples

Sep 29, 2004 1:32AM PDT

where can i find a database example that includes editing and updating records? The northwind example which comes with access only displays records. It's s#!t!!

Discussion is locked

- Collapse -
Re: access examples
Sep 29, 2004 1:49AM PDT

Mike,

Are you sure?. It might depend on the version of Northwind. Mine (Access 95, Access 97) do have forms you can use to update. I've never looked at 2000 and higher. I use 2000 only to view databases from my students, and 2002 here at my work, but only for simple things I know already or can find in the help. But I find it hard to believe that they have made everything read-only.

Anyway:
Use the new form wizard to generate a form for any table that lets you edit existing records and add new ones. That's the default for a form. If you want anything else, you've got to use settings or open it read-only.

Based on a form created by the wizard, or starting with an empty form, you can add whatever you like to the form, be it buttons, pictures or the most complicated VBA-code you can imagine. But the default form suffices for basic editing and updating.

There might be a most instructive 'booklet' about writing MS Access applications on your Office CD. It's not copied to the hard disk by an install.
But my experience is that Access is hard to learn if you want to do more than just the basics and have no programming background.

Hope this helps.


Kees

- Collapse -
Re: access examples
Sep 29, 2004 3:08AM PDT

I found the following resource to be invaluable when just starting w/Access 97 - lots of links to other sources of help - Have fun programming.

http://www.mvps.org/access/

Don Erickson