Recent content by rainbows

  1. R

    Problem chart

    thank you as i am not good with charts i have tried for hours to do what was suggested in the last post but failed i have managed to do a chart but i would like also a percentage within each column if possible like the screen shot i posted early thank you steve
  2. R

    Problem chart

    HI , I am trying to create a chartin a report and not doing so well . at this time i type the data into excel and create a chart which is not really what i would like to do as the information is in access i have attached a sample of the database and a screen shot of what i woud like it...
  3. R

    Automactic Reminders

    yes you are correct of which i agree with. i was asked if it could be done so i thought i could try to do it on a copy of the database just incase the big boss asked
  4. R

    Automactic Reminders

    ok, 3 companies use this database , api, ppi, apic when the user selects the company they work for the employees in that company is shown when they select their name 2 things happen , it tells you how many action request you have outstanding that was assigned to you . if you close...
  5. R

    Automactic Reminders

    i have a from with many outstanding requests , see screen shot below and report also is sit possible to send a automatic reminder weekly to all the people with actions that are active assigned to them thanks steve
  6. R

    enlarge field with a click

    Gentlemen , i would like to thank you all so many different ways to do it . i am going to take a copy of my database and try them all just to try and learn how they all work amazing thank you steve
  7. R

    enlarge field with a click

    hi , i have a form with 4 "long text " fields so i dont have to enlarge the test boxes in my form is it possible to click on that field to see and write all the text for example Approved actions thanks steve
  8. R

    how to stop editing tables with split front end

    thank you. i will look at today steve
  9. R

    how to stop editing tables with split front end

    hi I have split my database but I can still edit text from the front end . I can hide the navigation bar not to show the tables etc but that can easy be undone how can I prevent anyone accessing the tables etc thanks steve
  10. R

    create inventory in Access

    Mabino79 can you post your database so we can see it?
  11. R

    create inventory in Access

    this is how I set mine up
  12. R

    create inventory in Access

    In my opinion You need supplier orders. you need goods inwards , which books in part shipments , reject parts by the QC Department , you need stores to book in the inspected parts in . you need sales that allocated the parts from inventory for that order. you can have allocated ( pending...
  13. R

    get the varilbe " strinput" into a query

    Pat , I was not /am not sure how to do the batch file and code etc . as I have never done anything lie that before . so do I need to put the master FE into folder say " C:\Users\steve\Documents\Action Requests\FE" create a shortcut to that FE then I am not sure where to put the code...
  14. R

    create inventory in Access

    arnelgp Can you tell me if That database takes care of 1. currency, depending where you buy from and exchange rates for all stock 2. if you update the costs will it only apply for orders /sales as from that date you changed things and will not alter costs on previous transactions steve
  15. R

    create inventory in Access

    Reserved will be deducted from the current stock only, later on it will be converted into Sale. this current stock does or does not include parts on order ?
Top Bottom