As my database is used, the tables get filled with products that are no longer available, orders that are one-time only, customers that are obsolete, etc. In...

Hello Everyone, I have a database that I use to keep track of Reservations for my rental Agency. The application so far has worked as planned but I am not...

i'm trying to convert a currency field ie £125.00 to a word field ie one hundred and twenty five pounds, anyone know how to do this please. found something...

I'm importing HTML into an Access table and then allowing the user to view this data through text boxes on a FORM. The HTML tags are currently being stripped...

Creating a Data Access Page in Access 2000 to display information on a company intranet. How can I make the fields display only and not allow edits or data...

I posted a database design question earlier, but am having trouble determining what would be the best solution. First of all, thanks to Tim F. for your...

Hi, I'm trying to put two coclors in the detail section. But whenever I put the back color, the whole section changes color. I'm rying to box a part of...

Good morning, Does anyone know of an app that I can use to go through my tables and make the Field Names, Formats, Data Types, etc. all the same? I have a...

I am trying to create a database that keeps stores by sample months. They fields will include Review Number Case Number Sample...

I have an Access file that has a switchboard in it that was created in MS2000. I am now using MS2003 and I can not get in to edit my queries and or files. ...

Is it possible to set up an auto complete function in the name fields to prevent duplicate records? Thanks

I have a table column named RATE as CURRENCY and set up as double, auto decimal. I input number 1.4931. After save it, I change to decimal = 2. It display...

I have a table with 10,000 addresses. EAch address is in one field: 123 W Maple. I am able to convert this address into two fields: Field 1 is 123 and Field...

I need a random sorting of 50 records for a specific person in a database (identified by a 4 digit number). How do I get this or can I even do this? Is it...

Hi i have a whole load of records with a field which currently contains a numeric figure. It is set to long . The figure represents the number of...

I all I am quite new to all this database designing. I have 3 tables: Suppliers_table, Call_table, Transaction_table. The Relationships are as follows:...

I have a client/case database with multiple tables and users. When a user modifies any field in a client or case record, I record the current user and the...

Hello, I am trying to develop a "Record Keeping" database. The purpose of this database is merely to print one report that lists all of my important...

I'm a new user and I'm designing an estimating database so that more than one person can use it at the same time. I have it working pretty good for...

-- Gil