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...
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...
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.
My goal is to get the output in the cell. Our current program throws an extra hyphen plus some random number at the back of the string, and I need that hypen plus some random number stripped off. And the value that I need cleaned is in column D, so what I do is I put the formula...
I do have one more question - how would I use the following formula inside of an excel macro?
TRIM(LEFT(D2,FIND("~~",SUBSTITUTE(D2,"-","~~",LEN(D2)-LEN(SUBSTITUTE(D2,"-",""))))-1))
This is what I use in my Excel Spreadsheet and am trying to automate it.
I tried this:
For r =...
Sorry for the first part with the banging of the head. I forgot to explain something - this is the code that I used originally based off of what you shared
Selection.CurrentRegion.Select
For r = Selection.Rows.Count To 1 Step -1
If Cells(r, 2) = "" Then...
Thank you for that information. I do have two more questions, and maybe I misunderstood your previous post. What I want to have an autofill down in column A that says "2013-2014", so here is the code that I used. However, when I did that, it only filled in the even cells. Can you see what I...