Search results for query: *

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...

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]...

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...

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, 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...