Search results

Hi, I have created a database that seems to work ok now. Been a real learning experience. I now need to take information from the database and do a mail merge into Word. I have done mail merges with Excel before but not Access. I have a form designed that shows participant information and...

Hi, I have a database set up that uses a participants table and a workshop table. Each have primary keys. A third table is set up and has the two primary keys from the participant and workshop table. This was working fine. I now need another table (Presenters) to account for people who...

Hi, I developed a form, based on a table, which is working fine until now. Recently some names were entered into the form. Since their ID number is an autonumber, these new entries went at the bottom. This didn't seem like a problem but for some reason the names will not sort alphabetically...

Hi, I have developed a database that gives me information on the number of people attending college workshops and the number of workshops each person has attended. I want a total of individual people who attended workshops and then the total of people who attended multiple workshops. I ran...

Hi, I have created a form which shows all members of an institute and a subform which lists all the workshops they have attended. The form works fine. I have a combo box set up to enter a number and this brings up all the participants information including the workshop subform info. My...

Hi, I am still having a bit of trouble getting my database information to come up automatically in the form I created. I want to just type in an ID number and have all data come up associated for that particular person. Also, I would like to be able to add a new record (for someone who is...

Hi, I am trying to develop a query so that information from my table automatically comes up in a form with a subform. I have three tables: Participants Workshops and LinkWorkshops To Participants (has long int and two PK - one for ParticipantID and one for WorkshopID. Any thoughts on how...

I have set up a database with participants and workshops. I need a form which will bring up all the participants info automatically along with a subform that lists all the workshops they have attended. I want to be able to type in the participants ID number, all their info comes up and then...

How do I set up a database that has participants and workshops. One person can attend many workshops and one workshop can have many people attend. I need to have a form that brings up participant info automatically and a subform that list all the attended workshops. Can anyone help me? Thanks