y won't access2004 show datasheet view even tho set in properties

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

Guest

i have repeatedly tried 2 get a particular form 2 show up as a datasheet both
manually and using a wizard. it consistently shows up as a regular form. i
have set the properties 2 datasheet view, etc. is this a bug in this version
of access 2003? or will it only do datasheet view as a subform rather than a
standalone form?
 
How are you opening the form?

Assuming you're using DoCmd.OpenForm, you need to pass acFormDS as the
second argument (View):

DoCmd.OpenForm "MyForm", acFormDS

When you don't, acNormal is assumed.
 
unfortunately, i have already done this as well. i keep getting an error msg
that asks me 2 debug.
 
Private Sub View_All_Company_Stores_Click()
On Error GoTo Err_View_All_Company_Stores_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "View All Company Stores"

stLinkCriteria = "[AccID]=" & "'" & Me![AcctID] & "'"
DoCmd.OpenForm , acFormDS, stDocName, , , stLinkCriteria

Exit_View_All_Company_Stores_Click:
Exit Sub

Err_View_All_Company_Stores_Click:
MsgBox Err.Description
Resume Exit_View_All_Company_Stores_Click

End Sub
 
If the name of your form is "View All Company Stores", that should be"

DoCmd.OpenForm stDocName, acFormDS , , stLinkCriteria


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


startingover0001 said:
Private Sub View_All_Company_Stores_Click()
On Error GoTo Err_View_All_Company_Stores_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "View All Company Stores"

stLinkCriteria = "[AccID]=" & "'" & Me![AcctID] & "'"
DoCmd.OpenForm , acFormDS, stDocName, , , stLinkCriteria

Exit_View_All_Company_Stores_Click:
Exit Sub

Err_View_All_Company_Stores_Click:
MsgBox Err.Description
Resume Exit_View_All_Company_Stores_Click

End Sub


Douglas J. Steele said:
What's the exact code you're using?
Click to expand...
Click to expand...
 
well i'll be darn....that's the wizard 4 ya and the tag help. it was saying
2 put it in the other order. thank u VERY much.

Douglas J. Steele said:
If the name of your form is "View All Company Stores", that should be"

DoCmd.OpenForm stDocName, acFormDS , , stLinkCriteria


--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


startingover0001 said:
Private Sub View_All_Company_Stores_Click()
On Error GoTo Err_View_All_Company_Stores_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "View All Company Stores"

stLinkCriteria = "[AccID]=" & "'" & Me![AcctID] & "'"
DoCmd.OpenForm , acFormDS, stDocName, , , stLinkCriteria

Exit_View_All_Company_Stores_Click:
Exit Sub

Err_View_All_Company_Stores_Click:
MsgBox Err.Description
Resume Exit_View_All_Company_Stores_Click

End Sub


Douglas J. Steele said:
What's the exact code you're using?

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)


message actually, the exact error msg says "argument not optional".

:

What's the error message?

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


in
message unfortunately, i have already done this as well. i keep getting an
error
msg
that asks me 2 debug.

:

How are you opening the form?

Assuming you're using DoCmd.OpenForm, you need to pass acFormDS as
the
second argument (View):

DoCmd.OpenForm "MyForm", acFormDS

When you don't, acNormal is assumed.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"startingover0001" <[email protected]>
wrote
in
message i have repeatedly tried 2 get a particular form 2 show up as a
datasheet
both
manually and using a wizard. it consistently shows up as a
regular
form.
i
have set the properties 2 datasheet view, etc. is this a bug in
this
version
of access 2003? or will it only do datasheet view as a subform
rather
than a
standalone form?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top