Recent content by Accessible92866

No, I'm trying to add a new class in the main form.

I've written a db in Access 2007 to track enrollment in our safety training classes. I have a main form for the basic class information (date, instructor, location, etc.) and a subform for students enrolled in that class, connected by the ClassID field (an autonumber in the Classes table, a long...

Gentlemen, I've tried all your suggestions and unfortunately, still no luck. Yes, [MeetingDate] is in the page header, as are PriceLabel_Regular and underneath it, PriceLabel_Special. These are the labels located under the Amt Paid box. (See attached gif graphic of the header area.) I...

Hello all, I have a report in Access 2007 that generates a sign-in sheet for monthly club meetings. Normally, the cost per meeting is $25 for members and $30 for non-members. However, this month is a special dinner meeting and the cost is ten dollars higher--$35 for members and $40 for...

As an experiment, I tried Select Case and obviously did something wrong since it didn't work...and then I followed your suggestion about keeping it simple, used IF and hurray--success! Someday I want to get Select Case to operate correctly and I was intrigued by the DLookup answer you...

Turning to the expert minds for help... Upfront note: I have been writing databases for years but haven't really gone beyond basic macros for automation. I'm not a programmer and have very little experience with VBA, so if you explain things as if you were talking to a small child, I won't be...

Thank you, RG. That got me started in the right direction. I went into the row source for the second combo box (Subdisciplines) on the subform and used the Build button to let it build the name--and it worked. No errors now plus a populated drop-down list. Slogging onward...:-)

Hello all.:) In Access 2003, I have a form that contains a subform which has two combo boxes. When the first one (Disciplines) is changed, the second one (Subdisciplines) is filtered (on key field DNumber) to show only the subdisciplines within that particular discipline. As a note, not all...

Thank you, Les. This will help a lot when I get to the reports (I'm slogging through input forms at the moment). La muy agradecida, Geekette in SoCal (I lived in Spain, too...looooong ago and far away):)

Thank you, Alan. What wonderful resources these are! They're giving me some different ideas about how I might structure the forms. Still need to find more info on multiselect list boxes. Can't think of another way to display the several subdisciplines within a discipline that a company might be...

Hello all. Let's see if I can explain this coherently... I'm writing a database to track construction projects. Companies respond to an RFQ, with a separate application for each discipline (there are 11 of them, such as General Civil Engineering, Cost Estimating, Architechtural, etc.). Each...