Search results

spikepl - I don't understand. So I need to convert number to string If I want to use variable in SQL Code, when my number from variable has decimal? I think something is wrong with it, conversion from number to string isn't efficient.

namliam - maybe, but why? value of "liczbaarkuszy1" is result of count with MS Access

pr2-eugin - the same problem

I wrote one line above. that is translated from my language - error message

syntax error in query expression (comma) '[Odpad]=20,833333333333333'.

My code is Dim strSQL As String Dim recIn As Recordset dim liczbaarkuszy1 as double strSQL = "SELECT [Odpad], [LiczbaUzytkow], [ProcentZcalosci] FROM [TblRozklad] WHERE [Odpad]=" & liczbaarkuszy1 & " ORDER BY [Odpad] DESC;" Set recIn = CurrentDb.OpenRecordset(strSQL) While Not recIn.EOF...

dim liczbaarkuszy_1 as double liczbaarkuszy1 = DMax("LiczbaArkuszy", "tblRozklad") strSQL = "SELECT [Odpad], [LiczbaUzytkow], [ProcentZcalosci] FROM [TblRozklad] WHERE [Odpad]=" & liczbaarkuszy1 & " ORDER BY [Odpad] DESC;" e.g. liczbaarkuszy1 = 20,833333333333333

There is some error in where clause, but I don't know what is wrong strSQL = "SELECT [Odpad], [LiczbaUzytkow], [ProcentZcalosci] FROM [TblRozklad] WHERE [Odpad]=" & liczbaarkuszy1 & " ORDER BY [Odpad] DESC;"

I don't know why but I can't check my code in editor vba. Please see screenshot. Button "Run" is inactive.

I have Calc from Open Office, but it's very simple in Excel e.g. GCD(a1:a100)

"...of two or more integers..." What about e.g. 12; 4; 2 in this above code?. The Greatest common divisior is 2 in this example

It works for 2 numbers

it isn't vba code, this is function in MS Excel "GCD"

How to find Greatest common divisor in MS Access? Have a 2 columns in my form: 1) amount; 2) GCD E.G amount | GCD 1200 500 400 100 Should be after runing code amount | GCD 1200 | 12 500 | 5 400 |...

Is it possible? OFC without "+" Now I have something like this in double click event in one of my field If Me.SubdatasheetExpanded = False Then Me.SubdatasheetExpanded = True Else Me.SubdatasheetExpanded = False End If But this code expand all of my items:/

How to declarate variable to working with in a form, subform and subform2 Form-->subform--->subform2 I tried to Public ... Private... Dim.... and always variable working only in Form. I don't want to declarate variable in a separate Module.

Ok, now it's fine. You were right about the names of controls

1) Yes, I have a datasheet view 2) I replaced it 3) I refering it correctly

Both don't work. AD 1) Ms Access error - Metod or data member not found On load in main form: Me.SubForm!controlname.ColumnHidden = True AD 2) Ms Access error On load in main form: Me.SubForm.Form.controlname.ColumnHidden = True

In open Mainform event Forms!Mainform.Form!SubForm!controlname.columnhidden = false doesn't work. Ms Access can't find "subform" On load and open events in subform doesn't work with columnhidden. (no reaction)