Search results

  1. J

    Form - Subform

    Hi Kevin, Thanks again for your effort to help me with this, I do appreciate it. I think your suggestion is the most doable way of solving this issue. I will give it a try and let you know. Have a good day!
  2. J

    Form - Subform

    I am sorry Kevin if my last picture gives you a wrong image, the grey zone is the sub-form with the fields: credit coll and value. The Main Form has Credit #1 and Credit #2 as fields. Main Form is linked to Main Table Sub Form is linked to Table A So, in Table A, I have only one column...
  3. J

    Form - Subform

    Kevin, But I do get the 2 credits # in one column (Table A - from Financial DB). The Main Form is linked to the Main Table and is used as a Data Entry form as well as an Update form. For that reason, credit #1 is separated from credit #2. The subform is used to give additional information on...
  4. J

    Form - Subform

    Kevin, See attached more detailed info, hope this will help you to understand what I want to achieve.
  5. J

    Form - Subform

    Hi Kevin, attached I have a print screen of my form and sub-form and the parent - child link property. If I only use 1 linked field (either RE with Credit Memo # or RE Credit Memo with Credit Memo #) than it works, but not if I am using both links as shown in the print screen.
  6. J

    Form - Subform

    Hi Kevin, I did try before I posted this on the forum, the way you suggested me to do, but it doesn't work. It works only if I choose one link, p.e.: Credit #1 or Credit #2 only, but doesn't work if I do Credit #1; Credit #2. There will not be Credit #3 so far ... Why?. I can see that teher is a...
  7. J

    Form - Subform

    How do I define the parent and child link to link two fields from the main form to a subform
  8. J

    Make-Table query

    Thanks again Kevin, that would work!.
  9. J

    Make-Table query

    How can I run the Make_Table Query without having the following warning message pop up on the screen?. "You are about to run a make-table query that will modify data in your table" .................
  10. J

    Form and sub-form

    Kevin, Thank you very much, it works at the first try ... you really make my day! John.
  11. J

    Form and sub-form

    I am looking for a way of linking a form and a sub-form, see attachment. The Main form is used as data entry and update, the sub-form data can not be edited and changed, just used as additional info of what the Main Form displays.;)
  12. J

    Write protection

    Hi Mile, It works perfectly, thanks a lot!
  13. J

    Write protection

    Hi Mile, I am just a beginner, can you show me how to write the procedure?
  14. J

    Write protection

    How can I write-protect a record in a "input from" from overwriting after this field / record has been input. So, if this field is not empty, protect it from overwriting ... and if empty, allow man to record a data into this field. Thanks in advance
  15. J

    Creating new table

    Hi FoFa, I've managed to write a short routine to empty the table and upload the new Excel data onto this table using a button. Thanks FoFa for your reply!.
  16. J

    Creating new table

    How can I upload a list of material in an Excel format into an Access table by using a button (VBA).
  17. J

    Search

    Yes, I have already created a form that table and create a "search" button, but than it will search the entire table, not only the records where the "Status"="WIP"
  18. J

    Search

    I have a table with 14 columns, one of those is "Status". How can I perform search function (with a keyword), using all fields of this table and only search the records where the "Status" = "WIP"? Thanks in advance.
  19. J

    Two-column combo box

    Hi Fizzio, I understood and done, thanks!
  20. J

    Two-column combo box

    Hi Rich, thanks How to deal with my 2nd question?, the tbl_sales with record "Customer_name" has to capture this [combobox].[column](1) as a new record in "customer_name".
Back
Top Bottom