Search results

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...

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...

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...

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...

Hi, I am trying to create a macro in excel to clean up data that I export from another program. What I did is I recorded a macro, and the macro works beautifully for the set of data that day. However, the next day when I export, the number of rows is different, so the recorded macro I have...

I am trying to setup a database to track athletes and their off season conditioning. The athletes will be entering their workouts online, and then the coaches can access the data. The athletes register online, and one of the questions is to choose what sports they are participating (or think...

I have written a database that keeps logs all the track and field results for my school, and I want to make it a little more user friendly. On the form where results are entered, the label for the field where the results are entered says "Final Time" But I want to change the caption based off...

Hi - I am trying to design a database to keep track of rosters for some athletic teams. Here is how my basic design is setup: tblYear: Has two fields, YearID and AthleticYear, with Year ID being the primary ket tblSport: Has two fields, SportID, and Sport tblLevel: Has two fields, LevelID, and...

Hey. I have been working with basic Microsoft Access for many years, creating basic forms, tables, queries, and reports. But I don't know how to do something that keeps coming up again and again - making a default value through coding. What I have done for years is create a form that had a...

Hi. I am using Dreamweaver and I want to filter some records from a database I have. The records are a listing of all the sports teams from the past year and what they did. But one long page of results doesn't help me. Dreamweaver has the ability to filter by 1 field, but how to I filter by...

I have been working on this database of mine for quite some time, and I have run into a roadblock. Here is my situation. I currently have a form that has two texboxes, one that is linked to the field finaltimeminutes and one linked to the field finaltimeseconds. The user hits tab to jump...

I am trying to make my crystal report look better, and I am having one issue - records that aren't visible. Whether it is the visible property set to false, or supressing duplicate records, all crystal reports is doing is putting white space where the record actually is. However, I don't want...

Currently I have two fields that makeup the time of day - a minute textbox and a seconds textbox. Currently, a user has to hit tab to go from one textbox to the other. How could I code it so that if a user hits colon : it will automatically jump to the seconds box for a more natural feeling...

Is it possible to sort different ways in a report based off of a specific header? Here is what I have. I am working on a database that prints out the best track and field times. For running events, you want the times to be sorted from smallest to largest, for field events, you want the...

I have one more question about my report. I currently have a report that organizes records from smallest to largest, and I only want the 10 lowest to show. So I have the following hard coded into a report: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If txtRCount > 10...

Currently I have a report that is based off of a query, and the query has a field that asks for a parameter value when it is run. I know why it comes up, but I don't want to see it come up. Is there a code that I can use that will automatically fill in a null value when box pops up asking for...

Hi - I am creating a database that tracks all of the statistics for our track and field team. I am running into one issue though. In a field that I call "Final Result", I am having a running event automatically created calling the following: [FinalTimeMinutes] & ":" &...

I am trying to setup a database for some track and cross country runners in order to track personal stats, however, I am running into an issue. I want to make the database I have more efficient, but the issue I am having is how to setup the final time field. Currently in my database is setup...

Hi - I have a database I am working on where I am tracking our current students. There is a field in my table of student info called YearOfGraduation, which is 2008, 2009, 2010, etc. On the form where the user adds students, there is a calculated field called "Current Grade." I would like to...