Search results

I would like to do replication database via button using VBA (ADO connection string). how could I do that? I tried to work with linked tables, but I have many calculations so it takes a few seconds. So I thought, can work with local tables and 1-2 times a day replicate database to another...

I would like to remove the comma, but only one that is at the end of my string(there is a space after the comma, should be also removed) How should I do that in vba?

IT WORKS!!!! THX namliam:)

Ok so 1) Please Open SampleOk, then open form "frmWycenyObszarRoboczy" then open query "Query2" - see results? Please navigate to record number 2 and refresh "Query2". That's what I need to achieve in one string to work with Recordset. 2) Open WRONGSample, then open form...

Ok, give me 20min to create a sample :)

I mean. Query looking for in ALL RECORDS in my table some replications for [NumerArkusza]. For every row in my form where [id_wycena_pre] = 123 - wrong Query should looking for replications [NumerArkusza] in my table but ONLY WHERE [id_wycena_pre] = 123 for every row in my form where...

Yes separate queries work. But I need one to work with recordset

It doesn't work. Query shows result for Forms!frmWycenyObszarroboczy!ID_wycena_pre - and it's ok. BUT count replications from all table "tblGoraZleceniaNowaWyceny" so as a result in my example I have two rows for [id_wycena_pre] = 68. First row [NumerArkusza] = 1 and second [NumerArkusza] = 2...

Is it possible to do combination of these two queries? SELECT * FROM tblGoraZleceniaNowaWyceny WHERE [id_wycena_pre] = Forms!frmWycenyObszarroboczy!ID_wycena_pre[/CODE] and SELECT [Query1].[NumerArkusza], [Query1].[nazwa], [Query1].[id_wycena_pre] FROM Query1 WHERE...

yes, always when I'm using this code, ID_wycena_pre control is populated e.g. id_wycena_pre = 68

I have everything in one line in my strSQL:p, yes I created it and checked it in query wizard before I post about my problem. I think the problem is, related qeury "ReplikacjeDoSprPopDanych" from my strSQL , because when I replace ReplikacjeDoSprPopDanych to tblGoraZleceniaNowaWyceny - table...

Right, Ofc should be *, but still get an error "Too few parameters, expected 1" ReplikacjeDoSprDanych: SELECT * FROM tblGoraZleceniaNowaWyceny WHERE [id_wycena_pre]=Forms!frmWycenyObszarroboczy!ID_wycena_pre; strSQL = "SELECT [ReplikacjeDoSprPopDanych].[NumerArkusza]...

Yes, but the problem is, I want to use this query to work with recordset, so I can't refer to another query in my string, right? ReplikacjeDoSprDanych: SELECT numerarkusza FROM tblGoraZleceniaNowaWyceny WHERE [id_wycena_pre]=Forms!frmWycenyObszarroboczy!ID_wycena_pre; strSQL = "SELECT...

Exactly! e.g. my query now shows two records 1) - 1 2) - 2 shows only two because [id_wycena_pre]=Forms!frmWycenyObszarroboczy!ID_wycena_pre BUT, the problem is that, query count replications from all table but I want to count replcations only from this area of my table where...

Have some query and would like to write a code which count and shows only records where [tblGoraZleceniaNowaWyceny].[NumerArkusza] are the same. how could i do that? Below query COUNT the same [numerarkusza] from all table, not where [id_wycena_pre]=Forms!frmWycenyObszarroboczy!ID_wycena_pre...

hmm No it's not necessary. There's no way to have something like this (c762c). But now I see another problem. Forgot to say about that, (Sorry!). If in string will be "Pant." then function also should be true. Is it possible to achieve it? String like asd;xga;Pant. jas;ueq

As usual, perfectly. THX!

Have a strings like this dsa;hwq;67;dk;71c uqiea;762c;iyh Is there any possibilites to write a function which find number in string, even if some part (between ";" and ";") has number and text (like 762c)? if there is number in string then function is true

Thx, your link solved my problem.

1) If I check recordcount without move rst to last position I get wrong number of recordcount. rst = CurrentDb.OpenRecordset(strSQL) msgbox nz(rst.RecordCount, 0) 2) If I move rst to last position, number of recordcount is correct, but! If there's no record in my string I get an error that rst...