Search results

  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 ?
  16. R

    get the varilbe " strinput" into a query

    so just to confirm if I have 50 people who can input data , I will need 50 copies of the FE (ie one on each computer ) I did split a copy of the database and took 2 copies and could open the same form and work on both at the same time and it did update thanks steve
  17. R

    get the varilbe " strinput" into a query

    I was asked to create something if possible to record all our action requests for each company . The users have a company next to their name and a id number so when they select the company only the people in that company can log in . at this time the admin people are testing what I have done...
  18. R

    get the varilbe " strinput" into a query

    1 created at text box in my login form then put this code into my other code . put a text box into my issues for called up text34 and it was working ok . Me.Text34.Value = strInput however I found a error if someone is already in the form "issues list " as you will see ADMIN pw1...
  19. R

    get the varilbe " strinput" into a query

    this database is for 3 different companies . all owned by one person , each company will have an admin person to oversea reports, on time , late , and monitor the performance etc etc. when admin logs in it know to only bring up that companies information is company 1 ,2, or 3 the owner and...
  20. R

    get the varilbe " strinput" into a query

    Private Sub Command370_Click() Dim strInput As String Dim strMsg As String Beep strMsg = "Please Enter the password to allow access." strInput = InputBox(Prompt:=strMsg, Title:="Admin Password") If strInput = "CH1" Then 'MsgBox "Password accepted! Welcome! " & "Mike" 'password is correct...
Top Bottom