Search results

  1. A

    How to update subform using unbound text box on main form

    hi, sorry i have 2007 version installed in my laptop, can you save as for 2007 and send it again. thanks in advance.
  2. A

    How to update subform using unbound text box on main form

    hi, thank you for attachment, unfortunately i am not able to open the file, i have 2003 version on my laptop, can you please save as for 2003 and resend. i will appreciated. regards.
  3. A

    How to update subform using unbound text box on main form

    hi, pat as i have very limited knowledge of db, can you please make me a test db like this so i can see where i a making mistakes. thanks in advance. best regards.
  4. A

    How to update subform using unbound text box on main form

    thank you Pat, but some thing is still not letting me sort this out. i have made a test database and attached herewith. when you open the form1, you will see just two lines in the subform. in the main form test (unbound), i need to add any value in the box which i need to post in the subform...
  5. A

    How to update subform using unbound text box on main form

    Thank you Pat Hartman, tried with ! but the result is same. no good luck. any thing else i can do to sort this out, please advise. regards. sajid
  6. A

    How to update subform using unbound text box on main form

    hi, thank you for your advice. i have tried the update query but when i run the query i am getting the message "enter parameter value Forms!PO_Query_subform.orderno" any more advise will be appreciated. thanks in advance.
  7. A

    How to update subform using unbound text box on main form

    hi, thank you for your replies, but is there any way to update the entire column in the subform using vba or macros? thanks in advance.
  8. A

    How to update subform using unbound text box on main form

    hi, i have a subform on main form, i have unbound text box on main form where if i add any value, goes to first row of [orderno] in the subform (datasheet view). what i want to fill in the entire column of [onorder] instead of just first row. (this is my code at afterupdate event...
  9. A

    stock control

    hi, i made a database in which i have form and sub form. i am using sub form as datasheet where i have around 15 column. in these 15 columns i have 8 check boxes. when i made this form and sub form i had just few rows in the table as dummy data to test the form. i had filters working on all...
  10. A

    stock control

    thank you for your time, i will try to build a small project first.
  11. A

    stock control

    hi, i have made stock control spreadsheets in excel. i want to make simple db in access. db should be as receipts issue and balance. for example i have a,b,c,d,e,f,g,h in stock and i have 1, 2, 3... projects in which either some of a to h are used or all a to h are used. after issuing a to h...
  12. A

    Getting rid of middle initial in query

    hi, any one can advise, where to post a theart
  13. A

    Question auto fill text box on onload another form

    hi, thanks again, i think i was referring the event on wrong form. it is now sorted and my final codes are Private Sub Work_Order_Number_Click() DoCmd.OpenForm "his", acNormal, "", "", acAdd, acNormal Forms![his]![WONO] = Me.[Work_Order_Number] Forms![his]![test] = Me.[PIB_No] End Sub thank...
  14. A

    Question auto fill text box on onload another form

    thank you Paul still not working. sorry i think i could not explain you well. i have a subform "line1" in which i have "work_order_No", "pib_no" etc. in another form "his" i have again "work_order_No", "test", etc. i have click event on "line1"'s "work_order_No". soon i click on the this...
  15. A

    Question auto fill text box on onload another form

    thank you Paul, i have tried, but noting happening. Private Sub Form_Load() Forms!his.test = Me.test End Sub
  16. A

    Question auto fill text box on onload another form

    Hi all, i have started access and create a database. if some one can help the following please. i will be much appreciated. i have a subform "line 1", in that form i have a multiple fields. on one of them i have put click event which open another form called "his", i want to automatically...
  17. A

    introduction

    hi, my name is sajid, living & working in uk (birmingham) i like access data base and made some sample and complex data base for where i am working in. hope i will be a useful member of access world forum:)
Top Bottom