public Vector<String> getActiveAgentIds() {
		
		Vector<String> agents = new Vector<String>();
		try {
			rs = stmt.executeQuery("SELECT agentid,agtFirstName,agtLastName FROM agents WHERE agtposition <> 'Inactive'");
			while (rs.next())
			{
				agents.add(rs.getString("agentid")+" - "+rs.getString("agtFirstName")+" "+rs.getString("agtLastName"));
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return agents;//the method returns a vector of agents
	}