Recent content by Mrs.Smith

Did you manage to work it out using your SSN field adjustments?

If you want a prompt with the option to search for other app names, use this sql with the set up i described above. SELECT [t_Event Query].* FROM [t_Event Query] WHERE ((([t_Event Query].App)=[Enter App Name]));

I'm assuming that each record will always have a name, a tier and an app associated with it...

your tables are not set up right. i rebuilt your basic platform a different way and got the results: here's what you need: 1. table for Apps - fields: AppID, AppName - (appA, appB, appC) 2. table for contacts - fields: ContactID, Name - (Smith, Bob, John) 3. table for tiers - fields: TierID...

Private Sub Report_Close() DoCmd.OpenReport NewEntriesPrintoutReport, acViewNormal End Sub ?

Wait.. I'm going to rephrase my question - instead of defining a separate page size for the last page, because it's just a blank form, i've created a separate report/printout with this page. So, my new question is.. how do i have the first report (on close) print the second report?

I need to have the last page of a report in access print to an 8.5x11 instead of 11x17 (the rest of the report has to print 11x17). No clue how to set it up so it's automatic... any one out there know how?

hmm... you wrote: ... then you showed the code: ... But there is a table number discrepancy - try changing the table1 to table2 first, then post back if that's not the fix.

I took a look at your screen shots, as well as your stripped down database upload... Are your Contacts and Instructors the same thing?? Why else would you be pulling ID from Contacts into Instructors?? Or are Contacts something different - does contacts encompass MORE than just Instructors...

Hi Pat, Yes, i know the correct solution, but as I mentioned before, i cant change the way it's set up. But it's ok - I actually figured it out earlier this morning. :) All worked out. Thank you though! I created a query based off a query and a table with an inner join on last name, unique...

I figured out the sql statment for contacts1 for both involved and not involved participants - got the contacts2 sql statment for involved, but not uninvolved - for some reason with uninvolved sql i'm having a mismatched datatype issue.. :s any way around that?

Hi Pat, Yes, i know it's bad form, I mentioned exactly what you said to the owner of the database earlier this week. I didn't design that aspect of the database - just trying to keep the data intact and avoid a complete redesign for the owner ... it's definitely not ideal to work with though. :s

... Maybe i just need a union select query with a where clause.... ?

How do I collect and calculate data from two contacts tables (lets call them Contacts1 and Contacts2) that are not related except for their relationship with a third table (ParticipationTable)? I need to list all participants on the Participation (omitting duplicate entries - because any...