I am currently updating controls using the following process:
Reports!Rpt_Range_By_Season_Report.Period_Ordered_Month_Label_1.Caption =
"Feb"
Reports!Rpt_Range_By_Season_Report.Period_Ordered_Month_Label_2.Caption =

    I'm an oldie to access and very new to access programming
I have the file name of pictures stored in a field, and then a
"PicturePathAndFile" expression in q query that prefixes the file name with
it's path.

Does anyone know how to switch how Access 2007 between these two display
modes in code? Obviously I cannot expect my dearly beloved users to go to the
Access options and do it manually. In fact I would rather not!
If TabbedDocument mode is set then a property of UseMDIMode becomes ...

I have a form that we use to enter calls.  I want to be able to have the next
call number appear in a message box when the form is opened.  I can get the
message box to appear, but don't know how to retreive the call number from my
call table so it appears in the message box.  ...

How to calculate the due date in lotus notes, adding any number of the
day, month or year to any date?
Example:
Calibration date : 21.09.2007

How can the extra bar below the title bar be removed in A2007 with VBA ?  I
am using A2000 but when someone opens in A2007 the top is messed up.
Also, how can you use VBA to get rid of that extra stuff on the title bar.
See example at:

I'm trying to append records from one table to another in order to identify
corrupted records and so that I can use the data in another aplication, but I
can't seem to find a method that works.  I've copied and pasted, I've
appended into an empty version of the table, I've looked ...

Hi I have a form where users have options buttons to choose betweeen edit
mode and view only mode.  When the view mode is chosen, I have a script that
will disable my combo boxes and hide certain buttons etc, but when they
choose edit mode, they the combo boxes and text boxes ...

I'm using the code below to loop through records in a table, open a report
for the record selected, export the report and then loop back through for
each record in the table who has a statusid of 1.  The problem is when the
code loops back thorough, it does not go to a new record, ...

I'm writing a module to compare values between a text file and an XML file.
I'm doing this by importing both into Access and generating SQL to select and
compare variables in the tables. In some cases a table is not defined in the
XML but does exist in the text file. How can I ...

Thanks for that Douglas, which software should I use to install it - Office
2003?

I've searched all the various rounding posts and can't find my solution.  I
need to round a number that I calculate in vb down to the nearest .25.  For
example 27.49 needs to be changed to 27.25 etc.  Following is the required
logic:

My company currently has a manual process that needs to be updated.
Basically, I get sent an excel file every month - and with that file, I need
to update a bunch of other excel files within a bunch of folders/subfolders.
So:

I have just started the ECDL Adv course where we are to use Access 2003, my
home system is Vista are these compatible?

this is a similar question to one already posted.
I am looking to retrieve two colums of data from a list box and display them
in two text boxes. easy!
now what i would really like to do is this for a multi select listbox...