Recent content by hullstorage

  1. H

    Working with order numbers both in and out for multiple items - new project

    please see above there are a few examples and also what the stock is its basically just booking in part in and out with no costs, suppliers etc..just for our records what comes in and when sent out but muliple parts against 1 ref no in and same as going out
  2. H

    Relationship or Table problem, where am i going wrong ?

    I've managed that bit before it's the actual sending out So I create a box of mixed screws to send some where Box of screws has a shipment no And screws in the box can be Su1 Su4 Su6 So rma on this part doesn't exist really
  3. H

    Relationship or Table problem, where am i going wrong ?

    Every single screw will have an su number but the box they come in will have an rma number. If I got 2 boxes of screws then there would be 2 rma numbers but every screw needs a su number Rma 1 box of screws no 1 with 3 screws Su1 Su2 Su3 Rma 2 box of screws no 2 with 4 screws Su4 Su5 Su6 Su7 😊😊
  4. H

    Relationship or Table problem, where am i going wrong ?

    Ah right yea I will re do this. The su number is like a licence plate for the part and we have a roll of stickers for these that we attach to all the parts out of the box and is very important as it seperates the parts so to speak as all the parts in the box could be same part number and not...
  5. H

    Relationship or Table problem, where am i going wrong ?

    It's getting there but when i scan SU out it doesnt populate the part fields etc. ive attached if you could have a look please lol I have attached database now and also a pdf that maybe explains it better hopefully lol
  6. H

    Working with order numbers both in and out for multiple items - new project

    here is were i am at, the goods in works fine and it is now just when we are sending the parts out as getting duplicate error ? we need the same as goods in for goods out but when we scan the su number this then pulls data in from the goods inward for part number and serial...ive tried...
  7. H

    Relationship or Table problem, where am i going wrong ?

    Hi all, I have attached a sample copy of database as trying to get back in to access again and a bit rusty ! Can someone help with this, i am sure its simple but i am missing something and if you could explain lol So if you look at goods inward this is fine ! The problem is i am trying to...
  8. H

    Working with order numbers both in and out for multiple items - new project

    sorry i maybe should have mentioned but wanted to keep as simple as possible actually there are no invoices or charges involved and stock simply gets delivered and collected all stock is owned by another company and we simply store and ship for them. all these are is for our records only
  9. H

    Working with order numbers both in and out for multiple items - new project

    Hi all, I will keep this as simple as i can so not to confuse anyone i hope lol I am trying to create a database to log all stock items coming in and going out to and from carriers or couriers as currently this is all done manually. When goods come in this can be 1 item or 20 items and they...
  10. H

    get results for previous 3 months VAT reasons

    Hi all, I have a query and report that shows invoices with invoice date obviously ? My accountant wants data from the last 3 months records ? March,April and May invoices and next time June, July and August i want the criteria so code will simply show the last from months only and...
  11. H

    matching 2 item codes from 2 tables ??

    Access 2010 Hi all, We have a list of unique numbers on our database and then someone comes to do audit with what should be the same as ours so looking for a way that when we import their list it looks at ours and shows any queries for missing or extra items ? The code is the unique number...
  12. H

    Help and advise on simple stock in and out database

    Hi all, I am creating a simple database to keep records of stock movements. We have parts that come in and out of our warehouse all which will be scanned at time of movement. I am thing I will need a few tables and relationships for this and this is the main advise that I will be...
  13. H

    how do i change first characters on a text field ?

    Hi all, I have a form with a field called PartNumber these are entered from a barcode scanner by scanning barcodes on a box. My problem is this: When we scan a part number the barcodes actual part numbers are shown like this: PN321-ab55 but the actual part number we use is 321-ab55...
  14. H

    Question Looking for simple orders database that i can build learn from ??

    Hi all, Looking for download of something like attached picture to learn and build on? Thanks for reply ? Simon
  15. H

    How do i show picture on report if control is true ??

    How do you do this ?? thanks
Top Bottom