Search results

Yes, you are correct.

I was able to re-do some stuff. I *just* tested this and rptLineSheet loads with no errors.

Sorry, I used terms that I outlined above - they are specific to my tables. I haven't used 'variant'; was just using it to try to explain what I'm trying to do. Yes, it's an inventory of jewelry. I don't know the best way to set up the tables to do so. The way it's currently set up does not...

Idk what's going on now. I added everything to a new database and redid the subreports and now I'm getting a 'query is too complex' message when trying to open the main report. I narrowed it down to which subreport is causing the issue but I don't know why. grrr.

With the way the relationships and tables are set up right now, I can't differentiate between different variants of the same ring. Think of it like shoes: each shoe can have multiple sizes and each size can have multiple colors. I don't know the correct way to associate each unique size and...

It's not split. I kept it all together because I was working on it from two different work stations. I've re-uploaded the Access 07 version.

There is no grouping or sorting in my reports. See the attached database. It's a 2007 version and when I saved it as a 2003 version, it stripped everything but the tables! The main report is: rptLineSheet. There are three nested subforms inside of rptLineSheet: rptJewelryPiece...

Right under 'Fluted Elizabeth Broach' (row 1, column 2), there is a block of white space because 'Fluted Elizabeth Ring' (row 1, column 1) is a taller record. I have the columns set up to fill in across, then down. Is there a way to eliminate that block of white space underneath 'FLuted...

Ok wait - do you mean to store the MetalFK in tblGemLink instead of in tblMetalLink?

Yeah, I don't quite understand. I also tried to convert my db into a 2003 and older version but kept getting an error "can't save in an earlier format because it's using feature not available in earlier versions". I got this error even after i deleted everything out of my database. I've...

A ring can be made from different metals and can also have different gemstones. Ring 1 can have different 'varieties' (Var): Var 1: ring 1, metal 1, gemstone 1, gemstone 2 Var 2: ring 1, metal 2, gemstone 1, gemstone 2 Var 3: ring 1, metal 1, no gemstone Var 4: ring 1, metal 2, no gemstone Var...

I have a report with an embedded subreport. It's set up in two columns, ordered across then down. My problem is when column 1, row 1 section is taller than column 2, row 1 section. It creates a lot of extra white space as I fill in the rest of the report. Is there a way to eliminate that...

Thanks, I'll try that.

Thanks for your time!

Sorry. But I think I figured out what was happening. When I rename the module the same name as the function itself, I would get "Undefined function 'concatrelated' in expression." When I named it anything else, it works fine. I didn't even think to rename it something other than Module1 or...

I know this is kind of old, but looks like a good solution to what I'm doing. I can't quite piece it all together, though. I created a query to combine the RecordPK (which is also how I'm going to name the pictures) with the rest of the path. So I end up with...

I have some code that runs a concatenate function. I opened up the VB editor and inserted the copy and pasted code into a Module, not a Class Module. The concatenate function is called ConcatRelated. I call this from a query using "ConcatRelated" until I change the module from 'Module1' to...

Why is it when I rename a Module from 'Module1' to something different, the code I reference from that module no longer works?

I'm building an inventory to keep track of jewelry. 1 ring can have multiple gems and be made of multiple metals. However, this ring can also have no gems. The ring will cost different prices depending on the mixture of metals and gems (or no gems). I'm creating a report [rptLineSheet] (with...

Thanks for the input. This field is something that is getting manually entered into the database based on an MSDS. So a person is going to have a paper copy of an MSDS, then find the flashpoint on the MSDS and enter it into the database. There are only two possible outcomes: 1. We enter a...