That's my girl... That's my good girl.

Kaylee ,'Serenity'


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!


Sean K - Nov 05, 2007 4:52:52 pm PST #3399 of 25497
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty

Sean try it without the spaces.

Actually, I entered it without spaces.

Oh! I shall now try entering it with dashes included. I wonder if that will do it.


-t - Nov 05, 2007 4:53:58 pm PST #3400 of 25497
I am a woman of various inclinations and only some of the time are they to burn everything down in frustration

I figured I was missing something. And I have exhausted my knowledge on the subject. Good luck!


Sean K - Nov 05, 2007 4:55:43 pm PST #3401 of 25497
You can't leave me to my own devices; my devices are Nap and Eat. -Zenkitty

AHA! That did it.

Programs should not be counterintuitive at me when I'm sleepy. If I needed to enter the serial number with dashes included, it should have said so.


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.