Recent content by nat22

Hello everyone, I can not send database in attachment because in zip format is bigger then 300 MBy,I have loaded Offering devices Listbox from table Police.With arrow down I put selected record to Listbox Selected devices, then I define quantity and with CHOOSE Command button I put that record...

Hello everyone, This is code with which I choose records from one table and I put them to another table (OdabranaOprema), can I add code with which I can stop choosing the same record twice? I would like in that case have possibility to change the quantity of the record which is selected twice...

The problem is in my table which is in attachment, in first column I have records 32706 and 32707 x 2 because I have 2 indentical records with difereence in column Kategorija (5e or 6) so when I update table with 2 criterias I get 2 indetical records (I mean in column Kategorija, if I choose...

No, imagin situation: if the cmbOne=5e and cmbTwo=UTP open Form1, if the cmbOne=5e and cmbTwo=FTP open Form2, if the cmbOne=6 and cmbTwo=UTP open Form3 (I have 8 forms), I have tried with SubForm's RecordSource Selected based on criteria of Combo1 and Combo2 but I have problems with records...

Hello everyone, I have a problem with opening forms.I have situation with 8 forms (small ones!) which must be open based on values in ComboBox1 and ComboBox2. Can I do it with Select case (DoubleClick event), and how? THANK YOU IN ADVANCE,

Great John, this is solution for my problems,thank you very much, best regards, Damir

Hello, thaks for your advice, the name of my TextBox is Polica,so I have situation: Private Sub Polica_DblClick(Cancel As Integer) Dim strHyperlink As String strHyperlink = Me.Polica.Column(3) Application.FollowHyperlink strHyperlink, , True End Sub where I can define Hyperlink addresses for...

Hello , I have ListBox and I have put in ControlSource: SELECT HorizontalniDrzaciKabela.Referenca, HorizontalniDrzaciKabela.Opis, HorizontalniDrzaciKabela.Visina, HorizontalniDrzaciKabela.Napomena FROM HorizontalniDrzaciKabela WHERE (((HorizontalniDrzaciKabela.PickFlag)=False)); Can I make...

Ok, I have put this in third field of Query Result: [Kolicina]*[Visina] and it is ok, I have values in 3.column Result(Kolicina x Visina), now, how can I make summary of all values of 3. column (Result), with Sum? I have put in txtEverything, in ControlSource =sum[OdabranaOprema...

Hello, I have made with query wizard OdabranaOprema Query where I put 3 columns from table OdabranaOprema - Kolicina,Visina, Result.I am the new in access, tell me please where I can put formula Result:[Kolicina] * [Visina], in code? thanks

Hello everyone, I have table OdabranaOprema with 3 columns-Kolicina,Visina,Result.I would like to multiply Kolicina x Visina in 1. row and put result in Result column, than I want to do the same in the next row and so one.At the and I would like too put result of summary values from Result...

Hello everyone,I have solved the problem. On Form2 I have opened txtSomething2 and with expression builder I made: =[Forms]![frmForm1]![txtSomething2] it works!

No, something wrong!

Hello, I did not write anything, so, I have to write event like Private Sub Form2_OnOpen() Forms!Form1!txtSomething.SetFocus End Sub is this OK? Thanks

Hello, I have litle problem regarding SetFocus.I have 2 Forms - form1 and form 2.On form 1 I have txtSomething and when I open form2 I can not SetFocus on txtSomething.I have tried with Forms!Form1!txtSomething.SetFocus but something wrong,can someone help, thanks