I have a recordset that has a list of file names and folder names.  I
have the parent directory fixed.  What I need to do is search through
the parent directory.  If this folder with the name from the recordset
doesn't exits I need to create it.  I can't figure out how to do this

Can you help me?  I have two tables that I would like to join together and
have all records from each table display.  Is this possible?
Rich Mogy

I have an Access database built in Access 2003. I was able to set up a start
page form that opens when the database is selected. I did some modifications
to the database including some form name changes. Now when I open the
database, I get an error message that the form names is ...

I have a split database that has been working perfectly. Recently I started
to codevelop the FE and just ran into a problem.
The frontend now when linking wants to link to each table and creates new
tables adding a number after the name. (ie. table1, table2, nexttable1,

I am trying to use the IRR function in a query, but not succeeding.  I have
a positive value (the loan amount) and a lot of negative values (payments
against the loan) in a single field called "CashFlow".
My formula looks like this:

I am looking for simple ways for my users to further refine their search
results in a datasheet using filters.
So far I have a QBF (query by form) set up to refine the records by two
fields, and then display the results in a datasheet. I then want my users to

Per access help, i have created a junction table between ContactsTbl
and CompanyTabe to create a many to many relationship between the two
tables. The junction table contains ContactID and CompanyID fields
from each each of the tables. I've created a relationship between

Can i setup forms such in certain forms, only certain fields are editable?
eg i have one form in which i create the records. and another form in which
i am allowed to modify only one or two fields, the rest become like readonly
(in that form).

OK, I've resolved that the problem I was facing the other day was in the
report's page footer section - not the report footer section.  Now it has
gotten even more complicated.
If there is more than one page of the report, I need to show >some<

I have a form with a button and a bound object frame.  I would like to make
it so that when the button is clicked it will prompt the user to find an
image file on the computer (database is for use on single workstations) and
load it into the object frame.  I've written code in VB ...

I would like to create a database of real estate sites wherein I could insert
salient info about the site and have contact info linked to outlook. Can
anyone help me with this project?

i am developing software using AccessXP and i am thinking of upgrading to
Access2007. can this transition be done effectively without problems? i did
not upgrade to Access2003 though, will skipping this edition have effect on
the software?

I have two tables that have barcode items I’m trying to create a query or
form that will allow someone to scan out items from either table on one
screen.
Example would be a car dealership table 1 cars, table 2 parts.

    I have a database that generates multiple reports about a companies
transactions based on where the funding is from, and the programs it is
dispersed into. When generating these reports I would like to count the
transactions listed under each category, and again at the end with a ...

Using macros, how do I specify a fully qualified name of a text field within
a form on one page of a tab control?
For example, on a normal form it would be:
Forms![FormName]![FieldName]