Search results

Paul, Ok Try this...I tested it real quick and it seemed to work. Dim lngSum As Long Dim intCurrentRow As Integer lngSum = 0 For intCurrentRow = 0 To Me.lstSicknessCount.ListCount - 1 lngSum = lngSum + Nz(Me.lstSicknessCount.Column(2, intCurrentRow), 0) Next intCurrentRow...

Try changing this line to: lngSum = lngSum + Nz(Me.lstSicknessCount.Column(3), 0) This will make any null values a 0 and then they will sum. hth Carmen

I found this in the MSDN Knowledge Base. I have used it and it does work but the printing is VERY slow! Or maybe it was just my printer! Article 231805-Using Code to Collate and Print Two Reports

I usually add a command button to my form and let the Wizard build the Open Report code then I modify the code to add the linking criteria. For example, if UniqueID is the field that links the info on your form to your report you could add a line to the open report code like: Dim stLinkCriteria...

Try going into the Design View of your report and checking the Sorting and Grouping options there.........

Hi All, I have a report with only one field on the main report itself and it has 2 subreports. The field on the main report is "SchoolName" and the subreports are linked to it by this field. I force a new page before "SchoolName" on the main report so that each school's data is on a separate...

Travis and Harry...You guys are awesome!! The looping part works and Harry's trick with the ModNbr was just the ticket. Thanks so much for your help! Carmen

Tim, I tried your solution, but what I was afraid was going to happen, did happen! By comparing the SSN I get the message box if a teacher has taken any classes, not necessarily the same one that is being entered for a new enrollment. It really needs to compare the ModID...... I appreciate the...

Thanks for your help Travis, but still no luck........ I see what you are saying about the FindFirst, and I added the MoveFirst line outside of the loop like you said, comment the MoveNext line, and then tried to change the FindFirst line to just Find and I get the "Method or Data Member Not...

Hi All, I am racking my brain trying to figure out this loop... Set rst = CurrentDb.OpenRecordset("ModuleStartDates", dbOpenDynaset) mysearch = "[SSN]='" & Me.SSN & "'" Do rst.FindFirst mysearch ModID = DLookup("[ModNbr]", "ModuleStartDates", mysearch)...

Thank you Rob!! Worked like a charm

Don't know if this is possible, but here is what I would like to do.... I have a database with teacher information and classes that they take. All teachers have a school e-mail account and when they register for classes they are required to use their school e-mail account for communication. The...

I just did something real similar and this might not be the best method but it works! I made 2 labels with the 2 different captions I needed..in your case Label1 = "Refund", Label2 = "Correction Form". I set both visible properties to No. I put the labels one on top of the other so that they...

Thank you so much Pat, the IIf statement worked like a charm! You are a genius!!

Hi All...I will try to explain this in an understandable way.....I receive a monthly update of classes taken by employees on the 10th of every month. Then I print a report for each employee showing which classes they have taken. The report has a header like "Classes taken as of____" and the...

Thank you both for your help...and from both your answers I was able to figure out my problem (and with the help of running a Union Query). Seems like when I did the Input Mask Wizard in the tables, in one table I was storing the SSN with the dashes and in the other table I was storing the SSN...

Thanks for your response llk! The SSN in both tables is text and I'm using the Input Mask in both tables. The join I'm using is an inner join...only return records where the SSN in both tables match. However, when I change to a left or right join, it still doesn't work! This thing is driving me...

I cannot figure out why my simple select query is not working! I have a db with a table "Participants" and the primary key is SSN. I have linked to a table "Tests", which is in another Access db, in which a foreign key is SSN. In my Relationships window, the relationship shows as one...

Alex, Thank you for your reply but I'm not sure that's exactly what I need. The 3 exam part fields are text where I would enter either a "P" for pass or an "F" for fail or "N/A" and then I have one date field for the date of that exam. So if a person needs to retake a part of the exam they...

Hi All, I have a table called PassedExams that have fields for SSN, ExamID, Oral, Reading, Written, ExamDate. There are only two exams but each one has the 3 parts to it (oral, reading, writing). They are pass/fail. If a person fails one (or more) parts, they can retake those parts at a later...