Recent content by ebarrera

Okay so I was able to come up with a function that counts working days minus the holidays, but I don't think that this is the best solution to my problem. It takes forever to complete with 3000+ records. If anyone can come up with a better way to tackle this, I would appreciate...

Thanks Galaxiom and DCrake, I will look at these and report back.

Hello everyone, it's been a while, anyways, I've been trying to tackle this on my own for about a week and can't seem to solve this. Anyones help is much appreciated. I have a query that calculates how many meetings a course meets per month depending on the start and end dates and the...

Forgot to answer the 2nd question, I am using CutePDF. I change the printer thru the function called ChangeToCutePDF that was in the code that you referred me to in an earlier post. I actually preview the agreement before I decide to print to pdf. We have a shared drive which contains...

Thanks, it makes sense, the data cannot exist until you open the report. I also thought of declaring a variable (as string) and passing the value to it, but do not know the syntax for this. I tried the following code and did not work Dim newCaption as String newCaption = Queries!Faculty...

Thanks HiTech Coach, I was able to change the printer and hard code the caption by assigning the caption to a string ("test") and it worked. Except that I want instead of the string I want the value tha is on the report. The text box on the report is called PdfFileName and the source is called...

Sorry to have to repeat this question, but I have spent about a week trying to figure this one out. Here is what I need my database to do. I created a database in Access 2000 and am currently working on it in Access 2002. The database generates agreements for each faculty member in our...

Aw man, you posted before I could post the answer. Thank you anyways pbaldy.

Sorry guys, I figured it out and properties had the answer. I needed to set Vertical to "Yes".

I am working on a report in MS Access 2002 that resemble an old report done in Excel but cannot format a label to ensure the report stays on one page (landscape). In Excel, the properties of the cell can be modified in order to have the orientation set to 90 degrees. By default is set to 180...

Great, this means it is possible...I will need to do some research as I have never done a sub report. At least I now know what it is called.

I have two queries, one that has Faculty Assignements and another table that has the Faculty Assignments Detail of each course. I created a field called [FacultyCourse] which is FacultyID & Assignment. table FA does not have duplicates in [FacultyCourse], while table FAD does. I need to...

Thanks ByteMyzer, will try and let you know if I get the same result...always better to complete in one query versus three.

Firgured a way of getting what i wanted...created a table with method orders, Lec = 1, Lab =2. Then did a query to list method orders. Grouped them and got [FirstOfMethod Order]. Did another query and where I only have the course and a field called [Finals Method], where I convert...

I am looking to get a main instructional method for a each course that exists in a query. I query a table that has all the assignments which gives me duplicates. I grouped them to get a short list with a few duplicates if the course has two instructional methods (i.e. Lecture & Lab)...