I'm trying to group a number of fields from one table into one separate field. Basically, the table lists address information: state, zip, city, street. I...

I've been running and modifying 2 Access 97 databases for some years now. The application consists of a forms database and a data database. Current size of...

I have 2 tables in my Access 2000 database which I gave a "Hidden" attribute so taht users would not tample with them. Now, I want to edit these tables, but I...

Is there any way that I can disallow users from importing tables from my database into their own database. I have it split into Data and Application databases,...

Access 2002 SP3 When attempting to import from either an Excel spreadsheet or a CSV file the wizard fails to function properly. Everything works fine except...

I ran an corrupted mdb through a third-party recovery utility and it recovered the tables but it changed the AutoNumber fields to Longs, all 200 of them. Since...

I used the table analyzer on imported data. good. Noticed that a SELECT statement on the imported data includes the term as noted in the subject line, as xyz...

I have created several groups in my mdb as I was developing it. Now that development in nearly done, I would like to resequence the groups so that they are...

Hi, I've been searching the help directory but to no avail... Is there a way I can easily create a dropdown list in a form that shows the queries I've made in...

I am working with Access 2000 and need to add a NULL value to a validation rule to allow a specific field to be left blank in a table. I know I need to add...

I created a database in Access 97 to print barcoded labels. (I plan on converting it to Access XP as soon as all systems in the company are upgraded.) I used...

Hello, We have several clinics and we take patient appointments from a central location. I have created a database with a main form and users input the...

Does anyone know if it is possible to create a subform on a form such that the ONE TO MANY relationship checks on two sets of related fields.eg where you have...

For Tony Toews (or anyone else who can help)... I've just deployed my front-end MDE using the Auto FE Updater. It worked fine for me (the developer, using...

What really causes crop circles? Can a full moon really cause people to act strangely? How does mint make your mouth cool? ALL Questions n More Answered Here ...

Is there a way to password protect a table? I protected the form using an event procedure... but I would like to protect the table too.

I have several tables that use Autonumber as the PK ContractNum Table Autonumber PK ContractNum ContractTitle ContractComments VendorNameTable Autonumber PK

Hi there. A friend of mine runs a business that sells panoramic pictures. A number of galleries/shops stock these pictures on a sale or return basis. My...

I was trying to compact my dbase and went on auto pilot and clicked the compact button again while it was in the middle of compacting the first time. I can't...

Folks, Hi. I have an Access file that consists of a single flat file table. I'd like to create a series of tables that are normalized. I would like to do this...