Recent content by gmworrall

Thanks for the translation namliam! There's no other code involved - just a linked CSV file and the table design. The duplicates will come up against data already appended to the table - 'SalesRecordSKU' is Indexed (No Duplicates). It does detect them, comes up the key duplication error, then...

Bit of an odd one... - I have a module which runs queries on linked sales spreadsheets, to merge them in to one Access table. - To prevent duplication of sales, the primary key merges the sales record and item number fields. Today, it's found 103 key duplication errors, which is fine. But it's...

Just realised something else which might be important: One of the linked tables is NOT in the backend database, but links to a CSV file. It also has the 'opened exclusively' error when I try to open it. The rest of the 'normal' tables are fine. Are linked CSV's known to cause issues in...

Front-end. Back-end just has the tables.

pbaldy, sorry forgot to reply! Thanks for the link. Managed to get it doing what I wanted. :)

I have a multi-user database. I've split it into a front-end and back-end. Distributed copies of the front end to each user. Thought I was sorted... However if I try to open, in any view, a query that somebody else is using, it comes up with the 'Opened exclusively by another user' error. Any...

I've tried using the search but besides it not being possible the 'easy' way, I can't find anything specific to my function. I *think* it'll be some sort of subquery, but I'm only just getting used to writing SQL by hand so still need a little guidance... I need the minimum cost, grouped by...

SPOT ON! Easy to follow example and a great solution. Thankyou. :)

I'll get that table set up! :) Quantities are very likely to always be the same - I think they share a database. However, in that instance I'd take the higher value.

They operate separately. We have different contacts and get a different feed from each. For everything apart from this part, it works for us to keep them separate. It might be better to think of them as different suppliers who share stock.

I have many suppliers for many products. I want to get a total quantity for each product (stock from all suppliers). This bit is pretty simple! The problem is, two of the suppliers are actually the same. In the below example, it's A and B. There isn't duplication for every product, they sell...

Thanks Plog! You're right. I guess I'd been looking at it so long that I needed someone to tell me that it's nothing complicated, for me to realise it was something simple (data type mismatch)....

Pat, the problem is the inventory is from an external CSV file, which doesn't have OUR ProductID. So I have: tblPRODUCTS ----1-2-M---- tblINVENTORY ----1-2-1---- CSV (external) tblINVENTORY needs to relate to the external CSV to pull in quantity, cost etc. But the problem is, only a...

Sure! Basically need to join Stock and StockFEED into one set of data, but can't guarantee a unique field. But a combination of two (SKU and SupplierID) WILL be unique. Products PID Title 1 ProductA 2 ProductB Stock SID PID SKU SupplierID A 1 SKU1 SupplierX B 1 SKU1...

A 1-to-1 relationship based on two fields. Hear me out... tbl_Products has a one-to-many relationship with tbl_Stock. Each product can have many suppliers. tbl_Stock has a one-to-one relationship with an external feed (which I have no control over), containing cost, quantity etc. There are no...