Search results

  1. V

    Hi

    Hi everyone, Could you please help with one issue. I have 2 forms: timesheet and basesalary with fields: BasesalaryForm 1. Full Name 2. D/M 3. BaseSalary 4. Month 5. Year 6. WorkDays timesheet 1. Full Name 2. Month 3. Year 4. WorkDays when I fill "basesalary" I try to write function...
    • Vugar
    • Thread
    • Replies: 2
    • Forum: Forms
  2. V

    Copy to table

    Hi everyone, I take information from many tables by query and I try to copy data to linked (SP) table. I copied by Append Query. One problem that append query duplicate data. Do you know how set rule that query not copy duplicate, copy only new data. thank you
  3. V

    Hi

    Hi everyone, Could you please help with one issue. Can I connect my DB with SharePoint list. So when I will add any information to my DB it was copied to list in SharePoint. Thank you in advance.
  4. V

    Hi everyone

    I try to create Salary DB and have one problem. please see below: FullName D/M BaseSalary BaseDay WorkDays Salary XX D 500,00 20 22 YY M 500,00 1 15 I want writh formula: 1. If ("D/M" ="D") then...
  5. V

    Hi

    Hi everyone, Could you please help with one issue: I have a database Time Sheet DB. weekly staff send their Time Sheets (Access file) data and import them unto my Time Sheet DB. how to do it so that the data is automatically loaded? thank you very much
  6. V

    Hi

    Hi everyone, could you please tell can I write sum rule that when I close some form, the other forms that opened will refresh data automatically Thank you
    • Vugar
    • Thread
    • Replies: 2
    • Forum: Forms
  7. V

    Validation rule on VBA

    HI, How I can write it "<=Nz(DLookUp("[SumOfQuantity]","[TotalInStock]"," ItemID = " & [ItemID] & "And [Status ID] = " & [Status ID]),0)" on VBA. thanks
  8. V

    Filed equal if

    Hi, I have 2 field: Status and Project. Can I set default value for Status 1. if Project is blank status = purchase 2. if Project is not blank status = return thank you
  9. V

    Password for DB

    Hi everyone, Can I create a rule no one could see the tables, queries except me. Thank you
  10. V

    Validation rule in Form

    Hi, I have "Outgoing" form in StockDB. in "Outgoing" Form in "Quantity" field I set validation rule:<=Nz(DLookUp("[SumOfQuantity]","[TotalInStock]"," ItemID = " & [ItemID] & "And [Status ID] = " & [Status ID]),0) and when I did not fill out "StatusId" there is an error (see attached). Can I...
    • Vugar
    • Thread
    • Replies: 1
    • Forum: Forms
  11. V

    Can't open Form1 if Form2 is open

    Hi everyone, I have 2 Forms: Outgoing and Incoming. Can I make a rule that if "Incoming" is open so I can't open "Outgoing"? and it possible to set msg box: You must closed "Incoming"? thank you
    • Vugar
    • Thread
    • Replies: 7
    • Forum: Forms
  12. V

    Columnar form: new record when open form

    I created Columnar form. how can I set a rule that when I will open the form automatic show line for new input, because when I open form I see first record every time. Thank you
    • Vugar
    • Thread
    • Replies: 1
    • Forum: Forms
  13. V

    Validation rule

    hi everyone, I have two main tables of incoming and outgoing. I have crate stock Query with following fields ItemID (Group By) , StatusID (Group By), Quantity (Sum) And In Outgoing Form ItemID, StatusID, ReceivedQuantity Now the problem is , I dont want the user to fill itemID and StatusID...
  14. V

    Stock DB

    Hi All, I'm trying to create sample Stock DB for small business. Now the problem is , I can't connect Incoming with Outgoing. Because when I create Query it doesn't work. Could you please give your idea, thanks in advanced.
  15. V

    Validation rule

    hi everyone, I'm new in access and trying to create Stock DB. I have two main tables of incoming and outgoing. I have crate stock Query with following fields ItemID (Group By) , StatusID (Group By), Quantity (Sum) And In Outgoing Form ItemID, StatusID, ReceivedQuantity Now the problem is ...
  16. V

    Hello

    Hello everyone :)
Back
Top Bottom