Search results for query: *

Hi, The reason I've gone with the 'option group' layout is that these 2 reports are just the beginning; it's very likely that there may be 10 - 12 different reports (all producing different output from diffrent query sources); this layout allows me to have a 'neat' list of reports on the left...

Hi, I have a form which has two option groups, and a command button; form: Report1 ------------- OptionGroup1 OptionGroup2 [] Report_name1 [] PreView (current) Report [] Report_name2 [] Print (current) Report {Commandbutton} The user selects report1 or report2 and...

thanks PHV, you've cracked it!! ;-) mrP.

I still have a problem! Thre are 75 courses listed in my course table; It would save a lot of time if I can prompt the user to type the course [criteria] name (into the query) instead of having 75 separate queries; so far my SQL code looks like this but this doesn't quite work, please could...

we're nearly there, but still having problems!!; I've amended the SQL to use the classNAME (rather than the ClassID) as the identifier, but the query still finds 3 students who have attended the course "critcare3". Is the studentID being pulled from the correct table I wonder? Also could the...

Hi folks, i'm having a mental-block day. I have a query which holds 3 tables [from an education database]. Table 1. [courses] ClassID Classname Table 2. [course_dates] CourseDatesID ('uniqueid') ClassID ('linked to classID in table 1.') DateOfCourse Table 3. [students_and_courses]...

Thanks PH, Your alternative method solved the problem nicely! Mucho Gracias MrP

Hi Geoff, The problem seems lie in the fact that there are two tables (linked by a 1-2-1 join), in the QBD; which causes the delete query to throw up the error message "specify the table to delete from" when a run query is initiated. mrP

Hi folks, maybe i'm being dense(?!), but i need to delete 596 records from table #A using a list of corresponding record id's held in table #B as the criteria. So far Access won't allow me to run a delete query to perform the task. (In other words both tables have identical record id formats...

Hi folks, I know this is probably an old chestnut; but could somebady please suggest a way of converting a time field in a Dbase 4 table (in the format "nnnnn" eg 16590) into an access time format of 15:22hrs? Ie I'm importing a Dbase4 table into an Access 2003 database using the "get External...

Hi Ken, I've tried both code lines but both return the following error code; Microsoft Access can't find the field 'VisitDetailsSubform' referred to in your expression. Any ideas? MrPiccolo

I've looked at the FAQ solutions but have not found a suitable answer for the following problem. please help! I have 2 tables; table 1. "Patients" patientID (Pk) other fields.. table 2. "Visits" 'shows visit data about each patient' VisitID (Pk) PatientID 'long integer, linked to "Patients"...

Hi Guys, we’re nearly there! Thanks for all your hard work. Bill, here are the main subroutines I have for my mainform and subform in my database that records data on Patients presenting to hospital with Abdominal Pain. Please see my question at the end of the code listings: “Frm_visits”...

Thanks Bill, However still got 2 problems! 1) The second cbo doesn't hide if the first cbo is changed back to 0 (instead of 1). 2) There are 6 pairs of linked cbo's on this subform; how do I hide all (6) dependant boxes using the on_current event line of the subform? MrPiccolo

Hi Guys, I have a subform that has 2 combo boxes on it; I want to be able to make the second combo box visible AND active when the first cbo has a value of 1. The before update event for the first cbo looks like the following; Private Sub RadiationRecorded_BeforeUpdate(Cancel As Integer) If...