Search results

Sorry, I missed the part about limiting the value list - glad you got it sorted!

Hello, This is where it becomes necessary to think through and consider a UI design strategy. What you've built with your dropdown controls are what they call "cascading comboboxes" or "cascading filters" - where a choice from the top level of the hierarchy dictates the choices available in...

Howdy and Welcome! First, setup your tables, then starting with a form to be used as your "master" or "main" form, insert a Subform/Subreport object. You can also insert a Subform/Subreport object within this subform, and bind them accordingly (just like native Access forms):

Sorry, I would need to see your table structure in order to help you. It sounds like the number of subform records is already the same as the number of packages... But if you only needed to calculate the number of packages, then you could use the formula: # Packages = [Total Quantity] \...

Hmm.. it seems odd to me that user can/should determine both Total Quantity of Product and Quantity of Product per Package... I would expect the Supplier or Shipper to determine the latter Quantity rather than the Orderer of the Product.. Or maybe the user IS the Supplier or the Shipper and...

Correct me if I'm wrong - there are 3 Quantities: Product Quantity Products per Package Quantity Number of Packages Which Quantities is the user entering?

welcome to AWF! :cool: I've dropped in here after a long hiatus from AWF myself... So does your Products table have a PackageQuantity field? Or are there possibly options for PackageQuantity that can be chosen for the Products (i.e., "bulk", "standard", "sample", etc.)?

Hi Megan, I know this is many moons later, but I ran across this thread while testing out Access Services on SP 2010. I was successful creating a 3-tier form (form, subform, sub-subform) - so I wanted to let you know that it's certainly possible! Cheers, John

true - I assumed OP was looking to reference the control value as criteria

This should help

If your form is bound, you can use the Control Source for the text box: =Sum([And]) And put the text box in the Footer. HTH, John

namliam - glad to hear you're keeping honest :D After reading up on these Singles datatypes, it might be more accurate to call them "Single imprecision floating-point" numbers What a troublesome lot, these Singles (and I'll have to grudgingly admit that I'm one me-self :p )

ok - just to be clear, the point I've been trying to get at is that you don't want to store calculated values in your table. Calculations on your core dataset are what Queries are for. And your core dataset in this case is the data input on the subform. Therefore, what I'm ultimately...

In case you're really interested, here is the low-down on Single precision floating-point numbers

Hi Rob, Yes, I already understand your original explanation - but I was hoping you could respond to my questions. I suspect there may be some design issues which need to be taken care of. Your approach with the subform Footer totals and the main form text boxes is standard except for the fact...

did some digging and found this thread, which you may be interested in... I would imagine that precision issues with these datatypes, used in conjunction with the Round function can yield very unexpected results, as you're seeing. It may be that changing your datatype is the best option (to...

Hello and Welcome, May I ask why you're storing calculated values (via the main form bound controls)? And it almost looks as if your Sum should be a Count instead... Apologies for not addressing your problem directly, but perhaps if these aspects of your circumstances are considered, it may...

since (ColA, ColB) can represent the same values as (ColB, ColA), you need a way to draw an 'atomic' equivalence. One 'trick' method I can think of is to represent them as components of a conditional field and a simple sum field: LesserComponent: IIf(ColA <= ColB, ColA, ColB) SumOfComponents...

That sounds odd. What datatype is Num?

Re: Creating Listbox into "search form" that generates query - see code - almost ther FWIW, it sounds like you're working with some very de-normalized data, which is really going to make things incredibly/increasingly difficult for you as you try to get results from it. I don't know what your...