Search results

OK, finally got back to this - and found a question! Dave, I've modified Example to use the txtPreductCode as the key (This is because I need to keep the codes in order in the table and on the query's & reports). Can't get it to drop the need for intPreductID altogether, but that's another...

Will do - probably with some more questions! :D Stephen

Dare I predict that the preduct will be productive? :D:D:D I'll do that - at least the short version (the full file would be too big). I still need to put all the data together - including getting the photos and descriptions on over 100 bowls into the PC! And I need to link the wood inventory...

Yes, I see that now...so nice to have such compact work space, isn't it? :rolleyes: Thanks - I thought I had all of those, but sometimes what the eye sees doesn't make it all the way to the brain. Plus, after looking at them so many times they all start looking the way you think they should...

OK, I used the V-Tools, and it did help locate some references I missed...but in most cases it required me to make the change manually - not a big deal but a bit more work. I did notice that it does not seem to clear it's own buffer - after making a change and doing a search for any stragglers...

Oh, one of the things they don't tell you about in the books! :rolleyes: Just looked at the site, will definitely give it a try...thanks.

Dave, I've tried to edit the example by changing the field names to have prefixes - ProductCode becomes txtProductCode sort of thing, to make it consistent with my other files - and seem to be hitting a brick wall of sorts. I have set Tools/Options/General/Name AutoCorrect to change all...

Well, at least you have most of the info on the one page...;) It's been about 3 years for mine - http://www.splinterscraftworks.us/, nice images but slow and clunky. Another of those "soon, right after..." projects. Stephen

Oh, yes! Getting better all the time! Again, thanks...you want to do my web page as well?:D (just kiddin') Stephen

Dave, that is outstanding! It does exactly what I needed it to do! I even loaded the photo paths & got the images...a bit of tweaking with the formating on the print should give me exactly what I've been doing by hand in Word. :cool: A big thanks, :D Stephen

OK, took a closer look. The problem I see with this is that it requires all the records accessed to be sequential - I need to be able to access any 4 (out of many, at some point hundreds) individual bowl ID records, not in any order and possibly even forward or backward from the prior ID...

Which is one reason I didn't use them in the first place. From what I have seen, the only real requirement for Access is that the key be unique - and not null - exactly what my code needs as well. And, this way, I can see any problems such as gaps immediately, just by scanning the table...

OK, that's a great start - thanks for the example. Stephen

John, I can see the logic in that - and may change to that once I know everything is working the way it should. For now, I need both codes to be unique and sequential. Which, I understand, autonumbers would do - but I've been working these by hand for some time, so it's just an old habit at this...

I need to construct a form in Access that uses data from different records within the DB - 4 identical formats on one page. This will be sent to Word to print (or could this be printed directly from Access?)... Is this possible, or do I need to produce the separate sections individually and...

OK, I had a chance to work on this - and, while most of it is still as clear as sheepdip :o, I did get something close to what we were talking about...close, but not quite there yet. I've attached a zip file of the sample DB - with just the basic elements and a few records. tblWoodInventory...

That did it - thanks! I also found that I needed to keep the items you mention in the quotes to avoid an "unknown variable" error... Thanks, Stephen

Does this work with Access 2000 as well? I copied it to my DB, but get an "undefined function" error message.

OK...that makes sense, and does seem to solve the problem of multiple materials. I'll play around with it this week, probably will have some more questions later. Doc, many thanks to you and John W. for the great - and very patient - assistance. Stephen

OK, John W. - It appears that my response to your post was incorrect in that you were right about the relationship being a many-to-many and not a many-to-one as I assumed (not realizing at the time that such a relationship does not exist...:o). Anyway, it seems to me that I may be...