Recent content by Zippyfrog

Is there a way in Access that when I print a report to PDF that every page can be a separate PDF file? My scenario is I have 30 pages for 30 different people, each person getting one page that is personalized to their data. Instead of me printing to a PDF then having to manually create 30...

Thanks for the advice! I got it to work.

Hi - I am trying to remove duplicate rows in a report. The thing is that the row itself isn't truly a duplicate. What I have here is a report on how a student did on a math test. I want to create a report that lists out all the skills that were missed. Each question is tied to a specific...

You guys are incredible! Thanks so much - this is exactly what I needed!

This looks like the simplest solution. How would I make this appear on a report? I currently have a textbox on my form. What event would I add the VBA to?

Thanks for the help on my other question for my report! It is working beautifully because of all the help everyone provided me with. One more question - how do I make a text box on a report have the date/time a file was last updated? My situation is I have a file called grades.csv that is...

Thanks - I didn't think of that. Great idea - I am going to try that! I tried creating a different sub-report for each period, and with 8 different periods it was causing Access to hang. Exponentially long to load. When I had 3 or 4 periods it worked fine, but by the end it was too resource...

Pat - thanks for this! Very helpful! One other question... using the exact same set of data, how would I create a report that would have the row headings are periods, the columns are the students, then the intersection of the rows and columns would have what class a student is in for a given...

Thanks ridders. That is what I have done. Attached is a sample with 4 students. This form was created in 60 seconds, so it is very ugly - just trying to convey the idea. The first and 4th student both have 1st period BC Calculus. What I want to have the report do is group the students...

Hi - I am trying to create a report for our student body that lists out student schedules by student, then groups based off of first period class. The purpose of this is the first day of school we want to hand out a paper copy of the student schedules, and we want the printouts organized by...

Thanks, but that doesn't do what I want. Basically the data I have is exported from a database, but it puts every piece of data in it's own row. The end result I want is basically a pivot table where I can have the data appear instead of a summary count of the data. Right now when I do it, I...

Hi - I am working with data where the program I export from puts all the data in rows, but I need it to be in columns. Is there an easy macro or command in excel to do this? Basically, for every row where the user has identical data, I need to put it in a single row so I can do an e-mail merge...

Oh my goodness, thank you so much! That second example is exactly what I was looking for! Although my data doesn't show it, sometimes the numbers are - 13 or larger numbers, so always going off of that last hypen is exactly what I needed to have happen. I don't remember the reasoning for the...

Here is a sample from my data last week. Working at a school, these represent courses and the last "space hyphen space number" in very back needs to be deleted. And just the very last space hype space number needs to removed. BBL 12 CLTR - 1 BSN ECON/PER - 2 ENG AP ENG 1 - 4 MTH APCALC-1 - 3...

So, if I understanding you right, would my function look like this? Cells(r,4) = trim(left(Cells(r,4),Instr("~~",Replace(Cells(r,4),"-","~~",len(Cells(r,4))-len (Replace(Cells(r,4),"-",""))))-1)) I tried that and I get an invalid procedure.