But now here's the catch - I want to see information from an
earlier record in the table.
Suppose the correspondence table had these five records
ID   VehicleJobID    OutDate    OutType

I was converting this from 97 to 2003 and ran into a problem in the
code.
The problem is fld.name
name highlighted and says method or member not found.

Our IT guys are on a vendetta against MS Access (and Lotus Notes but they've
won that fight).  What I can't understand is, what's the problem?  Why does
IT hate MS Access so much.
I have tried to find out who it is that actually wants to get rid of it, but

Hey all,
I would like to make a command button on a form that lets you enter a
users name, and then if finds and displays only the records from that
user in the same form. I've tried doing it via a filter, but I'm not

I am having a problem where fields are being filled by spaces when data
is put in.
I.e. in a text field length 50, whatever is stored in there is padded
by spaces and the field length is always 50.

I have a fairly simple task, or at least I think it should be.  I have
a report with two fields on it,
BadgeIn (text)
BadgeOut (text)

Hey all,
I created a report that lets me choose the month and I get a broken
down list of employees and their time.
It's broken down like this

I am using MS Access 2003 to prepare data for a scientific study. I
have a table which look like that:
"Customer"   "Store"             "Product"     "Price" "week"
"100"         "Supermarket1"        "XProduct"    2,20 $  5

If you are looking for opinon on what's useful in Access 2007, there's a new
article at:
   http://allenbrowne.com/Access2007.html
Covers what's good (useful features), what's mixed (good and bad), what's

I have an application which uses a SQL server 2003 Back end and an
Access 2003 front end.
I am trying to populate a recordset in the FE with data from an ODBC
linked table to the BE. Here is my code:

I have a typical front end/back end access app. Additionally a vb.net app
accesses the backend mdb file every few minutes and runs insert and update
queries on some table. The data to be inserted and updated is coming from a
remote db. The mdb file size is normally around 80MB ...

I wrote a database applicaiton using Access XP (2002) and everything
has been working good for the client until they purchased a couple of
new computers with Access 2003.
The meetings form has an unbound combo box listing all the meetings in

I am having a list box where I will select the Plants (Plant-1 or
Plant-2 Etc.) or leave blank for selecting all plants. Another list box
in the same form where the supervisors list is provided. A report named
"Assigned Jobs" shall open by meeting all the following conditions

I have some code I use to create a mail message in Outlook 2003 from Access
as follows:
Dim objOutlook As Outlook.Application
Set objOutlook = New Outlook.Application

From a Access 2000 Database the Labo analyses are exported in a xls-files
and send to the customer as email-attachment.
It is all done by code in 1 cmd.:
1. Creating a xls-file from a template.