Search results

  1. W

    form with 2 subform

    Good day, I am here again seeking help. But before I post here, I have tried many times but failed... What I am trying to accomplish is that the form TblPurchaseOrderNEW will have 2 subform same as the form TblPurchaseRequest with the same function... I have set the relationships but when I...
  2. W

    Access 2016 setfocus

    good day experts, I am here again seeking guidance.. I am planning to use key command combination in MACRO Builder in Access 2019. I can't seem to find any in google or in this forum... I am using Macro Builder and use gotocontrol to navigate my setfocus to another subform after pressing TAB...
  3. W

    listbox, multiselect, append selected to subform datasheet

    good day to all, I am here again seeking help on my DB.. Below is a code I found in the net and I modified it. The code work when directly record the selected into the Table, But what I want is that when I press the command button, it will add the selected data in the Subform "TblPOParticular...
  4. W

    Advice for current DB

    Good day, 1st of all, sorry that my Subject is very broad. Attached is the DB I just created with the help from this wonderful forum's experts... I am now again seeking your expertise. The DB is running smoothly, but then I encounter a problem... The way this DB works is that 1st to record the...
  5. W

    lookup and populate Datasheet with editable selected field, save to other table

    good day, I am here again seeking help for my db... As per title, is this possible? What I am trying to achieve is an update for the purchase request, becoming a purchase order. I was hoping that in purchase order form I will only input the purchase request number as a lookup and the...
  6. W

    2 subforms, 1 subtotal, 1 grandtotal

    Good day experts, Here I am again seeking help for the access database I am trying to create. Attached is my main form, what I wish is that SUBTOTAL will be displayed in the 1st subform (LOT) from the total of 2nd subform (LOT DETAILS). Then from the total in 1st subform, a grand total will be...
  7. W

    custom primary key

    Good day, Sorry for the bother. But I have been browsing to look for answer... Hope you could help me.. Its my 1st time making access database, is it possible to format primary key to YY-MM-series number? and series number will reset back to 1 for next year... Thank you...
Top Bottom