Search results

That has already been verified as correct. Which is why I don't understand why it is not working properly.

I have 2 reports that both have a user input StartDate and EndDate. Both reports use the same date ranges. The both work fine and do report the correct data. I have a report#2 in a subreport in report#1. I think it created a separate query, because I now get 3 date range pop-ups. This in...

AWESOME!!!! Thank you so much. I have spent 1.5 days on this already LOL Thank you again!

I don't have a Total option in my query...I am on Access 2003

I'm not sure what you mean by group by van#. I can add a pop up that asks for Van#, but that will only return 1 van. ALSO, I only have 1 date field, which is the use date of the van. For this purpose how do I filter by a date range?

I have a vehicle daily log table that shows Van# and Daily Mileage. I am working on a report that shows the total mileage per van per date range like so: Van1 Total Mileage Van2 Total Mileage I'm not sure how to proceed with this. All my attempts so far are not good. All I can get is all...

OK, good to know. The case stmt seems very easy and it's less work :) Thank you for your help.

EDIT: I just changed: Select Case Me.CourseEnrollment.Column(1) to .Column(0) and it works.

Ug, the case is not working Private Sub Form_Current() Select Case Me.CourseEnrollment.Column(1) Case "Residential Inspector Multi-Discipline" BoxExamPrep.Visible = True BoxBldg.Visible = True BoxMech.Visible = True BoxPlmb.Visible = True...

So the 1 in Case 1 represents CourseEnrollment = " "?

I did get it to work using the event on the form: Private Sub Form_Current() If CourseEnrollment = "Residential Inspector Multi-Discipline" Then Me.BoxExamPrep.Visible = True Else Me.BoxExamPrep.Visible = False End If End Sub Which does seem to be working. I don't know the case...

The test worked wonderfully, but not at all in the real environment. This is for a student db. The student is signed up for a range of class programs. Each program has certain classes. I had it setup with conditional formatting, but it was super buggy (refreshing all the time, which I find...

Awesome! That did it. I had never heard/seen that before. Thank you!

That doesn't work either. My thinking is that there is something wrong with: If Combo33 = "Class 1" Then

I'm sorry, that is what I meant.

I am having trouble with this. I have a combobox that you can select: Class 1, Class 2 or Class 3 When you select Class 1, I want a check box turned visible. I have tried various If stmts: Private Sub Combo33_Enter() If Combo33 = "Class 1" Then txtClass1.Value = True Else...

Would I just replace the IF stmt with the the case stmt?

What it does, is it sees if the President was the one teaching the class and if yes, then it pulls the certification merge doc that only has the president's signature. If the teacher and the president are different, then it pulls the cert with 2 signature lines. They now want to change it so...

ok, all of this has been tried and it its still not working. There must be something else I am missing. Thank you for your help.

Is there a way to check to see if it is set to grow? I can't find the error in the logs, but it said something to the effect of file size error - but I can't remember exactly