Search results

Bringing this back, so as to say thank you everyone for the various sources of inspiration. I have finally found a way to work it out after much much much trial and error. :banghead: To begin with, let's just say that selecting values in Combo-box A and populating Combo-box B, when both are...

So I've tried several solutions and it is very difficult to say the list, if not impossible. I've created several tables with one-to-many relationships, but I'm stuck with the VBA code to make the multiple values listed in the Subform handling cultural periods associations filter/cascade the...

Yes they are both in multi-value fields. Each field relates to another table, which is the source for the lists.

Let's clarify the situation a bit: - Each combobox has a record source in a table and is setup so as to store multiple values. - Combobox A holds information on the date of cultural objects (e.g. Hellenistic, Roman, etc.). - Combobox B holds information on the ceramic shapes that you could...

I will be working in the next couple of days on a situation that goes a bit like this and just wanted to know beforehand, whether it is possible. The situation is as follows: - Suppose on a form that I have two combo-boxes (A and B), which both store multiple values. The question: Is it...

I've managed to get it working with DLookup, as below, but I was wondering if there is a less heavy way to go about it. I'm marking the thread as solved, but if any ideas are out there, I'd be interested to hear them.:D Private Sub Lot_AfterUpdate() If DLookup("ExtraPotLots"...

Hello to all, I have an issue that can be described as follows: - There is a textbox on a form and when I fill in its value, I would like it to lookup whether that value matches any of the values in another form and if it does present a message box. Both fields hold only numerical data, so no...

Thank you for your clarifications and your advice! :D

Some questions: - Which TableName do I include: The master or the detail table name? - Same question for the KeyFieldName.

Another issue that is probably easy, but for some reason did not manage to solve it on my own. I have a parent form and connected to it is a subform. On the parent form I have a checkbox which enables and disables fields on the parent form and also hides the subform, as you can see in the...

I've also thrown in a Not IsNull if procedure in order to avoid an error for null values in the text box. Thank again JHB!

Okay this brilliant workaround significantly reduces the size of the process and can therefore be included in the Form Load event too! Thank you very much for your help!!!:D:D:D

This is what it looks like: ID MunsellValue RGBValue 1 5R 8/1 255, 255, 255 2 5R 8/2 218, 194, 203 3 5R 8/3 255, 255, 255 4 5R 8/4 239, 188, 194 My combo boxes in the Form display the MunsellValue, but are bound to the ID. I would like the .backcolor property of...

But the comboboxes are not coloured. They simply allow the user to select the MunsellCode from the ColorValues table (there is a total of 340 options). They register as a number the ID of the MunsellCode and display as a text the values from the MunsellCode column. Also I've already tried a...

Hello to everyone, I have a problem that is probably the result of lack of of knowledge in Access VBA. The situation is the following: I have a table named ColorValues with the following three fields: - ID - MunsellCode - RGBValue 30 fields from another table called Color_Analysis are linked...

After doing some research on my own, I still couldn't find any help and I tend to believe that it is not possible to be done. So if you are designing large scale systems avoid going beyond the first level of connecting things if you want to retain the duplicate/copy-paste ability. I had to go...

In case anyone is wondering what type of VB code I've used, I'm pasting a sample of it (the first 5 of 16 subforms the data of which get duplicated this way) Private Sub Command3260_Click() On Error GoTo Err_Handler 'Purpose: Duplicate the main form record and related records in the...

I have a quite difficult problem to solve in Access and I hope someone can help. I have been struggling with it for a week now.:banghead: My programming abilities are mediocre, but not novice. I have a pretty large scale management system to build (more than 40 tables, lots of relationships...