Recent content by hockey8837

Sorry- I had it in an .xlsx instead of .xls- attachment should be there, now! I do have on the contact list a yes/no field for member, but each program has its own unique rates which may not apply to other programs so I'd just been storing them in the TblPrograms with all the other relevant...

So, I'm having some major issues converting this data due to the complexity of other items being tracked. I'm having a hard time combining the info with multiple records for one contact (i.e. two records when they're registering adults and children, or possibly also nonscouts). We base our...

Thanks! I actually thought about this same thing on my drive home last night and started working it around in my brain a bit with the same approach. I'll give it a shot, thanks!

Hi again! Thanks for your help thus far! Okay, so I'm trying to reformat my MMContactsPrograms table that has adults, children, and nonscouts separated (like a spreadsheet-d'oh!). Looking at doing some kind of append or update query to get those three number fields into one, but I might (and...

Just thought of something, though. I may have one person registering multiple different types of attendees. Adults Kids Jon Doe 2 3 But if I only have one "guesttype" how do I get the same details in one record? This will make record entry more...

Ahhh.... yes that makes more sense. It's going to be a pain to correct, though, I think. I've got thousands of records. :-/ Thanks!

Hi, I have a database for my nonprofit zoo. In it, we track program attendance for free programs, events, and programs requiring registration. I have a Table (TblPrograms) where we'll collect things like program name, date, times, fees (if any) and attendance. Attendance can be recorded right in...

Excellent! This worked great. Got any suggestions for my command button 'click to email' for the same report from the same subform? Here's my current Macro code: Open Report Report Name: rptScoutReciept View: Report Where: [ID]=[Forms]![sbfScoutRegDetails]![ID] Window Mode: Normal...

So, if the continuous form with my control button "cmdScoutContract" is on a subform ("sbfScoutRegDetail") within the subform "sbfScoutProgDetails", the code in VBA should be something like this..but probably not quite this because it's not working...? :/ Private Sub cmdScoutContract_Click()...

Hi, I have two command buttons in a subform "sbfScoutRegDetails", one that launches a report and the other attaches the report pdf to an email, associated with the record ID when clicked. Both of these buttons work fine when just the subform itself is open, but when viewing it in its main...

I have a form based on one table which has two cbo boxes, [ProgramFeeIDFK] & [TravelFeeIDFK], that will select from the same fee list for the same record. The user can select the fee from a drop down with 4 columns, the bound column being the id for the fee. I'm having the user enter data in a...

Hi, I'm trying to sum a couple of columns from a subform datasheet and carry them onto the main form. My main form, [frm_tours_details], holds subform [sbfTours] which is a datasheet. On [sbfTours], I've got a couple calculated fields within the datasheet, one, called "txtStudentSum", which...

Hi, Sorry! I could have been more descriptive. I've attached a zipped version of the DB. The form in question can be launched from the programs/events tab ([Print Program Attendance] control). The append query and the appended table are in the 'reports' section of the navigation bar. I've...

Hi, I'm trying to filter an append query by a year selected in a combo box [cboYear] for a field [ProgramDate]. The AfterUpdate on the cbo filters the append query based off of the selection (or selections-I'm using multiple combo boxes on the form). I then run a report based off of the appended...

So, the programs report would pull names for the [programtype] of 'special events', and [programname] would be 'boo at the zoo' or 'noon year's eve. Or, another [programtype] would be 'family programs', with [programname] having 'zoo kids', 'family workshops,' or 'baby and me' etc... The DB I...