Recent content by petermeter

Some things to consider for somebody who runs into similar issues like data type mismatch and stuff. I ran into problems when processing more data because of the type of data, so I just used "VAL(whatever)" to convert my numbers stored as text to numbers, now "<> 0 " works also flawlessly.

Thanks for this suggestion, (((assign_v.f)<>"")) does indeed work, but I still got a data type mismatch since I need "x" for the filtering. I found that the "Like" operator works. I used (assign_v.x Like "[!a-z]") which finally works :) :) . My guess it has something to do with the combo box...

I get the filenames with some VBA, it is in "Form_tblpictures_populate", then It just gets processed down into model_id and the name of the part in tblpictures_v. The translating works because of the image naming convention.

Yes, it is kind of the root of my problem. I try to assign a value which is equal to the 2 column of the combo box to this combo box. It worked with the ID with said combo box, but with that I have separate issues, namely that I cannot filter out NULL values in my cartesian product.

Sorry for my chaotic explanation, I find it really difficult to explain my problem clearly.

I just uploaded my db. Data which is repeated many times and not changed is saved in tables and whenever I have a unique part it is a combination of those tables, does this make sense? I know appending from filenames to comboboxes is ugly, but it would save me a ton of time if I get the...

thanks for the nice welcome.:)

The target table where i want to append to is "parts" I get the filenames to "tblpictures" I process them in tblpictures_v I try to assign them to the corresponding partname_id in assign_v, this is where cartesian product happens, which is not a problem but "Is Not Null" doesn't seem to...

The table to which I want to append the new data to, consists of comboboxes from different tables. The new data is basically a combination of these comboboxes. It is a list of spare parts from different motorcycles. The motorcycles and spare part names all repeat themselves, so it's...

Hi I'm kinda stuck. I have a table which contains the filenames of a specific folder. These filenames then get processed to create a given term I already have in my DB. My goal is it now to run an append query to add these filenames to a different table. I made sure that the product of these...

Hello Thank you guys and galls for this content, it helped me a lot before, and I hope I can contribute as well. Greetings from Switzerland