Recent content by LjushaMisha

Dear LarryE, I have tried to make relations, but the only way was to make table for each LEVEL but I didn't find it "user friendly". That's why I have in "tblSestav" two fields (Ses_Nivo and Ses_Nadrejen_Id) - they actually work as connection between two tables. "Ses_Nivo" could be also called...

I know how to make Main form, it's subform, how to reference subform controls but I DON'T KNOW HOW TO MAKE 5, maybe 6 or maybe even 10 subforms (depending how many levels are needed for one product) in one main form. Or maybe it would be possible, as at the end each subform is only ONE control...

Because I don't know how to do it

Dear June7, sorry not answering you in time but I added my last post around 1:00 AM. Then I went to sleep. But meanwhile I did a database named "Instances_SampleDb.accdb", attached to my reply. When you open it Pls read "AAAtblReadme". Instructions for usage: 1. OPEN FORM "Frm_KOSOVNICA_Find"...

No, I haven't seen it. I have problems oppening his "solutions" Hwnd I already tried. But I thought it is integer. And I referenced it as such. In your example you threat it as string (between quotes). And you also typed solution of my even bigger problem: how to get Hwnd from the form. Your...

Yes. It is about Mr.Browne.Sorry. No, sample db couldn't be opened.I only copied and paste some code and make it work for me. REGARDING CODE: Above code doesn't have any sense. My final goal is to write sql string with where condition like WHERE SesId = " & Kloni(i)!SesId Like drilling deeper...

Hope it is better. I see colours are NOK

Function Klon_frmRezultat_Funkcija_01() Dim frm As Form Dim obj As Object Dim i As Integer Dim j As Integer ' Function ShraniSesId Debug.Print "1. " & Format(ShraniSesId, "000000") 'Result 000025, correct ' Open NEW...

which language should I choose? SQL is not what you'll like I think.:oops:

This is final code, with all original names in my language: str = "SELECT tblSifrant.* " & _ "FROM tblSifrant " & _ "WHERE (((tblSifrant.SesIme) Like '*" & Forms!frmVstop!Dummy & "*') " & _ "AND ((Exists (Select SesIme from tblSestav " & _ "WHERE tblSestav.Sesid =...

I have a continuous form named "frmRezultati" (i.e. frmResults) with one of the controls named "SesId". DblClick of this control opens INSTANCE of "frmRezultati". Idea is to change recordset of new "instance" form, dependig on value in the control which was doubleclicked. I don't have a...

Tried. Worked. Marked as SOLVED I used Exists instead

exclude some records from query

FOUND SOLUTION. Of course I have also txtSearchDummy control in same form. I have noticed that while typing "space" this space is "registered" in ...Dummy control. So I inserted another line of code after Else line: Me.txtSearch = Me.txtSearchDummy Now IT WORKS Now it is SOLVED Thx to...

instead of ISNull ... (which works) I tried YOUR solution. IT WORKS TOO. Great. Thx, have a nice day.