Hello Access Experts,
I'm trying to split some data (between Rural and Urban readings) into
seperate tabs (Orig all in Urban Tab). The requirements between Urban
and Rural is filtered differently, so I have to create diff Tables and

How does one go about formatting reports?  I am having trouble
grouping specific items together with each other.  I can't get all the
information umbrella'ed under one specific source.  I have 2 tables
with a one-to-many (names-to-addresses) relationship...hence object X

In a textbox containing a string of ID numbers each separated by a
comma, how can I keep only the first value, and then remove all of the
other numbers and commas behind it?  The first value may contain 1 or
2 or more characters.

I'd like to know how I can build an Access 2003 Add-in that will only
provides users custom vba functions for their own code ?
Does mda file suit my need ?
Any help would be most welcome !

I know that it is possible to force Access 2007 to the display custom
menu bars for an Access database developed in an earlier version by
using the customisation settings in A2007 to nominate a custom menu
bar to display on startup.

i run office 2003 work with access 2003.
i split the address in 2. number and address
ie number "213".address "ross str".and some of the numbers have are
alphanumeric ie "213A".question in design data type i cannot put numbers

Dear reader,
I made a table and now I do not know in which mdb the table is stored.
Is there any help to search for a table in several mdb's even if you do not
know the complete table name but only a part of the name?

Relationship goes Certification can have multiple variations (any single
variation satifies the certification), which require multiple course groups
which require any one of the products assigned to the group.
MS Access.. VBA.. got very many sub relationships and it takes about 30

I have been working on a database that i have set up to run on all the
office machines with 2002 runtime.
If I upgrade my office to 2003, and do work on the database, can I save it
in 2002 format, make and mde, and still have it run on the 2002 runtime?  Or

I have a large historical database of US Railway equipment written in
Access 97.  I have kept it as 97 because I have the Access Developers Kit
that allows me to distribute the database as an executable and it can then  
be used on a PC without  MS Access.

I have a table stores records for moving stock around to different
sites, we use a unique number for this paperwork, it stats with 2MER
and then it has sequential numbering after this.  Is there a way that
the field in my database can have the 2MER and then the autonumber

I have a A2000 form that won't show the vertical scroll bar. I have the
scroll bar format set to show Both. The horizontal bar works fine.
I tried settting the format to show vertical only and it still doesn't show.
(it should show as I can only see about half the screen and can't ...

I've noticed that if you use code for the before update command for unbound
controls, it doesn't really work.
I tried the following:
Me!ExportedYN.undo

I am trying to link tables from MS-Access 2000 to SQL Server 3003.But
I am unable to query the tables.I am getting the "ODBC--call failed"
error.I understand that this is due to the lack of appropriate rights
to the SQL tables.Because if ?I query the Northwind database ,I dont

My application is generating a "The OpenForm action was cancelled"
error and I can't seem to figure out why.  The best part about it is
that it's only one user in the entire building - it works perfectly
fine for the rest of us.  So troubleshooting is extremely difficult.