lets say we have 3 storey building in use. At each floor, there are
several type of furnitures. So we have produced 3 seperate table which
has only one field called `furniture name`.
I would like to see furnitures in a single table (query result) which

I started a database on my home computer last week (running Access2000 and XP
Professional) and everything worked perfectly.  When I tried to open one of
the forms on my office computer (Access2002 and XP Professional), I got an
error message:

I got three forms for different modes: namely view/edit mode, delete mode and
add mode.
But there's something wrong with my add mode form. My main form appears but
my subform are nowhere to be found? Is there something wrong?

I have code behind several forms written in earlier versions (2003 and
earlier).
The data source for the forms might include a table with fields: Field1,
Field2, Field3...

Hi, I need to copy a linked table to a new table but the new table
should not have a link. ie
all the data and settings accept for the link to another db.
How can I do this?

I am working with the example code written by Dev Ashish from The Access Web
site and I have run into a brick wall.
I am trying to debug the following line:
Set rs = db.OpenRecordset("City (table) Query", dbOpenDynaset)

I have a subform that allows me to open selected reports.  I want to create
the same thing but for opening and forms to allow for additonal data.  I used
the same macro expression: =[Forms]![Maintenance]![lstMaintenance], however
it doesnt open the forms and just returns errors.  ...

I have a subform that allows me to open selected reports.  I want to create
the same thing but for opening and forms to allow for additonal data.  I used
the same macro expression: =[Forms]![Maintenance]![lstMaintenance], however
it doesnt open the forms and just returns errors.  ...

I have a key that the user enters and then I want to manipulate. The
user enters a 4 digit number (X), and I run my equation on it (let's
say, X*2) and return back a 4 digit number.  What the number is
doesn't really matter, as long as it is consistant each time the user

Is it possible to put SQL into the VBA code ?
I have tryed to put it into a lable and textbox like this -
label.caption = "Select......."
textbox.text = "Select....."

I have a table «Clients». In that table, among others, I have a field
«Chosen number». The client can chose this number. However this number cannot
be repeated.
In the table «Clients», the field «Chosen number» is set to be indexed (no

I have a database where the user clicks a button and it exports the 8
tables to an excel file.  I've noticed that after the file is
exported, the excel file is bloated, but if i open the excel file and
resave it, the file size reduce by about half.

Hi is it possible to count the number of times the words "Invoice Chased"
has been entered in a memo field?  If it is how do I go about it?
Thanks Bob

I’m using a form with an ActiveX control (Autodesk’s DWG TrueView) to view
AutoCAD drawings.  I can print the drawings directly from my database by
right clicking on the ActiveX control, then selecting File – Plot.  This
opens TrueView’s “print dialog” (not sure if that’s the ...

I want do do the following: when I display in a form a record one after
another, when I reach the last one, the displays automatically ends or go to
a end form to tell the user that the presentation ended.
What is happening right now, is that when I reach the last record and I