Hi,
I have a main form with a tab control.  Each of the tab control pages has a
subform linked to the main form.  When I'm tabbing through controls on the
subforms, the subform doesn't automatically scroll down so I can see the

I'm working on something similar to Dennis but I'm clueless on how to use a
public variable at all.
I want to create a button a form (the form displays records based on a
query) that will allow the user to select a record from the form and when

Access 2000, WIN 2000
I am creating a form for a vendor listing.  I want to use tab controls to
set the filtering for each letter of the alphabet "A, B C,..Z" to list
vendors that begin with that particular letter.

i'm trying to calculate the age of a patient based on their date of birth.  
does anyone know this calculation.  we want access to give us the age on the
form

can anyone point me in the direction of a tutorial that tells me how to use
a custom form as a dialogue box to run a report....
e.g. - i want to have a form with a combo list of names, then when the name
is selected it opens up a report filtered by that name.

I don't know whether this is the best place to post this or reports, because
i don't know where i would solve this problem on my system.
I have a 3 fields 'GermanCourseworkMark', 'GermanExaminationMarkF' and
'GermanExaminationMarkH'. these field all each contain an

Error 2585 This Action cannot be carried out while processing a form or report
I have my orders form (frmorders)  that I use for new orders and after all
the information is added the user clicks on a command button that allows them
to print the current order, rptcustomorder.

I'd like to open a text file in order to get a pathname that I can store in a
string.  Thanks.
Ken

I have a form that displays a syntax error when I use the double-click
function of a coded combo box:
Syntax error (missing operator) in query expression
'txtProfileID="Pallet 48" X 40"".

I have written VBA code to read data from an Excel spreadsheet. How can I
tell what is the last line of data on the spreadsheet?
Thanks,
Gerry Goldberg

I'd like to perform a series of VBA commands on all the files in a directory
folder, and I need to perform the same commands on each of those files.
In pseudocode, this would be
for each file in drive:path\*.*

When I try to compact my db I get a "Records can't be read; no read
permissions on db" msg.
After attempting to compact, a new db is created with an extra table
"MSysCompactError" with one record stating "The Microsoft Jet database engine

How can I call a procedure that's stored in a variable?
I recall someone once advising me to use an Eval but it's not working, nor
does "Call x" where 'x' contains my procedure name (ok, that was a longshot).
Function or sub, can't figure it out.  Seems so simple (and I'm sure it ...

Has anyone run into a situation where by adding code such as below to a
checkbox, will present this error when clicking on a button that opens a
subform?
Error: Run-time error '2465'

I am trying to create a calendar to pass the value that I choose from the
Calendar, to the field duedate on my form. I know this is possible, but I
cannot figure it out.
Also, when I create my calendar on my form, I don't want to "full size"