Joe Hecht
jmhla at earthlink.net
Fri Nov 19 12:22:33 CST 2004
The cross rookie programmers? Joe Hecht jmhla at earthlink.net 28g -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Nicholson, Karen Sent: Friday, November 19, 2004 9:53 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Form Sub form Problem They do things a little different in California, I hear. Maybe it is for the cross-whatevers to accommodate their two identities. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, November 19, 2004 12:31 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Form Sub form Problem Yes, and I was formerly a Vice President/Corporate Secretary, but that wasn't considered more than a single title. Charlotte Foust -----Original Message----- From: Colby, John [mailto:JColby at dispec.com] Sent: Friday, November 19, 2004 8:50 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Form Sub form Problem Many years ago I bought a library of functions for Turbo Pascal (I believe) - the person who wrote it had the title(s) President and Chief Bottle Washer. John W. Colby The DIS Database Guy -----Original Message----- From: Charlotte Foust [mailto:cfoust at infostatsystems.com] Sent: Friday, November 19, 2004 11:39 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Form Sub form Problem Are they paying them many salaries as well? Unless they're storing a job history, many titles doesn't make sense to me. Charlotte Foust -----Original Message----- From: Joe Hecht [mailto:jmhla at earthlink.net] Sent: Thursday, November 18, 2004 11:11 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Form Sub form Problem The Situation On an inherited database the client has a single Employees form that lists the with a text box for job title. They want to have one employee with many job titles. I am trying to add a sub form continuous view with a combo box. SELECT stblEmpJobTitle.EmpID, stblEmpJobTitle.JobTitleID, [Job Title].JobTitle FROM [Job Title] LEFT JOIN stblEmpJobTitle ON [Job Title].JobTitleID = stblEmpJobTitle.JobTitleID WHERE (((stblEmpJobTitle.EmpID)=[Forms]![Employees]![EmpID])); I need to not only show current job title but also assign new ones. When I go to the next combo box it already has the existing job. Looking for some help here please. JOE HECHT LOS ANGELES CA jmhla at earthlink.net -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com