Search results

@JDraw: your proposal is excellent; the problem is this location issue is part of a project called Inventory control in the general tab. This project is quite advanced but, as you certainly know, an inventory control app is a complex thing and should be handled by experienced people...

My advise is to use separate fields: eventualy, you will learn that the query feeding the location combo can merge the 3 fields. You will not have to type in all the locations!!! VBA can do a good deal of the job.

Here is what should be the proper version: Public Function rplc() Dim rst As Recordset Dim I As Long Dim str As String Set rst = CurrentDb.OpenRecordset("sqlTextes") With rst .MoveLast .MoveFirst For I = 1 To .RecordCount...

@Ilk machine truc post #6: your are right and I will edit my post now. Of course the goal was to leave the original file intact. And, very obviously, the transfer to XML is omitted.

If you get tired of trying, test this one: Public Function rplc() Dim rst As Recordset Dim I As Long Dim str As String Set rst = CurrentDb.OpenRecordset("sqlTextes") With rst .MoveLast .MoveFirst For I = 1 To .RecordCount...

@BagManX: very easy using VBA, not so using sql...

@AnDataBase: numerous thinks need to be clarified. How are the periods defined? How does valuation influences 'stock'? If the periods are defined, where is the problem? Is valuation depending on unit prices? How? If periods are defined, that's no problem.

Come on! It happens to every one (even me...).

Monseigneur Harper should admit that I submit a schema which was quite related to the basic issue. The polemic about composite keys was, I admit, very technical but necessary and DIRECTLY related to your issue. The treatment of payments was also DIRECTLY related to your issue. I may be a...

Attached is the final (!!!!) version of frmParts and frmPartsDisplay. Note that I use 2 queries in both case because I didn't yet found a way to do it with a single one (and very familiar with VBA, and quite lazy...). Multi-storage location is probably irrelevant to you project: so ignore it...

@Opus: you are obviously not familiar with DB creation...Here is a solution to your UoM: Products Product: autoPK ... Quantity: integer or single QuantityUnit: long, FK ... Weight: integer or single WeightUnit: long, FK ... Package: long, FK QuantityUnits QuantityUnit: auto, PK...

@CJ: You see when I wrote my reply, I was referring to things that occurred 30 years ago. After a good night of sleep, I remembered how we actually handled this issue - at the time we were selling HP250 (a 64K micro with 1MB floppies). HP is actually the true pioneer in desktop and micro...

@Speakers: not all A2013, only the one coming with Office 365. No automation, no Activex controls and report events are ignored... @Galaxiom: you raise an interesting point. SQL Server do optimize sql statements but I never read that this was also the case for Access: do you have a ref. on...

You see I am 65, retired from IT. I have used CDC Cyber downto Apple (what so ever). I admit to be picky: studied biochemistry, chemistry and 'informatique'. To me, terminology is very important: most of the posts start with an improperly formulated issue. My signature is a reference to...

@CJ: I don't understand your need for allocation. I learned the handling of payments in the early 80's at Graybec, a subsidiary of Graymont. At that time, we had a package linking payments to invoices. The chief accountant explained to me that a customer is actually refunding a debt not paying...

I don't want to get into that kind of s... Case closed.

Yes. But notice that you need a criteria to start the calculation. For any given part, that's the last StockTake. You will have to be more specific about what you don't understand. I just realized that I gave you a rather complex piece of code. Note that only Protective... has any value...

@Button: you refuse to admit that you are WRONG. Since legally, for any given supplier, invoice number MUST be unique where is the problem?

@Button: I think your not familiar with the reading of a DB schema. 1 - It is clear that any supplier can have many Invoices: at least here, in Québec, invoice numbers of a supplier must be unique (for obvious accounting reasons). 2 - A multi-tabbed form would use the supplier auto number AND...

I will repeat this, again and again, because people, especially in this forum, refuse to admit a basic fact: Access is not compiled, as never been and will never be. It's P-Code (pseudo code)!!! VBA lines are not always stored as text but sometimes are: that's when 'compilation' occurs. That's...