Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Ok, you'd need some form that you'd use to open the report. I'll assume it's called "frmStudentReport". On that form you'd need a combo box with the student names. Assume that's called "cboStudents".
Construct a new query. Add the table "Referrals" to it and drag all the table's fields into the query grid. On the criteria for the "Student Name" field, put "forms!frmStudentReport!cboStudents".
Save the query and construct your new report with the query as the recordsource. Then put a button on the form you're using to open the report. Right-click on the button and select "build event". Select "Macro Builder" and save the macro. In the Macro "action" field select "open Report" and enter the report name on the bottom. (I'd use code myself instead of a macro, but a macro is easier.)
Does that make sense?
eta: It doesn't matter what you call the form and the combo box, but if those names have a space in them, enclose the name in square brackets in the query. eg: "forms![Student Report]!cboStudents" Also, don't include the quotes.
So today is the first really cold day of the season, and as a result the heat is on and the air is really dry. I went to the bathroom, and when I came back (and before I sat down) I pressed the space bar on my MacBook so iTunes would resume playing. As I did I got a nasty static electricity shock (I had just been walking on carpet) and as a result the trackpad and keyboard of my MacBook were completely locked up.
After rebooting, all was fine. But I was scared there for a bit....
I couldn't help being reminded of this xkcd.
Ha! My database inputs are suitably sanitised.
How is it we're not talking about the Google phone here? I mean, dude! Google Phone!
(Okay, technically Google Mobile Platform. But still! Google Mobile Platform!)
How is it we're not talking about the Google phone here?
It doesn't come out until the second half of '08?
Anyway, I'm tempted to download the development thingie for it....
I don't know if more evidence that DRM sucks is needed, but... here's one case where it
really
sucks:
Allan Wood (a baseball megafan who has written a book about Babe Ruth) purchased over $280 worth of digital downloads of baseball games from Major League Baseball, who have just turned off their DRM server, leaving him with no way to watch his videos. MLB's position is that since these videos were "one time sales," and that means that Wood and everyone else who gave money to MLB is out of luck -- they'll never be able to watch their videos again,.
MLB shut down the DRM server because they've changed suppliers, and now they expect suckers to buy downloads of games in the new DRM format.
[link]
Apparently, MLB lied when they said only a one-time connection would be needed to to authorize the videos.
How many DRM schemes require connecting to the interneet and a DRM server to be played?
I have a powerbook that doesn't boot. Stops at the grey screen with the apple and the progress wheel. Just take it into the shop?
I can only offer the obvious - have you tried booting from a CD? Also, Macs still come with a hardware diagnostic CD that you boot into, right?
eta:
Stops at the grey screen with the apple and the progress wheel.
My fave is the folder icon with the question mark on it.