Search results

Here's what I'm trying to do... strSQL = "SELECT pkManColorSizesID, fkSizeID, txtSize " & _ " FROM tblManufColorSizes INNER JOIN tblSizes" & _ " ON tblManufColorSizes.fkSizeID=tblSizes.pkSizeID" & _ " WHERE tblManufColorSizes.fkManColorsID = " &...

Well yes...but I haven't run it yet. Basically it's only part of larger function to populate fields based on current inventory on hand. So until I write ALL the code, I won't know if it works yet. Then again, I guess I could test it with dummy data...:cool: Thanks for the reply though!

Thanks for the tips! I really should have paid better attention in DB classes in college...:o

Okay, so I want to join two tables based on a pk and fk...but only where a field in the first table is equal to one of my variables. I know the INNER JOIN comes before the WHERE, but I'm confused as to where to put the ON and the WHERE. Here's what I have: strSQL = "SELECT pkManColorSizesID...

So I have a form with about 6 fields that will hold numeric values that need to go into a "transaction" table. I have the form built and a combo box for searching for a specific item. Basically, I want to go select an item from the combo box, have the fields populate with the current values...

Thanks for the response. Is it, TempVar!varLocation or TempVars!varLocation? I had TempVars!varLocation, which seems to work, but I don't know if it is correct syntactically. Thanks for the help!

I'm trying to use a TempVar to pass along a value from one form to another to hide or unhide a control based on the user's action on the previous form. I want to put some error checking in for this, so I want to start my hide-unhide constraints with an If statement like: If TempVar!myVar isset...

Oh my - I found out why it works...(Access 2007) In the Access Options, under Current Database...there is a Document Window Options setting for "overlapping" or "tabbed"...."overlapping" allows it to work properly! Silly Access 2007...

Okay, so I searched through the threads for this answer and I can't get it to work right. My issue: I've created a form that I want to be 5" wide (or so) and 6" tall (or so). I do not want the form to open maximized, in fact I don't even want the user to be able to change the size. The problem...

Okay...I think you've lost me! :eek: So let me see if I can try to understand this. I create one SELECT query, within which the FROM would be tblManufacturerColors and tblSizes? SELECT tblManufacturerColors.pkManColorsID, tblSizes.pkSizeID FROM tblManufacturerColors, tblSizes;Then go into the...

I've basically finished populating the table for tblManufacturerColors. Now, how should I populate the tblManufColorSizes table? If I am looking at this correctly, I would have to have the ID from tblManufacturerColors used for each size ID from tblSizes, correct? tblManufColorSizes has a...

Thanks to everyone for the tips and advice. Yeah, I'm pretty much sub-par for where I should be DB design-wise. I should have payed WAY more attention to the DB design and E-R diagram class I had in college. I basically have modeled the DB on the tables suggested here as far as splitting all...

Thank you for your help with this! Time to get down to starting fresh on the design and I will see where I get with the nuts and bolts of this thing lined up for now. Thanks again!

Okay so I am getting a little confused as to why everything gets broken up into different tables. I am also confused as to the the inventory on hand issue. It seems like rather than just storing in a table with a row for each color and fields for each count you're suggesting track the changes...

Thanks for the responses. Some clarification: The SL/8Par/10Leko/12Fres/Cyc/Spot/FullSheets are all the sizes of the gel, but are fields that hold current inventory counts. As far as manufacturers, for this database, a manufacturer can provide many stock items, but no two manufacturers can...

So a quick, upfront "Thank you" for anyone who can offer advice on this! I have a db to handle theatre lighting gel stock that I am working on. I have two tables, one for manufacturers and one for the gel inventory. tblManufacturers ManufID (autoIncrement PK) ManufName (text) tblGelStock...

Thanks for taking a look at the DB a while back. I just got back into it and took a look at your new tables you made. The tblRecords table has a primary key of color number, but in the new table - if I created a table of all records, rather than the current way (table for each manufacturer's...

@vbaInet Well I have not yet had a chance to take a look at the DB, but I appreciate your time with it. I have been reading the articles you posted and I will call this thread closed at this time. ;) Don't be surprised if I show up in the Theory & Practice of DB Design threads trying to fully...

Okay, so here is the database (attached) in a zip file. I haven't coded all the forms yet, so some of them don't work the same - mainly because I'm trying to get ONE form to work the way I want, and will then change the rest, however you'll see that the code on one form is not dependent on the...

@vbaInet Okay, the message box pops up with the message stating that it evaluated the comparison, however setting the new selected item does not show the new item in the combo box. In addition, if I try to move to the next record after that, it says I can't go to the next record and highlights...