Recent content by basilyos

  1. B

    save data from main form and subform

    big thanks to your reply and of course i will use it as it's desired to be used
  2. B

    FIFO

    hello am working on sales inventory database for my own business and i want to add the FIFO concept to my products because the cost will differ from time to time or i will change the supplier do you have any example so i can learn and achieve my goal
  3. B

    save data from main form and subform

    what can i do to let the user save the data in both tables just by pressing save and choosing yes and if choose to close or pressing no after pressing save the data in both tables will not be saved and also i want to prevent the invoice id to increase if the user choose not to save
  4. B

    save data from main form and subform

    hello am trying to create a sales app for my business i want to save data from the main form to a specific table and the data from the subform to another table and for each row in the subform i want to add the invoice id that is existed in themain form here a copy of my database the form am...
  5. B

    Solved Counting Checkboxes with True Value

    Ohhh am really an idiot 🤦‍♂️🤦‍♂️🤦‍♂️ I typed the name of the name of the control not the control source Am really sorry and thanks
  6. B

    Solved Counting Checkboxes with True Value

    Hey Guys this is a mini copy of my database just one table and the form where am facing the problem thanks in advance
  7. B

    Solved Counting Checkboxes with True Value

    the chk_Gift is visible and yes it's part of the record source
  8. B

    Solved Counting Checkboxes with True Value

    i already putting the codes in a textbox in the form footer but the three codes return #error
  9. B

    Solved Counting Checkboxes with True Value

    when i run the form am getting just #error
  10. B

    Solved Counting Checkboxes with True Value

    hello i have 4 checkboxes in continuous form i want to get the sum of each checkbox with true value in an unbound texbox i tried these codes =Sum(IIf(Nz([chk_Gift];False); 1; 0)) =-Sum([chk_Gift]) =Abs(Sum([chk_Gift])) but always am getting error any help please
  11. B

    save and update data from access table to google sheet to use it with telegram bot

    hello i want to save my clients data to google sheet so can my users fetch their data through telegram bot could you lead me to how to start or where to start
  12. B

    same code for 48 textbox

    i uploaded a sample my database
  13. B

    same code for 48 textbox

    here is a copy of my database
  14. B

    same code for 48 textbox

    the textboxes in unbound the txt_01 ..... txt_48 just contain the ID the name is in another textbox name txt_01_name ... txt_48_name how to declare getinvoice in your solution?? i put this code in new module Public Function GetInvoice(ID as Long) as String If DCount("*"...
  15. B

    same code for 48 textbox

    thank you sir but do you a link so i can understand more about the parameters and textboxes
Back
Top Bottom