Hi, all, I have a used car database, have about 2000 records, every vehicle must have a VIN(Vehicle Identification Number), total should have 22 characters,...

This is a three part question. 1st question: I'm creating a database for a pyramid type business. I'm giving each member a unique id by the auto...

Example: I'd like to take the date of birth date which is format like 11/14/1971 and the first three character of the firstname field example: Carol I'd...

I am trying to create a view which shows dates along the top, caravans along the slide and the data showing whether their is a booking or not. Any pointers?

I've just come into a new organisation to discover a very poorly put together database. Question: You can book a facility using this database but the...

Anyone here of being able to drag and drop information on an access form or report?

I have a field that records whether our is Very Good, Good, Satisfactory, Poor or Very Poor. How do I run a report which shows on the one report, the number...

I want to create a combo box with, in order, Detached, Semi-detached, Bungalow, Flat, Other but the choices KEEP appearing alphabetically. I would be...

Hi, I'm trying to create from scratch an inventory database using Access. The inventory will consist of automotive batteries. Each battery will have a part #....

I'm new to access and haven't gotten to know programming code yet. I'm just learning how to build a database with access tools. I've built a .accdb database...

Hello, I have 3 tables - employees, performance evals, and error codes. The error codes is more of a look-up table that is indexed by a unique number. The...

Hi, Awhile back in error, I created a db with multiple date fields (19 in all). All are due dates or reminder dates (which are calculated off of the due...

I am designing a custom database for tracking various pieces of software we use at my job. Each user has access to different pieces of software and many...

Hi Again, I'm going out on a limb here to see if anyone can help me with a design problem as I am pulling my hair out! I have a db with: Tbl_MAIN (well...

Hi, I am revamping a database to normalize the dates so that I can report on the most recent due date for each record. It is my understanding that I need...

Just thought I'd repost this and see if anyone can give me some advice.... I have one table Compl_Main_Tbl with unique Inspec_ID. We have a number of "sites"...

I'm stumped on how to go about designing this database. It currently houses a number of different job functions which are all tied to locations (Tbl_MAIN). ...

I'm not sure if this is possible but I have a text box (UWI) that needs some work. I am required to enter the UWI as 100153605001W400 because that is the way...

Had some help with this, went and bought a book (which is still a bit greek to me), and have played around some with the code. I have a main form with a...

I have two tables (Main and Detail) which have a one-to-many relationship. I need to tie into some company information and have been given links to two tables...