Search results

Like I said, stupid question lol. I had copied a field and it was not the type I thought it was, and it didn't even register when I was typing until after I posted lol.

Nevermind..lol...this was a stupid question.

Because I was doing that very quickly and messed up the query. I've attached one that works properly. Each combo box you select allows a query to be run on the successive box using the value(s) from the previous. In the case of the final combo box, for period, I didn't have it limit the...

The add registration and add registration alternate simply show two different ways to do the same thing. The alternate form requires some VBA for it to work properly and is a bit more advanced.

Yup, went back and looked. You need to add a class to the tblClass table, but you should use a form to do that. Once there, you can add a class offering. There is an error on the Add Registration Alternate form, I accidentally left the tblClassOffering linked in the query for the Class Combo...

You wouldn't ever interact with a table directly. You would create a form to add classes. You also would have to add a class offering. A class and a class offering are different, IIRC.

I do have a knack for trying to make solutions to problems harder than they need to be :) Also, in the end everything will be compiled and in an executable DB....so if there is some way of doing it, it would probably fail now that I think about it.

lol...but that would be too simple! Yes that should work just fine.

So I am working on a report builder for my current database. Basically it will let you choose a variety of things which will generate a SQL WHERE clause to use to modify a base report prior to opening the report. So I have several things that I will be able to filter by. E.g. Product Type...

ControlName.Value = AccountNumber Preface ControlName with the Form, SubForm, etc. notation. Here is a handy reference: http://access.mvps.org/access/forms/frm0031.htm

Yeah I had fixed that part, but I still needed all of the other parts listed which were not necessarily associated with a customer. I got it working though.

Okay so I thought this was right, but it's not. This works fine if a customer has all three discounts, but not if they just have one or two, or none. For instance, I added a customer discount to a part, but it doesn't show up in the final query. It doesn't show up if I give a Tier or Region...

Ahh! Thank you very much for your help. I see where I was screwing it up.

I have a DB which has several tables that I need to be able to combine into one for reporting. I have a sample DB that I have posted. Here is the basics: Tables: Part Customer Tier Region CustomerDiscount TierDiscount RegionDiscount Part table holds information about parts including...

Well you should have something like a registration table. It depends on how your data is, but the way it is now - yes based on ClassID you would know which Session and which Period it is for - that isn't necessarily the best way to do it. Each ClassID should only appear once in a normalized...

Classes should have: ClassID (Can be autonumber if you wish) SessionID (This should match the ID from your Session table) PeriodID (This should match the ID from your Period table) ClassName I don't even know what the Yes/No is there for. To assign a student to a class you would need a table...

Ahh...there's lots of issues. First, it looks like your Classes table doesn't have any foriegn keys setup, the StudentID is an AutoNumber in the Student table, but elsewhere it's Text - that creates errors and you can't generate the necessary queries to do your updates.

Your query only looks at one table, so it's just going to update that table - that won't let you select what classes someone is in. It's simply setting a check box to true/false in the Classes table.

Yeah so say you are generating a price list for September. If there is a September date in the discounts, that makes that discount effective - takes the most recent discount entered. If no September date, then no discount for the month, just 0. I think I got it - I didn't replace the missing...

Been working too much, can't figure this out. I have a part table that has info on parts. I need to combine this with 3 other tables that have various discounts. Each part can have a discount for a Region, Tier or Customer, or all three. There are multiple Regions, Tiers, and Customers. I'm...