Search results for query: *

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 =...

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]"...

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...

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...

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...

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...

Hello all, I would sure appreciate some help with this. Here is my current code Me!UnitPrice = DLookup("Price", "TblPricesWoodBlinds", "NominalSize = forms![subfrmLineItemsVBFR ---Wood Blinds---]!NominalSize") The code works when I am opening the "subfrmLineItemsVBFR ---Wood...

Help! I have a table called tblworkorders and a table called tblemployees. I need to have a "status" of each employee that displays what workorder they are on. I have a frmproductionsignoffs with the workorders information and a dropdown to select the employee that will be working on the...