I've got a continous sub-form that displays a large amount of records
and was hoping to use some sort of pagination (i.e. view 20 records at
a time).  Any ideas on how to get started on this?  Thanks!

I have the following code in a command button.  If I do not put the requery
line, the report does not show the "Sample Meets" on it.  The requery works
but throws my form back to record one.  Is there something else I can use to
refresh the record or I'm I doing something wrong?

I'm stumped on something and need some guru's input.  I've got a couple
fields on my forms that display the border of the txt field.  I have the
field properties set to:
format...

Can someone please tell me why this code is not filtering my report?  The
button opens the report but won't filter.  FTA_Terr_txtbox is the field on my
main form "Frm_Tap_Accounts". Terr_No_txtbox is the field on my report,
"Compliance_Report".  

I am having trouble referencing subforms; specifically referencing code
behind a subform or passing the name of a sub form to a variable and then
using it in a With statement. I am leaving out some detail because this code
works with three other forms, it fails only on the ...

Hi.  I was having some trouble with MS Access' Autocorrect.  I
unchecked all the boxes in the Autocorrect options.  I want to have one
of my fields prepend with 0s.  Such as:
0012345

I am creating forms using a wizard in ms access (2002) and they display
fine when I double click on them directly. But if I have another form
execute/run them, the display is changed from lookin like an excel
input method to a record-per-view method. Any suggestions?

I'm trying to get an image1 to display if a value is empty and display
image2 to display if not.
I've found this line of code which seems to work:
if IsNull(forms!form1!txtbox1.Value) = True then img1.Picture =

is there a way to get a msgbox poping up when moving the mouse icon over a
control (image, button,...). I could display a textbox, but I wish the msgbox
to follow the mouse icon.
Pls check here for example :

How do you configure it so when you are done type in a field that has a set
number of characters, like a phone number, it automatically tabs to the next
field so you don't have to hit your tab button?
Thanks

I have a comman button with on click event of:
Me.Principal_Bday1 = Me.Principal_Bday1 + 1
But I want their bday to increase by 1 year, so it reminds me again next
year, like 7/25/06 becomes 7/25/07

I am trying to use a combo box to select a specific schedule for a specific
student, and then load that schedule onto the form.
My combobox is populated with this query:
SELECT tblSchedules.term FROM tblSchedules WHERE

I need some help automatically sending email out using a command button.
Scenario:
I have to send out confirmation on attendees for a meeting.
Table structure:

quick question is it possible by clicking on a record in a query to
bring up a form with all of that records revelant data?
thanks

so here is what im doing... ive got two forms, form1 opens form2 and
moves a bunch of textboxes around on form2... it sets the onGotFocus
property to call a macro... this works, but im not sure if its the best
way to do it, i did it this way because programatically adding