[ draganil @ 09.04.2008. 07:31 ] @
| 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! |