Recent content by AHMEDRASHED

  1. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    🙂 Thanks , i Deleted because it's have full customers and Suppliers info, and my Email and password .
  2. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    Apologies, English isn't my first language. Thank you for your patience and help
  3. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    Thank you @Pat Hartman did i got your point or still not and code still silly 🤕🫣! Private Sub btnfill_Click() Dim userNote As String Dim db As DAO.Database Dim rs As DAO.Recordset Dim sql As String Dim InvoiceNumbers As String Dim InvoiceIDList As String Dim...
  4. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    Sorry @Pat Hartman for delay replay How do you know an invoice was paid today? Examble Paid cash direct to my Boss 25 jul.24 ( its small company as personal company ) The Payment note just for him for dubel check . why not just add a button to update the record instead of selecting it? sorry...
  5. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    A heartfelt thank you to @arnelgp and @Gasman for your guidance and support! RecordsetClone Your advice improved my code significantly, allowing me to update all invoices in a second. I truly appreciate your expertise and willingness to share your knowledge. Thank you all for help...
  6. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    Thanks for your humble words and sharing your experience, @Gasman . Your advice on using meaningful names and comments for variables and controls is greatly appreciated. I agree that learning never stops, The knowledge and insights shared by you and other members have helped me . I'm grateful...
  7. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    I changed it to "chkPaid". @arnelgprealy, I tried working on it for about 3 hours yesterday but couldn't figure it out. You guys are so professional; when I come here I feel I'm baby in high school . still learning and have a lot to catch up on. Thank you for your comment and your help!
  8. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    Thank you so much I added a new button and used the code below. I'm not sure if it's the best approach, but it seems to work fine. I used this code because sometimes I need to make multiple invoices, for example, 50 invoices, and add a payment note, such as "Paid in cash on 24/07/2024," for...
  9. A

    Update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually

    Hello everyone, I need help with an issue . I want to update multiple filtered invoices as "paid" and add payment notes without opening each invoice individually. Currently, I have a search form (view only) and an invoice form with main forms and subforms. (payment notes in subform) Is there a...
  10. A

    Trouble Exporting Sorted Data from Access Form with Subforms to Excel

    Hello everyone, I'm encountering an issue when exporting data from a Microsoft Access form, which includes subforms, to an Excel file. Specifically, when I attempt to sort the data in the Access form (either ascending or descending) before exporting, the exported Excel file ends up containing...
  11. A

    Solved Can Grow and Shrink in continuous subform fileds automatically extend or shrink vertically based on the content.

    Hello everyone Can Grow and Shrink in continuous subform fields automatically extend or shrink vertically based on the content.
  12. A

    How i make remember password in form login on my pc only !

    i fixed it with below code : Thanks you all Private Sub userName_AfterUpdate() On Error Resume Next Dim db As Database Dim rst As Recordset Set db = CurrentDb() Set rst = db.OpenRecordset("Select * from tlogin where userID =" & userName) If rst!remember = True Then...
  13. A

    How i make remember password in form login on my pc only !

    Hello evreyone, How do I prevent other users in internal network To use my username and password if I saved the username and password in the tabel login as remember My UserName have full accsess , i dont need others user to see it . Note :- Database was shared internally in internal network...
  14. A

    Solved why when i change button icon or image in database : erorr message after that The expression may not result in the name of a macro,

    Thank you The_Doc_Man , its work fine now without any erorr
  15. A

    Solved why when i change button icon or image in database : erorr message after that The expression may not result in the name of a macro,

    its done , Sorry
See more
Back
Top Bottom