Search results

I should also mention that an additional problem is that each team has several employees assigned to it. I would like to create a record for each individual employee instead of one record per team. What i have so far is a form to create a new training item and a continuous subform in it so...

I believe this can be done with a query, but am having problems with it. What i have is a db with a table for employee another table for training items and a third table to tie them both together. These employees are divided into several "teams" (team 1, team 2 etc ...) The training items...

that was just a simple example of what i am trying to accomplish. The data that is being copied is an employee id # and an item #....will search the db thanks for leading me in the right direction Ricky

Hey guys, I have a problem which i have seen discussed here but none of the solutions seem to work for me. What i want to do is simple. I have a form named frmName, this stores last name and first name. I have another form named frmAddress this one stores last name and address. What i...

not sure where this should go so i stuck it under reports. My db automatically exports my reports to html format using a template i designed. The problem is that the size of one of the fields is too small. I changed it in the template but still the exported html report has the original small...

Hi, My problem is that i have 4 reports that are generated with a macro. We would like to have these reports exported to HTML format. I know i can do it manually, File, export, etc... but is there a way i can have a code or macro do this automatically for all four reports at a push of a...

first of all let me thank all of you for your continued support through my struggles with access. Sometimes i dont think i will ever get as good as i would like to with it but i keep pressing on here's my latest delima: I have 4 areas with 7 teams per area. Training is assigned to all or...

thanks will look into that Ricky

Hey guys, a quick question. I have a form called "FormA" within that form i have a tab control and one of the pages is called "Page1" inside that page1 i have a subform named "subform1" and finally inside subform1 i have a field named "field" what would be the correct syntax to reference...

Pat, just one more quickie. By following your example and from what i understand from your post. The best way to assign the trainees to the training item is to use a subform instead of check boxes, is that correct? Ricky

That makes sense... i will give it a try, thanks Pat Ricky

What i have here is a training db. It tracks training for the FAA. Problem is there are 6 teams of employees and not all teams get the same training items, sometimes everyone get it sometimes only team 1 and 3, etc... i decided to do this with a check box so when the data entry person enters...

YOU ARE THE MAN ! ! ! thanks alot really appreciate it and thanks for the quick responses.... Ricky

makes sense but i am not sure how to make that calculated control, would you mind being a little more specific?? i hate asking questions like this, but i guess it will be the only way i learn thanks again Ricky

Not sure where to put this so I placed it in the general section, hope thats right. My situation is I would like to store a different data instead of a yes/no with a check mark more specifically, when the check box is checked i would like to store the code "0100" in a different field. I...

thanks len will give it a shot

hi, I have a database that tracks events that happen periodically. My problem is that we need to generate a report that includes data from the latest event. For example, we genereate a "Tapetalk" to controllers on different cycles, some of them every 6 months and some might be monthly. Also...

will give it a shot thanks

I have a similar problem and the suggestion works great, but my problem is a little more intense... I have a db for an elementary school, i created a query that will print out a "teachers list" of all the students.... the report is sorted and grouped by teacher so i can have a different...

I have a form, within this form i am using a Tab Control to allow me to have several subforms within that main form. Works great except when i try to reference a control within one of those sub forms Main form: frmStudentInfo subform on a Tab Control: subfrmParentInfo...