I have some VBA code which is calculating fees based on a number of
different criteria. The part that I am stuck on is to do with the number of
dates between a field called DateReceived and DateDueToCommence:
If the DateReceived is less than one month from the DateDueToCommence ...

Where has the Access On-line Applications book gone?
It is a great reference and I need it!!!!!

I need to calculate stuff and I'm planning to do it in a query. My
calculations aren't simple (like a+b-c), so I cannot do then straight into a
field in design mode, I'm doing them in code. It is not a problem for me, it
works. My question is:

I have several apps that use an ODBC DSN to a DB2 back-end. One table, in
particular, becomes read-only when I copy the table link from one Access DB
to another.
When I run through the Link Tables wizard (which takes a LONG time, since

I am using the TransferSpreadsheet via VBA to send a query to a directory for
a user to later use in Excel.  The command may be used several times.  The
query that is exported is always named the same thing.  If the spreadsheet
already exists in the folder, I get "Can't expand ...

Access 2003.
how do you reset the eof and bof flags so that they don't error if you
attempt a movenext or moveprev using a Dao recordset if the eof or bof has
already triggered once.

I am looking to have an individual enter a specific date for a delivery and
upon clicking a button they all the fields on the form will update a table
with the name of the month of delivery.  
For instance if they set the date of july 16 the system would look for a

I have a toggle button set up on a form to filter data based on criteria
"CHG" in the field.  The code I'm using is asking for data even though I
stated the criteria.  Basically I just want to filter items identified as
"CHG" when press the toggle and then when I press the toggle ...

I'm using a database I created using the service call Mgt template.
The main form displays the customer's contact information and then there is
a datasheet view (subform) of the workorders that have been issued for that
account.

I have a database that contains information on football games. There are many
different games from many different seasons, teams, opponents.
I will eventually have a fairly large number of different reports and forms
that will want to be viewed but filtered by the above three ...

I am trying to get a good understanding of the various events, when to use
the events, best practices for using the events, etc.
Can anyone point me to good online resources which explain them?
TIA,

I have about 50 excel spreadsheets that are linked to my database. These
spreadsheets are monthly reports. They may or may not be there on a monthly
basis. Using VB, how can I check whether my link is valid or not? I want to
leave the link and queries attached to it for those ...

I have a report with several subforms (I did not design this mess). One of
the subforms is not only a subform on a reoprt but it is also nested into
another subform on the same report (it looks like it is). What I need is to
have that suform not show if the option box on my main ...

How can I call and/or use the Access Import Wizard from a VBA module?
I'm working in Access 2007 and I've searched Google and the MSDN reference
for Access 2007 and haven't found anything.
I appreciate any advice or help you can give me.

I'm using VB to pull data from a table to create an xml file. The Amount
field is stored as a datatype decimal and I can see the trailing zeros in the
table.( I'd store the amount as currency but I don't want the $ sign.)  But
when I run it through my code I lose the trailing ...