Search results

I have a label on a main form which I highlight/un-highlight to mimic the on-dirty (pencil) and on-undo (back to triangle) of the record selectors. But can’t think how to un-highlight the label background when the pencil switches back to a triangle when the autosave happens, when you move to a...

Hi, I found this, which I have used and solves the problem. http://allenbrowne.com/ser-31.html (Subform records with no main form record). Thanks all for taking the time and offering help. Regards

Apologies missed out 'variant'. you tried to assign a null value to a variable that is not a Variant data type.

Hi All, Yes, you are all correct, thats exactly what's happening. The code that pbaldy provided has enabled me to flag to the user this problem through a bespoke message box and improved the situation dramatically. It has now eliminated the standard Access dialog box I described. SO many...

This worked, thanks

Hi All, I am running up against an error ‘Index or Primary Key Cannot Contain Null Value’. In the dialog box it doesn’t give the RTE number just the description, OK & Help buttons. After some searching the description matches RTE 3058. I have identified why it’s happening and through a...

Invalid use of Null.

Hi All, I have a RTE 94 happening due to a piece of code running on a subform current-event which looks at a text box on the parent form. I understand this is due to the order of loading of the forms initially and all works fine when moving to other records once all are opened. How can I...

Thanks for all your help anyway. I'll try and muddle through and create some VBA/SQL code. Regards

The functionality is in the attached database in the frmProducts - the combo hightlighted in blue. This is how its being used at the moment. From carrying out some more research today, with regard to the attached database, to achieve my original aim of the thread, I am thinking it’s some form...

Yeah, that is terribly written. Just need the ability to filter the PricingRecords by Supplier and Product from one combo. Therefore the combo would list ProductA|SupplierA ProductA|SupplierB ProductA|SupplierC ProductB|SupplierA ProductB|SupplierB ProductB|SupplierC ….. ….. With one...

Hi MarkK, I see where you are going with this. What is important functionality for us is to be able to select a Product from a particular Supplier filtering to limit the Pricing Records accordingly. Or alternatively, the other way around, selecting a Supplier and then filter Pricing Records by...

Hi Markk, Thanks very much for this. I'm working away today, back tomorrow, when I will be able to take a look. Regards Mark

Hi, I have attached my sandbox DB. Its presently configured how it works today and therefore includes the issue and therefore reason for raising this thread. Apologies, terminology is a little different than in the thread. Need to substitute ‘products’ for ‘equipment’. The main form is...

Hi, Yeah, I think I can see where your coming from now. I suppose the main reason why I had the 'mid form' (if you can call it that) was to use it to group the equipment by supplier therefore restricting the pricing records down to only equipment supplied by a particular supplier. But, that...

Hi MarkK, Hmmm, thanks for the reply. Have given this some thought. I have got a junction table, which both Equipment & Supplier are linked by, but the Pricing Record form pulls the Equipment & Supplier ID's straight from the Equipment and Supplier tables not the Junction table? Perhaps this...

Dear All, I have an Equipment Form with a Supplier subform. The Supplier subform also has a subform, Equipment Pricing Records. I have the ability to change the Supplier via a combo box, but Equipment Pricing Records become orphaned. What I would like to do is when a Supplier is about to...

So simple. Thank you.

Hi All, Can you have a saved (unsorted) query as a row source for a combo and then add some code to enable the combo to sort the list? Reason is, I want three combos to use the same query for finding records in different ways, but need the query to be saved, not a query built by the query...

JHB, THANK YOU, THANK YOU, THANK YOU, you don't know how much hassle this is going to now save me, with people entering data in the wrong records. You are most definitely on my favourites list. Regards Mark.