Last Minute Changes

[debo33]

All:

I'm trying to complete my database and have a few last minute questions. Here are my questions:

1. Can the tabs on a form be set to automatically bounce to the next field?How?

2. When adding a new record using "Address" form (ID, Last Name, etc.), can a secord form, (Training), open with the press of a button automatically displaying ID and Last Name? (sample code would be useful)

3. One form (Address) and 1 subform (Training) both with unique ID in common. When adding a new record, it appears only in the Address form&table. The new record shows up on the Training subformbut NOT in the Training table. I did set Child/Parent link to ID. Can anyone help me?

4. Even though I have a security system (login/userid screen) with 2 levels of access (Read Only & global view). How can I prevent any user besides me (the owner) from seeing the tables and queries or any code which the database runs off of?

Thank you in advance, examples and sample code are great because I'm a beginner. "The coffee is on me"!

Debo

 

[Autoeng]

4. Make your app an MDE

 

[debo33]

MDE???

 

[Autoeng]

From Access Help...

About MDE files
If your database contains Microsoft Visual Basic code, saving your Microsoft Access database as an MDE compiles all modules, removes all editable source code, and compacts the destination database. Your Visual Basic code will continue to run, but it cannot be viewed or edited, and the size of your Access database will be reduced due to the removal of the code. Additionally, memory usage is optimized, which will improve performance.

Saving your Access database as an MDE file prevents the following actions:

Viewing, modifying, or creating forms, reports, or modules in Design view.


Adding, deleting, or changing references to object libraries or databases.


Changing code using the properties or methods of the Microsoft Access or VBA Object models — an MDE file contains no source code.


Importing or exporting forms, reports, or modules. However, tables, queries, data access pages, and macros can be imported from or exported to non-MDE databases. Any tables, queries, data access pages, or macros in an MDE file can be imported into another Access database, but no forms, reports, or modules can be imported into another Access database.