Search results

Hi FOlks I am trying to get access to return data to a data sheet when I run an sql select statement through vb. For some reason it wont work and says: "A RunSQL action requires and argument consiting ofan SQL statement." I have included the piece below SELECT VALID_ALTS_AND_REPLS.PART_NUMBER...

Hi folks I have what I reckon is a complex problem that I need to solve for my warehouse. We hold replacement parts for the machines we sell. Some parts can be subsititued for others, so where we possible we use these parts to simplify our warehousing. Every day we get a file with demand for...

Hi anyone! I have a table that tracks data for parts across different depots. Thus some depots might not have records for a part in a particular depot whilst others do on a given day. My table does not record a 0 value for parts in a dept that don't have a part on a given day, it simply does...

Hi First time poster!! I am working on a project for my job and am creating a database to manage our inventory of parts. We have several depots around Europe and several hundred parts in each. We receive a new excel file containing all part movements across all hubs each day. I am thinking of...