I have a pointer arrow. The screen works for scrolling, but only sometimes for clicking on links. Then I hit my...trackball thingy, and got a pointer on the screen, which I've never seen on another app.

I'm using it right now because I'm logged in to a bunch of stuff on Dolphin. It's irritating because the text corrections don't work in it, so I have to do my own capitalisation and punctuation. Very fiddly.

Ahh, my tracking thingie doesn't work very well, so I hadn't used it. But I just tried and, yeah, pointer arrow! How odd.

I'll download Dolphin and try that out for awhile.

Interface Message Processor (IMP) – The First Internet Router

Steve Jurvetson shot this photo of a Interface Message Processor (IMP) made by BBN, which was as used as a router by APRANET to create one of the first nodes Internet in 1969. It is part of an upcoming exhibition at the Computer History Museum in Mountain View, CA.

Nothing to see.

No, it's not the place. You need to pursue that sort of hacking on the down low, not here on the board.

Will do. Thanks.

Obviously that could be rewritten to get rid of the YK3 issue, but here's a place where SQL could use a built-in variable for positive infinity, like some languages do.

I'd program it for 12/31/9999, because I'm a very strange man...

I have apparently managed to boot my 400MHZ G4 box to boot on a hard drive with Leopard installed.

To quote that old mainframe song "Do It Yourself:"

...it crashes every hour, and it isn't worth a damn,
But I'm satisfied because it runs just like an IBM!

I have a visual basic/access question. My database has a form which I use to send confirmation emails to students. There are 2 drop down menus, one for student name, and one for class name. There is a different button for each letter, which takes me to a word mail merge document based on selecting either the student or the class.

My issue is that I need two more sub-criteria-- a way to send to just the unpaid and not cancelled people in the class. Currently to remind people to pay, i have to go through each class by hand and pick out the people who haven't apid, write down their names, and then individually send them an email.

Now I am supposed to do at least weekly.

I only need one mail merge sorted this way, so I thought maybe I could add something to the command that happens when you press the button, but I do not understand visual basic at all.

The command is

Private Sub cmdPayNeed_Click() On Error GoTo Err_PayNeed_Click Dim db As DAO.Database Dim qry As QueryDef Set db = CurrentDb If Not Me.cboClassName = "" And Not Me.cboStudentName = "" Then MsgBox "You may only choose Class or Student but not both.", vbCritical Me.cboClassName = "" Me.cboStudentName = "" Exit Sub ElseIf Me.cboClassName "" Then Set qry = db.QueryDefs("qryStudentPayEmailClass") qry.Parameters("Input Class ID") = [Forms]![preLetterType]![cboClassName] qry.Execute ElseIf Me.cboStudentName "" Then Set qry = db.QueryDefs("qryStudentPayEmail") qry.Parameters("Input Student ID") = [Forms]![preLetterType]![cboStudentName] qry.Execute ElseIf Me.cboClassName = "" And Me.cboStudentName = "" Then MsgBox ("You must select a Class or Student before opening Payment Needed."), vbCritical Me.cboClassName.SetFocus Exit Sub End If

Exit_cmdPayNeed_Click: Exit Sub

Err_PayNeed_Click: MsgBox Err.Description Resume Exit_cmdPayNeed_Click

End Sub

Sophia, would you use a different query for this case? (If so, can you create the query?)

My issue is that I need two more sub-criteria-- a way to send to just the unpaid and not cancelled people in the class.

I don't understand the "two criteria" here - isn't this just one more option? Or is "unpaid" and "not cancelled" two different options?

How would you modify the form for the new options?