Warning: filesize(): stat failed for uploads/topics/Primjer_6.rar in /home2/icentarb/public_html/icentar/print.php on line 203

Warning: Illegal string offset 'status' in /home2/icentarb/public_html/icentar/print.php on line 190

Warning: Illegal string offset 'status' in /home2/icentarb/public_html/icentar/print.php on line 190

Warning: Illegal string offset 'status' in /home2/icentarb/public_html/icentar/print.php on line 190
iCentar » Racunari i oprema » Programirannje i baze podataka » Access » Dvostruki link
pmiroslav 22.05.2013 13:07
Predmet:Dvostruki link

Već se sat vremena patim i neznam gdje griješim?
U formi TraziDokumentSub na text Box ID stavio sam kod koji bi trebao otvoriti drugu formu

Private Sub ID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmVraceno"
stLinkCriteria = "[ID]=" & "'" & Me![ID] & "' AND [Sifra] = " & "'" & Me![Sifra] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

Znači u formi trebam dobiri podatak koji ima izabrani id i izabranu šifru.
ID je broj, a šifra je tekst.

Stalno dobivam grešku 'Open form is canceled'
Prilozi:
Primjer.rar (Velicina datoteke: Bajt)

zxz 22.05.2013 13:31
Predmet:Re: Dvostruki link

Id je broj pa ne ide pod znake navoda.
Samo string ide pod znake navoda.
Private Sub ID_DblClick(Cancel As Integer)
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmVraceno"
stLinkCriteria = "[ID]=" & Me![ID] & " AND [Sifra] = " & "'" & Me![Sifra] & "'"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End Sub

pmiroslav 22.05.2013 13:43
Predmet:Re: Dvostruki link

Hvala, još jednom si me spasio muke. Ja se izgleda uvjek zabunim negdje u tim navodnicima.

zxz 22.05.2013 14:28
Predmet:Re: Dvostruki link

Po meni to je samo zamor i pad koncentracije.