I'm working with a database (Access 2000 Ver 9.0.2720) that has over 40
fields, 4050+ records and 96 queries referencing either the table or master
queries. When try to sort by First and Last Names, I get a popup window that
says "Not a valid bookmark.", a "Help" button", and ...

i am trying to generate uniquie numbers for a bunch of PC ID's. These numbers
should be based on a few variables like location state, city.  Any help?

Access 2003 ADP SQL Server 2000 SP4 backend.
ALTER   PROC procTEST
AS
SET NOCOUNT ON

I have a very limited database but in it I want to put in a combo box that
will look up a piece of information from another table and return not only
that bit of data but other parts of the record on that other table.  
Specifically, if I have a list of text (diagnoses) and ...

I have 2 tables.  Table1 contains field 'Streetname' field 'town' and field
'postcode'.
Table2 contains customer details including addresses.  How can I use the
street and postcode table1, to populate the address details in the customer

I have a database with a switchboard form on it, theres an exit database
button on there that i want users to use instead of the close button on the
access window, I have removed the X close option from the switchboard form
itself, is there any way to remove it from the larger ...

I just split my secured database. The BE file can opened with a click and all
data manipulated! I had no idea that the security wold be lost.
How do I make the BE secure?
Thanks!

I recently installed Access 2003 on my machine, and now I can't view any
reports in design or print view.  This is the case for databases I created in
Access 2000 as well as for new databases created in Access 2003.  I can view
the list of reports, but I can't open them.  Any ...

I would like assistance on what should be done to make all entries to a
table upper case if the person making the entries failed to turn on the cap
lock key to upper case.
Alvin.

Bad design, I know, but a customer wants to take what is currently field1,
field2, field3, etc. and use this data in a drop down box.
The table is a single record, with 10 of these fields.  
Any suggestions on how to make each field a record in a query, and use it as

I would like to have a field in a table that the value defaults to
either
a custom function that I wrote in a module or the CurrentUser property.
i.e

I'm a little lost about the whole replication idea. I understand that it's
meant to be a backup copy for emergency situations. That's a good thing
however, I'm wondering how it works with a split database. I'm looking to
split my database to improve network speed but I'm confused ...

I am having problems with a (fairly) simple database.
The purpose is to maintain a list of events at our Yacht Club, and faclities
associated with each event, and the
details of the organisers of the events run at the club.

I am new to Databases.
I want to create a data base which will have a lot of information which
is related to monthy figures. I have a number of tables that have data
entered on a monthly basis.

do you know where i can obtain a very simple landlord access database for
tenants