I happen to be very biteable, pal. I'm moist and delicious.

Xander ,'Bring On The Night'


Buffistechnology 3: "Press Some Buttons, See What Happens."

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!


omnis_audis - Nov 05, 2007 6:14:25 pm PST #3402 of 25497
omnis, pursue. That's an order from a shy woman who can use M-16. - Shir

there is a joke in there somewhere. But brain not engaged.


Gris - Nov 06, 2007 5:08:43 am PST #3403 of 25497
Hey. New board.

Access question, probably simple:

I'm trying to set up a database for our dean of students so that she can easily keep track or student referrals. I've made a table and a justified form for entering the data, and it works great. She is entering data as we speak.

For reports, though, I'm still confused. What I'd like is for her to be able to click something that pulls up a "Which student?" form. She chooses a student, clicks a button, and a nice, printable report with all of that student's referrals ONLY appear. Is that possible?


tommyrot - Nov 06, 2007 5:12:58 am PST #3404 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

Yes.

If I understand correctly, ideally you'd want a table of students and another table of referrals cross-referenced to the table of students. You just have a single table? You can still do it that way.

What uniquely identifies each student? The name? What is that field named?

(If I have time I'll poke back here periodically to help you along.)


Gris - Nov 06, 2007 6:09:36 am PST #3405 of 25497
Hey. New board.

Okay, so let me 'splain a bit more.

We have two tables: "Student Names" and "Referrals"

"Student Names" only has one field, and it simply lists all of the student names, in alphabetical order.

"Referrals" has several fields, including one called "Student Name" that uses a combo box populated by the "Student Names" table.

What I'd like is to be able to get a report of all tables in the "Referral" table that have a particular student in the "Student Name" field (ideally, I'd like to be able to set up reports that draw from other lists too, but I expect if you can show me where to find this, I could figure out other reports).


tommyrot - Nov 06, 2007 6:23:09 am PST #3406 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

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.


tommyrot - Nov 06, 2007 7:08:25 am PST #3407 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

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


Laga - Nov 06, 2007 10:33:37 am PST #3408 of 25497
You should know I'm a big deal in the Resistance.

I couldn't help being reminded of this xkcd.


§ ita § - Nov 06, 2007 10:38:00 am PST #3409 of 25497
Well not canonically, no, but this is transformative fiction.

Ha! My database inputs are suitably sanitised.


Jessica - Nov 07, 2007 7:23:46 am PST #3410 of 25497
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset

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!)


tommyrot - Nov 07, 2007 7:28:00 am PST #3411 of 25497
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.

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