Search results

Yes, now I can clearly see the route the JOIN goes, what I don't understant why it first starts from tblTipDokumentacije if my main table for holding records is tblZahtev?

Can someone explain to me this complex JOIN: FROM tblTipDokumentacije INNER JOIN ((tblMesto INNER JOIN tblPorodica ON tblMesto.txtPTTBr = tblPorodica.txtPTTBr) INNER JOIN (tblMestaPohadjanja INNER JOIN (tblDete INNER JOIN tblZahtev ON tblDete.txtSifraDetetaID = tblZahtev.txtSifraDetetaID) ON...

I have this query: SELECT tblDete.txtSifraDetetaID, tblDete.txtMBDeteta, tblDete.txtIme, tblDete.txtSrednjeIme, tblDete.txtPrezime, tblDete.dteDatumRodjenja, tblDete.txtMestoPohID, tblMestaPohadjanja.txtNazivMesta, tblDete.bolDrugoDete, tblDete.bolTreceDete, tblDete.bolCetvrtoDete...

What do You mean by short example (just tables. qryZahtev, and frmZahtev)? My database is .accdb, which format should I send? While I'm waiting for this answer here's a SQL code for qryZahtev for You to analyze: SELECT tblZahtev.intZahtevID, tblZahtev.dteDatumZahteva, tblZahtev.txtBrUgovora...

I have a form and since I change it's record source from table to query (with same data as the table and some more) I'm getting this error: The error occurs when I try to select records from the third of mine three combo boxes I have on that form, and only when I'm on the blank (new) record...

I'm trying to recreate this form: The closest I've come to it is this: I've set all the form properties on mine form as on the form I'm copying. I've tried deleting controls in the upper part of mine form but as I'm deleting them they are removing themselves from the datasheet. How do I...

Yep, that did the trick, thanks ;) One more question regarding this: If I set Data Entry property to Yes should I turn off the Allow Additions property (I've turned off Allow Edits and Allow Editions properties)? Thanks

At the moment it is only used to add record and it is open from the first form only.

I've looked at this event as You suggested. No, I was trying to add a record to second table from second form, and the combo box on the first form displays those records and lets user selects them (not all of them, lets say that combo holds name of user). Now, when I solved my first problem...

Thanks that requery methd works :D Where would You put Me.cboName.Requery code, in the first forms On Load event or in the second forms On Unload event? I've put it in the seconds form On Unload event and it works, but I'm asking just for reference. Let me ask You this. I've successfully passed...

Nope I didn't knew that :D I tried the method without closing and reopening forms and with that method I have the problem that now I need to requery the first form and return on the record I was when I was on the first form. I need to requery beacuse on the first form I have a combo box which...

Can i pass a variable from forms Class module into second forms class module, and can someone explain how? Thank You

So You suggest that I don't close the first form when opening the second, but to open the second in dialog mode whilst the first remains open, and when I close the second I will remain on the same records? If this is what You're suggesting is there I way to do this but with closing and...

I've noticed that If I open the form from VBA with the accFormAdd property the form it opens on the new blank record and from there I can add as many records as I want but it doesn't return to the previous added records. I don't think I've locked the database, how do I do that, and why would I...

How do I create this effect: 1) Open the main form which has a button to open another form 2) When the main form opens remember on which record I was on the main form 3) Open another form from main form and t that point main form closes (I've created this with VBA code) 4) Add new record to...

I've created button on my main form which will will open another form where I will add a record and then move back to main form. I want to do this when the add record form opens: 1) Always Open blank record; 2) Not be able to move trough records of the forms data source; 3) Only be able to ADD...

[SOLVED] Finding in which Recordset range is entered value I've solved my problem but not with the DLookup function but with recordset. The problem was in pair of ' ' I've used while I should have used " ". For the Nth time the MsgBox function solved the problem here. I still wonder though whie...

Is there a way to identify which controls sub procedure triggered forms before update event from within the forms before update event? Thank You

I've tried this DLookup code: dblVrednostSkale = DLookup("[dblVrednost]", "tblSkala", "[dblVrednostOd] >= " & dblPoClanu & " And [dblVrednostDo] <= " & dblPoClanu) And, I assume because my double value was for example 13333,33, I was getting "comma, SQL syntax error". Is my suspicion about this...

Nope, this won't do. My real problem with the code I've written is that the Me.Recalc command triggers the form's before update event (asking me do I want to save) which I do but not at that point. Now I will put entire code here for the three events, but first here's the picture of the controls...