I'm looking for solutions to help manage my 146 (and growing) clients.  Right
now using salesforce.com + MS Excel & Quickbooks.  I'm really not able to
generate accurate reporting using this system and I'm becoming frustrated by
wasted time reconciling and re-reporting ...

I have a problem. I am developing a library software of CDs in VB6 with
Access 2000. The search command for title, artist and composer are simple
involving single fields, but I simply do not know how to search for tracks
for which I have 18 field as Track 1 Track 2 .....Track 18  ...

Using Access 2000
I have a db with every single player that has ever played with the Milw.
Brewers.
But this table has the Player's Name

how do you create a database for a pre booking system for example equipement

I understand that by typing a > in the format portion of the field
properties, it will convert any lower case text entered into upper case.  My
problem is on export to Excel, it recognizes the original lower case input.  
I would like the export to also be in all caps.  I am sure ...

I have created a database - a table for each subject e.g. English; Maths; Art
etc.  Each table has fields such as the SubjectID, StudentId, Effort,
Attainment, Teacher's comments etc.  I also has a table called Students with
fields Id, Name, Surname, Form, Tutor's Comments.  The ...

Microsoft Access 2003.  I am trying to build a data base in which I need to
enter the data for one cell of the last record into another cell in the next
record, automatically, so when the form opens, the information will be
displayed in the cell. how can I do it?

I have a 500,000 record table, but there are 5 of each entry so really only
100,000 unique records.  I want to remove the duplicate data.  I know in
Excel, I would do a pivot table, but the pivot table in Access didn't seem to
work the same.  

I am trying to normalize a db that I have imported from an ODBC source.  I
have 2 sets of 6 different fields that I want to combine into 2 fields.  
Example of the current layout-
Employee ID Date 1 Rate 1 Date 2 Rate 2 Date 3 Rate 3 Date 4 Rate 4 Date 5  

Hi All,
I'm having trouble with the following database design issues.
The database is to sell individual items and items as associated to a
combo-set (case) - special discount when multiple items are sold.

I am creating a database and I am trying to set up my table to Lookup a value
in one of my other tables.  I am able to bring up the Lookup Wizard dialog
box and I can select the table I want the information to come from and I can
select the value but when I click the next button ...

I am seeing old file names for databases that I have already deleted.  How do
I delete those names?  Note:  I have already deleted the source files.

I created a database at 1024x768 resolution. Some folk who use this db have
their resolution at 800x600. Needless to say, a large portion of the display
(forms) is now hidden. You have to scroll to see everything whereas at 1024
everything was visible. Is there a way to get ...

Need some suggestions. I am creating a database for an Art Gallery which
sells Artwork by consignment. An Artist can have many consignments which
can contain many Artworks. When an artwork is sold commission is deducted
and artist are paid at the end of each month. I don't really ...

I cannot set the property "Transparant" set to a TabObject