I have a form (frmCron) whose code in the OnTimer event property
is set by the TimerInterval property to run 86400000 milliseconds. I
open this form in the AutoExec sequence when the mdb file opens.
I was hoping the code ran as soon as frmCron opened and then

I have some sql in a sub that finds dates in a table but only if the
date is less than today
WHERE [MonthYear] < Now()
I want it to do that but to not include the current month.

I am trying to write a query in access that will pull results that are
in the database in a text field and convert to where I can get a
average including decimals.  Any Ideas?
-----------------------Start SQL--------------------------------------

Hey group,
I am trying to do a count of the number of papers in a table.  The
table has a PaperID that differentiates each paper , e.g. 004.1.  Some
papers are reused.  The reused paper is given a new PaperID.  The

I'm having trouble building a query to gather the information I need
from a table. I need to be able to assemble an inventory report that
displays receipts, output, and running inventory from a table named
tblHistory.

I am trying to enable controls based on the value of a checkbox, i.e.
if value = true then enable.
I have a tab control form with controls on 4 tabs.  I have some code
(below) on the tab control "on change" event.

I am full of ??'s  today.
I've been working on this one for a few weeks now and haven't been
able to figure it out.
I have a form that pulls data from a query.

I have a report laid out in Design View as shown at the end of this message.
I have code that performs the following steps:
1. In main report's Report_Open(), DELETE any old rows in tblTOC for
this username.

My MS Access application (create version: 2k Access) running on PC with
2003 Office.
I work with oracle ODBC driver.
Everything is fine except one report (other report run well). This

I'm trying to figure out how to center forms on a page
I have a form built with some tabbed pages, and I'm playing with the
form properties, but it always displays top and left and not centered
Thanks

I have a several paged tab control on my form.
On each page, there are several different controls.  One page may have
5 controls and the other may have 10.
Can I run specific code when one of those controls on a particular page

Anyone have experience in building Access apps with user definable
fields?  (Not the kind of fields where you just let the user define the
label for a pre set number of predefined fields.)  I recently saw an app
that uses an MDB database and allows the user to define totally new

I used =now() in a text box and that nicely displays date and time at
the moment of opening
How would I show updated data?
I thought of an event procedure, but which one would I use since there

Me!AddnlOwnrList.Width = 5.1875
Me.Repaint
Have tried the above in the on got focus event code
to make the listbox control wider when its being used.

I've got project in my school which is Access database.
My teacher said that if she notice any signs of using someone's else
project, then she will fail that person.
I've used some parts of my friend's database and now when I open my mdb in