Search results

Rich, Thanks for your reply. I thought of doing Attendance as a subform of Enrollment but I wasn't getting it to work the way I wanted. But you're right that makes the most sense. I'll try playing around with it again.

Hello Everyone, I have a main form, "Classes" with two subforms, "Enrollment" & "Attendance". Both subforms are linked to the main form by section ID. The Enrollment subform has an autonumber "EnrollID" and also a field for SSN. The Attendance subform also has an EnrollID field (to link to...

I use a similar code on checkboxes and I called the code from the OnExit event. You might try that...it worked for me.

Thanks for you input everyone. Capilano, I do want to update the table every time the letter is run. The report is actually a letter that will be mailed to a recipient, so the letter won't be pulled up until time for mailing. So we just need to know who's been sent a letter and who hasn't. I'm...

Hi Everyone! I have a report called Confirmation Letter based on a parameter query. The parameter asks for Section ID. I also have an update query based on the same parameter query. The update query updates a date field in my table, called ConfirmLetterSent, with the date the report...

Harry! I don't know how to thank you! This seems to be working beautifully! Now that you've explained it to me I can see what I was doing wrong. Thanks again--this forum is a life saver!

I am beating my head against the wall and just can't figure out why this isn't working. What I'm trying to do is compare the yr, sem, and modID of a new entry with previous entries. If there's a match, increment by one, if not then it's the first record. I keep getting "Invalid Use of Null"...

Thanks for all your help Matt! In my tables, ModuleID is an alphanumeric field--for example "4E". The data entry for the date in the form is short date (MM/DD/YY) but the Year(session) gives the 4-digit year and that's fine. So the first part of my code goes like "2001FAM4E-{incrementing...

No error message--it's just not incrementing. My number always ends in "-01" no matter how many entries I make.

One of these days I'll figure out how to code on my own! I really appreciate all the help I get from this forum. Here's my latest problem: I have a field that is generated from 2 other fields-a combination of date and module id. I need to be able to compare the date and module id of a new entry...

Sorry I should have done that to begin with. Here is the original function: Function calcsecid() 'capture the year of session 1 date as yr and label the fall and _ spring semesters according to the month of session 1. Combine _ yr, sem, and module id to create the section ID field. ModID...

Does anybody know what the error message "out of stack space" means? I have used code to create a field based on two other fields. I am receiving the error message when I try to call a subroutine that will increment this field by one. I can't find any reference to this message in the help files...

I am trying something different: Sub ReplaceID() Dim calcsecid As String Dim strPhrase As String Dim strOldValue As String Dim strNewValue As String strPhrase = calcsecid strOldValue = Right(calcsecid, 1) strNewValue = (Val(Right(strPhrase, 1)) + 1) strPhrase =...

I think you are right, Doug, that it's because I'm trying to combine the string and value. Maybe I'm going about this the completely wrong way, but I'm sure there must be a way to do it! Travis, I am getting the error when I attempt to enter data in the form. If I do not call the loop and just...

Thanks for your help Travis, but it is still not working. I still get the Type Mismatch error. Any other suggestions????

I have written this function to automatically "calculate" a field based on two other fields. Therefore, CalcSecID is a string. This code works perfectly..... Option Compare Database Dim yr Dim sem Dim ModID Dim session Function CalcSecID() 'capture the year of session 1 date as yr and label...

Thank you Avaughan! That worked great!

I hope someone can give me some assistance as I am new to programming. I have a table in Access with the following fields: ModuleID, SectionID, SessionDate, Semester. What I'm trying to do is combine the Year in SessionDate, Semester, and ModuleID to automatically create SectionID. For example...