Otvaranje forme uz uslov
Pozdrav svima,
Source forme je crosstab query, i treba da se otvori u datasheet pogledu uz uslov da je jedino određeni user moze otvoriti.U event-u sam postavio kod:
---
Private Sub Form_Open(Cancel As Integer)
Dim stDocName As String
stDocName = "PREKOVREMENI_Crosstab_mesecno"
If UserName = "draganil" Then
DoCmd.OpenForm stDocName, acPreview
Else
DoCmd.Close acForm, stDocName, acSaveYes
End If
End Sub
---
Prilikom otvaranja forme javlja se "run-time error 2174, You can't switch to a different view at this time" . Sa pogledom Single form radi ali nece ako u properties-u postavim datasheet. Googlao sam ali nista!
Neka ideja!
 |  |
 |
