Search results

  1. A

    populate a subform with data searched and selected from listbox

    before use of append query, i was on this code which were working partially. and giving me docmd.gotorecord , , acnewrec error. i giveup it, may be the append query is best way but if there is no error 'Me.Purchase_Data_Subform.SetFocus 'Me.Purchase_Data_Subform!ProductID.SetFocus...
  2. A

    populate a subform with data searched and selected from listbox

    i am facing this problem, how can i fix it i am using this macro behind add button click
  3. A

    populate a subform with data searched and selected from listbox

    dear all, i have this purchase form with subform, when i search data from listbox, its temporary stores both two fields in temporary text box on right sides, and opon click on add button, both two values added in subform. but problem is when i try to add another product, it shows error that...
  4. A

    Update stock table after purchase save button

    i will create database will one user/order taker my question is still there, how it is possible to add new row in stock table, with specific field value based on purchase order data table
  5. A

    Update stock table after purchase save button

    Inventory is very "tight", as it is for medical store where we have to handle 4, 5k items.
  6. A

    Update stock table after purchase save button

    Dlookup function working ok, in result its getting my required value from another table. The main i need code in green, which i am strugling to make it correct, as i need to add new record in stock table with my specific data. Stock table will also be used in future for stock adjustments (stock...
  7. A

    Update stock table after purchase save button

    i am considring my stock table as transction table
  8. A

    Update stock table after purchase save button

    is it possible to put a 2nd subform of stock table on this form which is linked to purchase data. and after update of product id, add new recored in stock purchase qty field which value is equal to this purchase data subform qty field
  9. A

    Update stock table after purchase save button

    is this possible in this vba i am trying to update stock table purchase qty field, which may also create stock id field automatically. code is not good, i just want to describe my point
  10. A

    Update stock table after purchase save button

    first i was using a union query which get purchase data and sale data with (-) symbol, it gives me available qty correctly, but now i want to store in stock table, the purchased qty and sold qty everytime i bought and sold.
  11. A

    Update stock table after purchase save button

    it required sturcture like this, but can i have other options for my sturcture , my relationship pic is like this
  12. A

    Update stock table after purchase save button

    Hi dears What is the best method to update stock table. I have Purchase form with purchase data form. I want when we press save button on purchase main form, it will add a new record in tblstock, where tblstock.productid = tblpurchaseData.productid, and...
  13. A

    creating multiple copies of sales order forms

    Thanks for this demo
  14. A

    creating multiple copies of sales order forms

    with the above mentioned method of allenbrowne.com? or in some other way
  15. A

    creating multiple copies of sales order forms

    i thinks using unbound controls and forms with some codes in vba, may be it is possible
  16. A

    creating multiple copies of sales order forms

    will these codes do as i want, i need, let suppose one customer come for order, user is making its order, in while this order has to be hold for some minuts for some reasons, can we open another window (or windows) of same order sales form(with subform and all its functions) to make a new order...
  17. A

    creating multiple copies of sales order forms

    yes, i mean multiple instances, thanks
  18. A

    creating multiple copies of sales order forms

    dear all, i want to create multiple copies of sales order form with its subform, as like in we create new page in word by pressing Ctrl+N(new) key, or in excell we get new workbook, i hope, i describe my point correctly
  19. A

    Order Form Saving Behavior

    master record is saving first on my default values. but i want to unsave/undo if subform is null
  20. A

    Order Form Saving Behavior

    Dears, My order form have order details subform. When i open the order form, i set customer bydefault value so it can generate new order id automatically, (because i want that before entering the customer name, user firstly enter products in order details, then user can change customer name)...
Back
Top Bottom