Search results

No in both tables it's a long

I have "order by" in a form: nz([kolejnosc], 9999]) - to have null field a the end not at the top. kolejnosc it's a long field. form based on query (union all) If I have records with (1,2,3,4,5,6,7,8,9) everything is ok but when I have "10" number then my sequence is (1,10,2,3,4,5,6,7,8,9)...

I have a query with "order by LP asc" (lp is a number) but the problem is when the lp is null (has no value) then these rows are on top. What should I do to have rows with no value at the bottom?

Another PC can locked record, I woudl like to check it before runnig my code. I know problem when the other user it's me but it not apply to this situation

Is there any possibilities to check before Currentdb.execute or editing record in recordset, whether record is locked by another user?

what do you mean?

Yes I have an index on id_zlecenia. If field is indexed then we should use recordset because it's faster than vba like dcount....am I right? About recordset maybe instead of .recordcount there is some faster way to find out that there is some records or not? it's faster using recordset 2...

Yes I see you do it exactly what i made. But I try to understand logic of sql and recordset. This is only a part from my code. I need to use information about duplicates later. So there isn't fastest way (time when computer doing code) to check these information about duplicates than write...

I want to know if there are duplicate records tblGoraZleceniaZakonczone.nazwa in tblGoraZleceniaZakonczone where tblGoraZleceniaZakonczone.id_zlecenia = idStarego tblGoraZleceniaZakonczone.nazwa - text field tblGoraZleceniaZakonczone.id_zlecenia - text field idStarego - string variable So i...

I need to check, is some duplicated records or not (by column which is text) in my table before do my code. so I wrote the query which is working fine but slow:/ - that's the problem. Is there any fastest way to check that what my query do? strSQL = "Select count(nazwa) " & _ "from...

Ok I will try to made more readable:). Your syntax is wrong too:/

I want to use it in dao.recordset so I need it in one string:/. In clean sql it works, sqlString doesn't:/

What is wrong with syntax of this query:/? strsql = "Select id_poprzednie, kopiamontazu, kopiaplikow from tblPoprzednieZlecenia where id_poprzednie = select max(id_poprzednie) from tblPoprzednieZlecenia where id_tblOffset=" & Forms!frmZlecenieMarzena!Id_tblOffset & ")& " id_tblOffset is a long...

Ok guys, the problem was Nz(Me.Nazwa_id, 0) because it's a combie field:)

Yes but when write a clean sql then must be ";" but If we have string in vba then without ";". So debug.print shows me Insert into tblGoraZleceniaNowa (Naklad_pracy, IloscStron, KoloryP, KoloryT, FormatX, FormatY, id_zlecenia, nazwa_id) values (200, 2, 'c;m;y;k', 'c;m;y;k', 5, 4, '1055/14', 3)...

Could You show me what should I write to see problem in immediate window? In string ";"? I never heard of that

How to check it? Some procedure with debug.print?

It's syntax error

I always have problem with the end of the string what is wrong in this string? strSQL = "Insert into tblGoraZleceniaNowa (Naklad_pracy, IloscStron, KoloryP, KoloryT, FormatX, FormatY, id_zlecenia, nazwa_id) values (" & Nz(Me.Naklad_pracy, "") & ", " & Nz(Me.IloscStron, "") & ", '" &...

I want to write a query string from a query: SELECT * FROM tblZmiany WHERE datazmiany = #25-11-2015# or (datazmiany > #25-11-2015# and (datazmiany = #26-11-2015# or datazmiany < #26-11-2015#)); but #25-11-2015# = zakresPoczatkowy #26-11-2015# = zakresKoncowy So I tried to write it but doesn't...