using application parts

[ntambomvu]

Hello Everyone.
I am working through a microsoft tutorial and am stuck at "adding an application part"
I have created a new application called "Junk.accdb" and have used "create" "templates"


"application parts" to generate a table called "contacts"
everything went fine to table is there in the nav. panel and it works. But "database tools"
"visual basic" doesnt show any code?/
How can I get to the code?
many thanks
Fred

[ranman256]

it may not have code. most forms can work with data sans code.
but also, occasionally the db will glitch and tell you it is going to erase all the code. and it does.

but to get to the VBE (visual basic environment, the code) press ALT-F11

you can also see the code by selecting the control in design view, see the properties, see the events.
the event will have EVENT PROCEDURE on the line.
click the ellipsis button at the far right of the line to see the code for THAT event.

[isladogs]

Tables are used to store data and do not contain code.
If all you have done so far is add a table then there will be no code.

Forms and reports can contain code as well as standard/class modules.

Of course, its also possible to use macros to run form/report events - either saved macros or embedded macros

[June7]

Code is not automatically created when objects are built.

There are 2 basic ways to program in Access: macros and VBA.

Macros can be saved, embedded, or associated with table (the last is called Data Macro).

VBA modules can be associated with forms or reports or can be independent.

I have used regular macro only once and never use embedded macros nor Data Macros.