DATASHEET VIEW IN ACCESS RUNTIME?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have created a data entry form for use on other machines
via Runtimes. My people are requesting to be able to view
this in a datasheet view as well because they have to be
able to look back at multiple records at one time. Does
anyone know if this can be done?

thanks,
Aaron
 
I usually bite the bullet, and make them a nice continues for form.

The look the same...but you can do so much more.

You can also add the following lines of code to the continues form, and the
arrow keys will then move just like the datasheet view.

The following example code also opens up a detail form when the user hits
enter:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)

' key hand

Select Case KeyCode

Case vbKeyUp
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acPrevious

Case vbKeyDown
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acNext

Case vbKeyReturn
If IsNull(Me.TBID) = False Then
KeyCode = 0
Call EditMain
End If

End Select

End Sub

Private Function EditMain()

On Error Resume Next
DoCmd.OpenForm "frmBook", acNormal, , "[id] = " & Me.ID

End Function

And, here is some screen shots of contihues forms in actiion:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm
 
Yes, the OpenForm action lets you open a form in any
allowed view. You need to put a button on a menu somewhere
to let them change back.

(david)
 
Back
Top