Recent content by Me!Fiesty

Some of the data sets that I'm working with are massive (some in the millions) with dozens of different vendors. The way the data is delivered varies greatly as well. I have Central database with all the products and tables for commonly used product options and categories such as size, color...

Ok. Done. What's next?

ProdNo is an additional PK. Are you suggesting the juction table should have an Autonumber PK as well?

So....my project....retrieving data from distributors and vendors (some small, some large), taking their spreadsheets and preparing for export to our applications and website. tblNewData ProdNo.........(text, not primary, indexed, duplicates ok) Desc...........Copied from OrigDesc (changes...

I need help writing a function to split the image names. In essence, I need to create a separate record in a related image table. I have searched over and over again I can't seem to produce the results I need. I would like to review the records in query so that I can add criteria before...

:confused: Need some help hashing this out. I have a form that's currently bound to a totals query. I have an unbound search field in the header section. In the details section I have the ID, Balance and count of records. My search works find and the data displays correctly. What I need to do...

I've just used this code in form that has totals query as the underlying recordsource. It works beautifully so far. Instead of displaying a msgbox no match would like to open a form that I've already created that would give options to add the data. And if they decide no to clear the search...