Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba - Access Setup Question
Hello I have an Access Database containing a table called Employees which has
a large number of records and various other fields of information. A few of these employees are trainers, now what I'd like to know - is there some way to make a new table only containing trainers depending on who is a trainer. I can grab all the employees and just go through the record set in vba checking if each one is a trainer and if so get that records details, but this seems like too long a loop when perhaps Access could do it for me. is there any way to perhaps make a new table and only contain records from employee where record isTrainer. So fill my table automatically so I don't have to reenter employee details that already exist in table employee. I don't really use databases that often so perhaps this is a rather "newb" question. Thank you in advance for any help. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba - Access Setup Question
Oops, Doesn't matter, I can just use SQL Statement "WHERE"
silly Nathan. Thanks anyways, still would be nice to have trainers also in their own table, so i can just get them all but I can just use WHERE. "NateBuckley" wrote: Hello I have an Access Database containing a table called Employees which has a large number of records and various other fields of information. A few of these employees are trainers, now what I'd like to know - is there some way to make a new table only containing trainers depending on who is a trainer. I can grab all the employees and just go through the record set in vba checking if each one is a trainer and if so get that records details, but this seems like too long a loop when perhaps Access could do it for me. is there any way to perhaps make a new table and only contain records from employee where record isTrainer. So fill my table automatically so I don't have to reenter employee details that already exist in table employee. I don't really use databases that often so perhaps this is a rather "newb" question. Thank you in advance for any help. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba - Access Setup Question
hi
if i understand correctly, i think it might be better if you did this in access. access has a "make table" query that would be perfect for what you want. regards FST1 "NateBuckley" wrote: Hello I have an Access Database containing a table called Employees which has a large number of records and various other fields of information. A few of these employees are trainers, now what I'd like to know - is there some way to make a new table only containing trainers depending on who is a trainer. I can grab all the employees and just go through the record set in vba checking if each one is a trainer and if so get that records details, but this seems like too long a loop when perhaps Access could do it for me. is there any way to perhaps make a new table and only contain records from employee where record isTrainer. So fill my table automatically so I don't have to reenter employee details that already exist in table employee. I don't really use databases that often so perhaps this is a rather "newb" question. Thank you in advance for any help. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vba - Access Setup Question
You could bring them all back into a recordset and filter the recordset as
and when needed. -- __________________________________ HTH Bob "NateBuckley" wrote in message ... Oops, Doesn't matter, I can just use SQL Statement "WHERE" silly Nathan. Thanks anyways, still would be nice to have trainers also in their own table, so i can just get them all but I can just use WHERE. "NateBuckley" wrote: Hello I have an Access Database containing a table called Employees which has a large number of records and various other fields of information. A few of these employees are trainers, now what I'd like to know - is there some way to make a new table only containing trainers depending on who is a trainer. I can grab all the employees and just go through the record set in vba checking if each one is a trainer and if so get that records details, but this seems like too long a loop when perhaps Access could do it for me. is there any way to perhaps make a new table and only contain records from employee where record isTrainer. So fill my table automatically so I don't have to reenter employee details that already exist in table employee. I don't really use databases that often so perhaps this is a rather "newb" question. Thank you in advance for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print Page setup question | Excel Discussion (Misc queries) | |||
SETUP MARGINS QUESTION | Excel Discussion (Misc queries) | |||
Access Form In An Access Report (SubForm) Question | Links and Linking in Excel | |||
Sort & Page Setup Question | Excel Discussion (Misc queries) | |||
OLE Page Setup Question | Excel Programming |