Recent content by adbie

It would be amazing if you can make some time to take a look at my db. I try to give a better description for the functionality: Please take a look at the table tblBatch, there are 3 records include where the form productselection is based on. Every Batchnumber has several foreign keys ( table...

Thanks, and is it difficult then to do that in my db? (To copy 6 subforms via 1 single button click)?

Hey, Yes It looks good, but when I select the flagged items and press copy he duplicate in the same country record and it has to be include in a new Country Record Like Andorra15, AD2 (so I can change the country code and productcode if I want)

Thanks alot for your great help! And do you know a solution for the second problem? I like to duplicate a full row why? Sometimes I have to create a new batch that looks similar to one I created earlier, so I can simply duplicate it and edit the necessary things like other productiondate (Copy...

Hi, k thanks for the 2 reply's. But how do I define a controle to batchId then?

Thanks alot for the code, But now I get an debug error (Run-Time Error '2110' Microsoft Office can't move the focus to the control Batchid): I used the following code in frmLookupBatchViaProduct

Thanks for your help, But i'm afraid, I can't find the code that has to be put in the subform. (In the attached file (post 1) is the frmLookupBatchViaProduct incude, only the action button link is not set.

Step by step 1. User Open form frmProductSelection 2. User press action button 'Go to a specific Batchnumber' (popup frmLookupBatchViaProduct opens - not created yet in frmProductSelection) 3. User click on a specific record in the popupform (frmLookupBatchViaProduct) and click on 'go to...

I tried it but does not work. Maybe because it's a popupfrm and subform relation?

Hi, I'm a student and try to get a better understanding of VBA in an Access database. I like to do the follow: - Click in the popup box (LookupBatchViaProduct on the main form productselection) on a specific batchnumber and go to the specific record on the main form (form productselection) I...

I forgot to attach the file sorry, http://rapidshare.com/files/252201800/db.zip.html

Hey, please take a look in frmFormlookup. I like to select one of the 3 critera to display all the information below the form. If there are more batchnumbers for 1 'productnaam' (productname) I like to get an overview of all this batchnumbers linked to 'productnaam' and then I can select the...

works perfect now! maybe the error can be alterted in a msgbox? now to stap 2? Lookup productcode and / or productname & editions of both? thx

Wow, it looks great (subform) but after I click on the door (close) I get an error: The text you entered isn't an item in the list. Select an item from the list, or enter text that matches one of the listed items. but the information is added in the table. (Language programmed Dutch) Can you...

Via the append query I add a product record. But how do I insert product information in the form (currently always get an error - work via query).