Search results

  1. W

    2 subforms, 1 subtotal, 1 grandtotal

    I have been searching in web on how, but I cant seem to find it... So sorry but I am still new to Access..
  2. W

    2 subforms, 1 subtotal, 1 grandtotal

    up please... need help...
  3. W

    2 subforms, 1 subtotal, 1 grandtotal

    Thank you for the reply. But I can't seem to find how to do this... Sorry for my ignorance...
  4. W

    2 subforms, 1 subtotal, 1 grandtotal

    I just did the form wizard, and include the fields from 3 different tables, then access just combine it in 1 form...
  5. 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...
  6. W

    custom primary key

    WOW!!! Many thank for these tips and tutorials... I will browse them thoroughly and will be back here in case I encounter something that I don't understand... Would that be OK? Thank you again... This is a huge help...
  7. W

    custom primary key

    By the way, this is what I am trying to achieve... The PR Number is wrong, it is supposed to be 18-12-370 because it is december that the PR is created...
  8. W

    custom primary key

    Sorry, never though of zipping... What I am trying to do with this is 1st it opens the Form "Purchase Request" then after that It links to open another form "Lot". "Lot" is like a category for the details of the Purchase Request. in 1 Purchase Request, there can be many Lot. I had tried the...
  9. W

    custom primary key

    this is my relationship
  10. W

    custom primary key

    I cannot attach my access because it is 3.06mb.. the limit is only 2.0mb please advice on how can i let u view my file... Thnx...
  11. W

    custom primary key

    Thank you sir... will follow your advice... Would you be kind to take a look of the database I made so far? I am trying to link multiple tables. "Lot" is like a category for each PRParticulars like materials, labor, meals, etc... in 1 Purchase request, there can be many "Lot"... What I did to...
  12. W

    custom primary key

    thank you for the reply... I will study it...
  13. 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...
Back
Top Bottom