Recent content by JAES

Thanks, I actually haven't used junction forms before so I have some reading to do before I can finish this part of the database. I've been working on other areas and will get back to this next week. Thank you again for all your help.

The forms only need to be done annually. If it is done during the fall season then it carries over into winter and spring. By making the tForms table like you suggested that took care of trying to carry it forward. It's either done or it isn't. I have a table, tAllSportsList that has Sports...

Thanks dhookom, I'm changing over the structure as you suggested. On a subform I show the status of the forms, which I have, and the sport they are playing under Fall, Winter and Spring label headings. I would like this to be where the assistants enter the sports they are playing. I'm not sure...

I tried to send you a copy of the current sub form that uses the tActivities table. I'm not sure how to attach it to this message.

Not too late at all, thanks. So tActivity would hold only the sports they are participating in and tForms would hold the information on the status of the forms, etc. The forms only have to be completed once a year so tForms would only have one row per athlete? Can I still use the combo boxes and...

I’m having problems printing a report from a set of combo boxes. I don’t know if it is even possible with the current table structure. Table tActivities have columns that include StudentID, FallSport, WinterSport, SpringSport, ConcussionForm, ActivityForm (this particular report shows the...

Thanks Duane and Andy. I had changed the value of StudentID to String but didn't change the declare statement. The latest code works great by changing the declare to string. It's amazing how much you lose not doing this for 7 years. Hopefully this will wake up some memory cells! Thank you again.

I don't know what t say. Here is the code. It is the click event for closing the form. I need to populate the other three tables with only the StudentID. This code does that. If something goes terribly wrong later I will know where to look! Private Sub Command116_Click() Dim StudentID As...

OK, all of a sudden this works - DoCmd.RunSQL "INSERT INTO tActivities (StudentID) VALUES (StudentID)". My StudentID was 7 digits long and I had them formatted as Integer. One of the few things I did was change them to Text.

Run-Time error '3134' Syntax error on Insert Into Statement. I'm trying different tables and different fields and the result is the same. But the Me. statement always has the data I'm trying to insert.

Thanks Duane, It still has an error and the line is highlited. The Me.StudentID has the correct value though. The table I'm working with currently is named tActivities. Once I get it working I will use is other places. Private Sub Command116_Click() DoCmd.RunSQL "INSERT INTO tActivities...

I've been away from Access for years and simple things seem to baffle me. DoCmd.RunSQL "INSERT INTO tStudents (StudentID) VALUES (StudentID) " The Student ID is an Integer. As I close the current form I want to insert the StudentID value into the table tStudents Column StudentID Any help is...

Sorry, I was away for the first part of the week. Yes, all filters are vEvent??. When the volunteers fill out a form they check which areas they can volunteer in. For the reports I use the vEvent?? in my where clause. A table would be the best way to go now that you mention it. Unless you have...

I'm having some problems understanding the SELECT...CASE structure. I've tried a few code lines in the header format event from examples but I'm just guessing. If the field vEvent1 is yes in table tabVolunteers I would like the title (test box or ?) of the report (rptVolunteerByCatagory)to say...

OK Thanks. I'm reading up on the Select Case function and I'll see if I can figure it out. Just another feature I didn't know about!