Recent content by MightyRoo

Got it..... NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XBrandIDLink] = " & Me.BrandIDLink & " and [XDeviceType] = '" & [DeviceType] & "'") And then Finally NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XModelIDLink] = " &...

Hello, I can get the following to return the results I need.... (BrandIdLink is a number) NumberOfModels = DCount("[XModelIDLink]", "QryBrandsWithMultipleModels", "[XBrandIDLink] = " & Me.BrandIDLink) And (DeviceType is text) NumberOfModels =...

Thanks!

Would really appreciate some help with this and reasoning..... 'THIS WORKS (below) blah = DCount("[value_id]", "mage_catalog_product_entity_vahttp://www.tek-tips.com/threadminder.cfm?pid=702rchar", "[attribute_id] = " & [XAttributeID]) 'THIS WORKS blah1 = DCount("[value_id]"...

MajP, Thanks for the reply, I am still struggling to understand this and I am getting an error.... When I use..... 'Create CategoryPath CategoryPath = CatBase & "/" & Me.Category1 & "/" & Me.Category2 'Variable is declared at top...

Hello, I would appreciate some better understanding of the proper syntax for lookups/dcounts etc I always struggle, In this particular case I have.... Dim CategoryPath CategoryPath = CatBase & "/" & Me.Category1 & "/" & Me.Category2 & "/" & Me.Category3 JunkPath = CategoryPath...

Thanks for the input!

Tek-Tips Pro’s A little background…. I could really use some direction; we are building a custom database for my business, MightyPouch.com. We make custom cases for just about everything from scratch. We cut the materials and sew them. Our business model is to offer the customer a completely...

Thank you both for your reply. Axworthy, your code did what I wanted. Thank you for that little trick.

Hello all, I'm having an issue with obtaining some data from a table that falls between a date range. The code is as follows: CustDiscount = DLookup("[CustDisc]", "TblDiscounts", "[CustID]='" & CustomerID & "AND [EffectiveDate]< " & OrderDate & " AND [ExpirationDate]> '" & OrderDate & "'")...

Hello all, Our DB is spilt FE/BE in Access 2000. I have an issue with the page layout changing from landscape to portrait and the number of columns changing from 3 to 1 on reports (labels). I can't even figure out where to start as a report will open and print correctly and then you open it a...

PHV, Thanks the... price = DLookup("[" & AWidth & "]", "TblPrices", "[length] = " & ALength) Works great. Thanks a million! Scott

Hello, I am completely stumped and would greatly appreciate some direction. I have some code that develops the following AWidth=Adjusted Width ALength=Adjusted Length I have verified the AWidth and ALength formulas are working. I have a table call pricegrid It looks like this just much...

Works great! Thank you so much! Thanks! Scott

Thanks again for the help Aceman1, The code that you supplied looks like what I need. I copied and pasted in and I get the following error when it is running. "Invalid used of '.','!', or '()'. In query expressions '[Nominalsize]=Forms(frmworkorders)([subfrmlineitemsvbfr ---wood...