Search results

Hey Thanks for that I want to populate a data sheet alrite but i thought i had it properly formed. This query operates on a table that is created earlier in the query and I would like to keep it all in that function so ideally i am looking to create a query object with the statement and then do...

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...

Wow Thanks Guys I didnt expect this much thought to be put into the answer! Much appreciated!

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...