Search results

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!

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...

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...

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

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.

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...

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

Thanks again Kevin, that would work!.

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" .................

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

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.;)

Hi Mile, It works perfectly, thanks a lot!

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

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

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!.

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

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"

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.

Hi Fizzio, I understood and done, thanks!

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".