Search results

Well, I went ahead and did the append and it added everything all over again. I need it to only add unique records from my member table. For example, if I already have MemberID 2 taking ClassID 1 I don't want it to duplicate. But if I have just added new MemberID 35, I want it to append all 33...

They have to attend all classes. My objective is when we get a new member in, I can add their Last name and first name and schedule all 33 classes at once.

Yes. That is correct. I'm sorry my knowledge of Access is so limited!! :( I apreciate your patience

My macro runs fine from the macro screen, but that rascal switchboard won't run it. What command number should I be using in the switchboard items table. I tried 1,2,3,and 4.

It's the best thing I could come up with to suit my need to add someone. Any suggestions on how I could add someone and have all 33 ClassID added in Training table with the new MemberID?

Can I run a delete query from the switchboard? I get "there was an error executing the command"

I need to figure out a way to get the percentage of people not expired on training classes. I have 33 classes and I need to do either a pie graph or a chart to show what percentage of people have expired training on each class. I have fields for Member, class and expiration date. How do I set up...

Ok, Here's the a picture of some of the Db. Please no laughs. I am very unskilled at Access. What I want to do is on the switchboard. When I open it with switchboard command 2 for add to the end mode(??) it comes up with no classes listed and no name. when I click this button, I want a blank...

Thanx for replying Colin. Not exactly what i need, but close. When I add a new member, I want to pull all of the existing classes out of my Classes table and add them to my Training table with the new MemberID assigned to them. Example... In table 1 (Members) I have Member ID (AutoNumber), last...

I have created a form to pull a member name out of my Members table. I want it to be a pull down menu, like in the tables, to select the members' last name instead of scrolling thru the records. How do I do that?

Got it!!! Thanks for all of the help

I have a form to select a member and a linked subform to display the classes they are taking and when they took them. I want my subform to show all of the classes on one page, not filtered by record. I have to scroll through each individual class record one at a time or resize the subreport box...

So far no one has been able to help me. I have 3 tables. One is for Members. I have each member assigned to a unique MemberID. The Second is for classes. I have each class assigned to a unique ClassID. The third table is being used so each member can be assigned to all classes. I have designed a...

any help or ideas???

I have 3 tables. One table is for classes. I have each class assigned to a ClassID. The second table has Members assigned to a MemberID. The third table is my training list table. I tied the Member ID and ClassID to expiration dates in the Training table. Each class expires on a different day...

My request was unfortunately not based on a query. I am trying to design a form where I can add a new member with last name, first name social # (all added in my Members table) and it automatically pulls all classes from the Classes Table and puts them into the training table with all of the...

OK. I am in "tweak mode" right now. I have 3 tables. One table is for classes. I have each class assigned to a ClassID. The second table has Members assigned to a MemberID. The third table is my training list table. I tied the Member ID and ClassID to expiration dates. Each class expires on a...

PDX_Man, I apreciate the help. It worked like a charm.

I am very new to access and am creating a database for our training manager. I have all of my tables and forms set up. I can do everything I need to do except run a particular report. :confused: We have 28 people all taking 33 different classes. They all need recertification on different months...