I'd like to create a form with the top third being student contact data.
Under that have 4 or 5 buttons (i.e. personal data, courses,grades) that the
user can press to display the appropriate data in the other 2/3 of the
screen. Whats the best way to do this?

I have a form that I want to open if the underlying query has a recordset
greater than 0, but if the query's recordset is null, I want a message box to
open alerting the user to the fact that there are no records to process
instead of the distractingly empty report that opens ...

I am having a problem with some lines of VB Code which are too long for one
line position to hold.  Is there some way to wrap the code down to the next
line without disturbing the logic of the code?
For example:

I have a list box property
SELECT [qBiz Overview Presenters].Preferred, [qBiz Overview Presenters].[CO
Date], [qBiz Overview Presenters].[CO Time], [qBiz Overview Presenters].[CO
Open/Close] FROM [qBiz Overview Presenters] ORDER BY [qBiz Overview

is it possible to have an option group call another option group?
i have an option group on a form with check boxes. when a check box is
selected, a specific value is placed in a text box that is not shown. that
value is used in a query as a selection item.

Hello,
I have a form that can be edited and also allows for new additions. The form
is also connected to a second form and table and thus uses the afterupdate
demand to connect any additions or changes in the data. However, I want to

When using VBA to populate photos on a form (imgXX.Picture = C:\ABC\1101.jpg),
I get a flashing notice which doesn't dwell long enough to be readible and
which is distracting, especially when multiple pictures are involved.  I also
suspect that it slows down the process.  Is there a ...

I have a combo box wih the following code:
Private Sub cboFindHole_AfterUpdate()
   ' Find the record that matches the control.
   Dim rs As Object

I am getting a type mismatch error with the [date type] part (have commented
it out & the first bit works!).
tblList2.FindFirst "[Job ID] = " & lstCheck.Column(0) And " [Date Type] = "
& DateType

Records     BD        TargetDate
   1           10                    10/22/07
   2            5                    10/29/07
   3            1                    10/30/07

I cleared the passowrd of one of my user accounts and now I get the below.
"You do not have the necessary permissions to use the .....mdb... Have your
systems administrator or the person who created the object establish the
appropriate permissions for you."

A2k
Is there a way to get the selected row count of a list box dynamically as
the user selects rows? Delphi has an event called "OnSelectionChanged" but
Access is much more limited. I don't want the user to have to exit the list

Hello threre
From some load test can i see time in mili seconds?

How do you find and replace a Yes/No field?    I want to find all no entries
and globally replace them with a yes entry.
Any assistance is deeply appreciated.

hello every one
I have this code from Northwind sample.
Private Sub ReviewProducts_Click()
' This code created in part by Command Button Wizard.