General database questions

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have a few questions regarding Access 2000:

1) How do you change the cursor tab order on the form? (For example, Field
#2 tabs to field #1 and then #3, #4, so on. I want to correct that)

2) For a home inventory database, how do I insert the item photo for each
record, rather than the filename you click to see the photo?

3) How do I tell the database to auto open to form entry, and auto-maximize?

============================
- Dave
http://members.cox.net/grundage/
 
Answers in-line below.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Dave said:
I have a few questions regarding Access 2000:

1) How do you change the cursor tab order on the form? (For example, Field
#2 tabs to field #1 and then #3, #4, so on. I want to correct that)
Click to expand...

Look at View | Tab Order in the menu bar when the form's open in Design mode
2) For a home inventory database, how do I insert the item photo for each
record, rather than the filename you click to see the photo?
Click to expand...


I wouldn't recommend it. Access is tends to bloat excessively when you
insert images into the database. Tale a look at
http://www.mvps.org/access/forms/frm0030.htm and
http://www.mvps.org/access/forms/frm0044.htm at "The Access Web"
3) How do I tell the database to auto open to form entry, and
Click to expand...
auto-maximize?

When the database window is active, look at Tools | Startup on the menu bar.
That will let you open a specific form when the database opens. To have it
maximize, put the statement DoCmd.Maximize in the form's OnLoad event.
 
I have a few questions regarding Access 2000:

1) How do you change the cursor tab order on the form? (For example, Field
#2 tabs to field #1 and then #3, #4, so on. I want to correct that)
Click to expand...

Right mouseclick the little square at the upper left of the Form in
design view and select "Tab Order". You can use auto-order to order
the controls left to right, then top to bottom; and/or you can select
each control and move it up or down the list.

You can also select any control and change its Tab Order property.
This can be a bit confusing because all the other controls will
renumber when you do do - the tab order numbers run from 1 to the
nubmer of controls on the form, so if you change a control's Tab Order
from 23 to 2, all but one will move up one.
2) For a home inventory database, how do I insert the item photo for each
record, rather than the filename you click to see the photo?
Click to expand...

It's best NOT to do so - Access is *terribly* inefficient at storing
image data.
3) How do I tell the database to auto open to form entry, and auto-maximize?
Click to expand...

Use Tools... Startup to select which form you want to auto open; in
the Form's Open event click the ... icon, choose the Code Builder, and
edit it to something like

Private Sub Form_Open(Cancel as Integer)
DoCmd.Maximize ' maximize this and all forms
DoCmd.GoToRecord acNewRecord ' go to the data entry new record
End Sub
 
Back
Top