Search results

It reads the data in that field to get the number of the blanks of that specific species for that year. Actually, all I need is a sequence number so I know what is the next number in that sequence. And yes, the form that holds the combo box will eventually append that compiled ID code to the...

Here's what I've come up with so far - the first 3 parts are working, it's the 4th part (the seq number) that is currently alluding me. I'm new to Access & queries, so it's probably right in front of me & I just don't see it yet... I have tblWood, with a field txtWoodIDcode with entry's that...

I have tblWood, with a field txtWoodIDcode with entry's that identify a piece of wood. For example: txtWoodIDcode Ash07:001 Ash07:002 Ash07:003 Ash07:004 Elm06:001 Elm06:002 Maple05:001 Maple05:002 Maple05:003 & so forth... I have a form with a combo box that I select the first part of the...

I would like to create a unique ID number (currently the Primary Key) for a table in Access 2000. I am using 4 elements for the current manual entry, and want to automate it after I make one selection on the Combo box. The elements are: 1: The species of the wood I am entering into the...

And that did it! Again, many thanks. Stephen

I just did a quick hard code of one of the images - and it worked just fine. I'll fix the path in the AM. Thanks

OK, I tried that - and it didn't seem to work - but no errors. I copied the code to list0, on click, same thing. I suspect it's not finding the right path to the image yet...I'll play with it a bit in the morning (it's about midnight here & I've been up since 6AM) and get back to you on what I...

OK, Dave - sorry to bother you but I've got another problem. I want to add the image of the current selected bowl in frmPrinting, to be sure that the bowl I want to print the card for actually has a valid picture - just as in frmSplintersProductsBowls. I copied the image field from...

OK, that seems to work. Don't really need it with the description or price cards, since they are separated and placed with the specific bowl, but might be handy to have for the catalog, when the sorting hasn't quite got it right. Thanks, Stephen

That looks great, Dave - just what I needed. Thanks, Stephen

I looked at the stuff I found on DAP - and it looks like a bit of work... I do know HTML, CSS & JScript fairly well, so I think that's looking like the best route for me on that. For one thing, I am getting the impression that exporting an Access form or report only transfers the text - not the...

OK, one other quick question - I changed the Multi Select property in List0 of the Bowl page and I can now select all the bowls listed. But how do I get it to copy all the selections to List2? I tried dblclicking, won't work. I want to be able to do this so I can get a complete catalog of all...

Yeah - much easier! Wow, I never realized that Access was this powerful! And to find such helpful folks in the bargain...I am indeed blessed. I did some searching and did find that I can make a web page from scratch, or export the form to an existing page template. Haven't tried it yet, will...

Well, this is the mouse wheel, not the mouse itself. The mouse seems to work fine now. I'll do some searching later for info on it - not a great problem. Right now I am working on getting all the photos & text for over 100 bowls into the DB so I can make the cards & get (some of) them to the...

Makes sense...should have seen that one...:o That works, the reaction to the scroll move is a bit slow - may have something to do with the size of the table, over 100 bowls. But the mouse wheel still has no effect - is this normal for Access? I made these changes to the price card report...

Dave, I've spent most of the week working out the bugs, and finally have close to what I need. Somehow, I'd forgotten how intense this sort of activity can become...:eek: But, on the other hand, it can also be very satisfying when it all falls into place...:D I tried attaching the demo, but it...

Dave, you do great work - now you've removed all my justifications for not getting the rest of this thing done...Sigh :D:D:D "Yes, dear, I'm working on it!" Thanks :), Stephen

OK, just tried the "new image" from the main product form - and it worked! I'll check the code in that section in the morning. Stephen

Nope - same error. Access 2000 doesn't use FileDialog, that was implemented in a later version. And like I said, the examples of how to do it in A-2000 are a bit overwhelming at my stage of VBA programming. I'm thinking the best course for me at this point would be the dynamic loading of the...

Here's the current file - I did add a dummy image path for any record without a bowl image. And I checked the reference list, no OFFICE 10 object library listed. I am working with the standard version of Access 2000, so it may be something in the pro version. Also, the Example5 file comes...