Here's a problem that popped up - I try to boot into my computer running Windows 2000 Professional, and the system gets to the Windows 2000 logo screen then automatically goes into a reboot, and the cycle repeats itself. An error message pops up but only for a split second so I cannot read it. I have not installed anything onto the computer in over two months. It's set up as NTFS, only one partition, and it's a Compaq 7000 Series., , Two question:, , 1. What the heck is wrong (sorry, had to ask)?, 2. Is there a way to freeze the error screen as it pops up so I can read it?, , Thanks in advance for any help., , Chris

Posted to MB Topic: Windows 9x, ME, NT, 2000, XP « Windows Board

That's what I have ended up doing. Thanks again for the insight, Mike., , Chris

Posted to MB Topic: Windows 9x, ME, NT, 2000, XP « Windows Board

I just came back into using Access after a 9-month hiatus, and even then I was only beginning to get its uses down. I'm looking forward to learning new techniques in the topics.

Posted to MB Topic: Member Introductions « PrestwoodBoards Board

This should be a piece of cake but it's driving me nuts - I have a form (frm_Intro) with a combo box which lists client names. After choosing a client I have an "Enter" button that is opening a new form (frm_ClientInfo) that will display the detail for the client. Also, there is a subform (sub_ClientInfo) on frm_ClientInfo pulling data from a separate table but related to the client., , I am currently using a select statement in the on-click event for the button setting the variable strOpenRecord equal to the selection. I then use that variable as the recordset for the new form but am getting a Type Mismatch error when I run the forms. Right now I'm open to any suggestions with this issue., , Thanks.

Posted to MB Topic: Access VBA Programming « Access Board

Kal,, , I ended up doing something similar but using the OpenArgs function. I have to give credit where credit is due - I called my old boss to see what he thought. Following is what I ended up with:, , Dim strOpenRecord As String, , strOpenRecord = "SELECT * FROM [Query] " _, & " WHERE ClientName = '" _, & Me!cmb_ClientList.Value & "'", , DoCmd.OpenForm "[FormName]", , , , , , strOpenRecord, , In the new form I then set the RecordSource equal to the OpenArgs and it worked fine., , I'm not sure where the Type Mismatch came from, however, it has not popped up since. Thanks for the lesson, though. I will keep it in mind (and on file) in the future., , Stay cool down there in Hotlanta., , Skeech

Posted to MB Topic: Access VBA Programming « Access Board