I have design a Query and Form trying to get an Item Number, his description
and different type of Requirements for the same number.
I don't have problem to get information about it, the results of the Item
Number typed are fine, the problem is because taking around 3 minutes to ...

I am new to the advanced level of access.  I would like some tips on
table designs.
I have 2 tables that I have added to an existing database.  Table 1
contains all the description values in one the columns.  Table 2

Need opinion,
I hv created Table for Customer Info and Account.
My customer has two type..i) Borrower and ii) Guarantor
The account table must hv borrower and a guarantor.

I created a main database table; name, address, phone#, etc. I want to link
other tables to the main table. Whereas if I input new information into the
main table, it will update information in the tables link to it. The other
table will have the names for the main table but no ...

I want to track each bank transaction from
the bank statements I receive.
Is there any standard procedure for this,
given that if I present a figure from the

I have a form from which I open all the reports of my datebase, but on my
reports, I have activated the On No Data event. This event works well
whenever I click on any report's command button to open reports which gives
me the "no data found" message if there are no records to be ...

When using indexes to prevent a repeat a complex error message appears. I
would like to change this for one of my own. Can it be done?

I am new to the advanced level of access.  I would like some tips on
table designs.
I have 2 tables that I have added to an existing database.  Table 1
contains all the description values in one the columns.  Table 2

In my Master table I have a lookup field from the Account table.  In the Acct
table the field size is 150 and works fine.  In the Master table this field
says it is too large and I must paste less data.  How do I fix this???
Thanks!

got a form with a tab control object, where I need to insert a logo. I took
a screenshot of the tab control and worked it with Photoshop in ordert to
make sure the background color of the logo would match the tab control color.
Now when I use my database onto another computer ... ...

I have been contracted (free-lance) to design a fairly extensive database
using Microsoft Access.  I have heard that the organization for whom I have
developed this tool may want to turn around and sell it to a number of other,
similar (non-profit) organizations.   I feel uneasy ...

I am creating a database which requires a unique number to be assigned to
each record. Called Schedule Number.
However, records are revised periodically and the same record has to be
shown with again with minor adjustements and the same Schedule Number. Called

I am looking for some advice on how to set up primary keys and ID numbers.
I need two table, one for donors and one for companies.  However I receive
donations from both and only really require one donations table.  If I use
auto number in the table I will end up with a donor and ...

Hi!  
I've created a relatively complex desktop application in Access and now need
to create a 2nd identical application on a new dataset of virtually the exact
same structure and format as the first.

Hi I am trying to create a linked subforms or several linked subforms, I
would ideally like to have three or four linked forms from a main form, I am
currently creating these through the wizard and when I create the first
subform I always get asked if I would like a subform or ...