Making Access Database into stand - alone executable file

[Robert]

Hi,

Can someone explain what I need to do to go about this?
I can't seem to find help any where.

PS. As a second but unrelated issue, does any know how
to disable the tab key in a VB module?

Thanks.

Robert

 

[Wayne Morgan]

You need the Office Developer Edition. It has the runtime version of Access. If you want
something more than this, you would need to go to Visual Basic or Visual C.

The tab character is ASCII 9. If you set KeyPreview on a form to Yes, you can intercept
keystrokes sent to controls on the form. What are you trying to block? Placing the
following in the Form's KeyPress event will keep the tab from moving the cursor between
controls.

Private Sub Form_KeyPress(KeyAscii As Integer)
If KeyAscii = 9 Then
Screen.PreviousControl.SetFocus
End If
End Sub

However, if you're just wanting to prevent going to a different record after the last
control, take a look at the Tools|Options menu, Keyboard tab, Cursor stops at first/last
field checkbox.

 

[Cheryl Fischer]

Robert,

An Access application cannot be turned into a "stand-alone" executable. To
distribute an Access application to users who do not have Access installed
on their computers requires that you own and use the Developer's Edition of
whatever version of Access/Office that you own. Using the tools available
with Developer's Edition, you can create a royalty-free runtime application
which installs your database and all other files required to open/run (but
not make design changes to) an Access database on the computers of those
users.