[AccessD] Form Sub form Problem

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





More information about the AccessD mailing list