Search results

In this line Set rst = CurrentDb.OpenRecordset(strSQL) powtorzeniaDoKrojenia is a query SELECT First(tblImpozycjaSzczegoly.[SposobUlozenia]) AS SposobUlozenia, tblImpozycjaSzczegoly.[Naklad_skladki] AS Naklad_skladki, tblImpozycjaSzczegoly.[Gorka] AS Gorka...

I want to use Recordset to work with query but get the error "Run-time error '3061' too less parameters. Expected one" :/ Dim rst As Recordset Dim strSQL As String Dim krojenie As String strSQL = "SELECT * FROM powtorzeniaDoKrojenia" Set rst = CurrentDb.OpenRecordset(strSQL) Do While Not...

Because I don't know, how to do this with a query:p

Right THX Guys. I just want to say, that first version code of pr2-eugin working good. Thanks for insight!

Thank You very much, it really help me with my work, now it's much easier :):)

I want to find out that, that fields [kolory p] and [kolory t] in my table are filled or not. So I built the code: Private Sub Naklad_skladki_AfterUpdate() Dim rst As Recordset Dim strSQL As String Dim przod As Boolean Dim tyl As Boolean strSQL = "SELECT...

I have to create table about Paper, there are 3 things describe paper: 1)Name 2)Type 3)Grammage Should I keep all this things in three columns? Like Name of paper Type Grammage Arctic Slik coated 80g/m2 Or only one column? Like Paper Arctic Slik coated 80 g/m2

:D:D:D:D:D All this time I was checking the code. It works great! Could You help me automate the solution? I saw modules but things like cEngine and Array are too complicated for me to understand.

Yes I mean it but wrote something else :p Sorry.

In many-to-many relationship should be 3 tables. But in my case: 1)tblValuation 2)tblInvoice One Valuation could has one or many Invoices One Invoice could has one or many Valuatons How should I create relationships between these tables?

Ok, I prepared database.

Of course, I will prepare what you need + some examples. Give me time for tomorrow

Hello! Could you see my reply? http://www.access-programmers.co.uk/forums/showthread.php?p=1387389#post1387389 I would be glad

Hmm so You claim that, where the total error is the smallest, that woul be best scenario. Am I right? I've checked it on few examples and it is truth. But for coding I think it is the same problem as "The smallest possible number from among the largest". It would be great! Any solution what I...

Thank you for your insight sum of all my quantities is 650 not 850. So it doesn't work:/

Thank you for your advice. I only want to show the problem. Of course I can create form and write every combination, what I do manually, but It's not solution for my problem. In some cases the number of combinations is so large that you can not do that manually. So in this example I have a code...

I need to find best combination using Loop to count "NumerOfSheets" To achieve smallest possible number from among the largest. Taking into account additional blocks to allocate. My table before running code looks like ID Oder Quantity Blocks NumberOfSheets 1 A 350 2 2 B...

I have back-end on LINUX, is there any possibilities to automatic export data to *xml? e.g. every 5 min. Maybe some code in vba which can be connected to system timer? I don't know just asking.

Ok I will have access to PC for 5 hours

spikel - It's not simple as you think. How I can create query with determined value when in tbl i have "," but in sql should be ".". There are two different things for Ms Access. e.g. 0,3 <> 0.3 namliam - the code will be too complicated.