I worked with a report some time ago, then deleted it. Now when I
start the database (Access 2003) it informs me that "Module not found"
and opens VBA windows. There in the project frame I see the name of
this deleted report. When I click on it, I get a message that name

I want to diplay the month in "mmm" format with the input of number.
E.g. If I input 1, it'll display Jan, if I input 2, it'll display
Feb.  If I write: format (input_month, "mmm"), it'll always display
Jan, no matter I input 1, 2, 3, ....

We are in the process of rewriting a large application that uses an
Access 2003 backend database.  Unfortunately we will be building and
releasing the application in phases which means we are tied to the
existing backend model/structure since users will be running both the

This is what the data looks like
id    Sort    Program    Lender    Price             Rate         Cost    APR
1    101    10ARMS    1    62,499.00    5.250%    -0.450%    6.256%
2    101    10ARMS    2    62,499.00    5.500%    -0.875%    6.344%

So you're in 2002, in a form's design view, in a database that
includes an autoexec (or other) macro.  You have some code in the
OnOpen property.  And one day you're in design view for that form, and
you inadvertantly double click OnOpen in the property box.  And

Trying to install some software on Access 2007.  The software works just
fine on earlier versions of Access.
I have been told that it works on Access 2007 but I have not seen that
personally.

Can anyone show me an example of how to populate / update a dropdown ribbon
control with new items from VBA.
I have created a dropdown on a custom ribbon group with a callback that
works but I do not know how to populate it dynamically ?

Good Morning and thank you all in advance for all assistance offered.
I am receiving a "Runtime Error '3061' Too Few Parameters. Expected 1"
when attempting to generate a recordset as indicated in the code snip
below. The stored query referenced below is dependent on the date

I have a frontend (CTFE.mdb) and backend (CTBE.mdb) on a server. I
have the Compact of Close checkbox checked on the frontend. When I
close the CTFE.mdb (I'm the only one in), the db1.mdb is created and
the uncompacted CTFE.mdb is deleted but the db1.mdb is not renamed

I have an Access XP app that has linked table to SQL 2005 express.
When trying to save a new record, users are getting an error mesage
"insert on linked tbale failed.  Timout expired")
I suspect that it has something to do with other users have the table

Is there maybe a trick
so that when I make a continuous form, the records fit exactly?
Now, without such trick, often the last visible record shows only half
and I have to stretch the form manually, and try, and try once more,

Dear reader,
The presentation of a date field is possible with short date, long date
etcetera.
But as you know the presentation of a date field in a report is still be

Without going into too much detail, I have a table consisting of FirstName,
SurName and Address. I want to produce labels with names and addresses. If 2
people live at the same address say Mr Taffy Robinson & Mrs Gwen Robinson
both living at 1 Great North Road using a bit if code ...

After using this syntax to create a field...
Set field = object.CreateField (name, type, size)
how do I set a text field's default value property?
For example,

I have an  access database that has been split and resides in the
network share.
When the access database is currently being updated by someone, and I
try to open the database, I cannot open the file by double clicking on