Hi gang, I've already been he http://www.mvps.org/access/datetime/date0004.htm I have 2 time fields, "Time In" and "Time Out". I have a third field, a...

Hi. Requirements have cropped up (of course!) that make me think I need a new table, or two. I'm going to list the requirements and hope someone can tell me...

I'm not sure if I should start a new thread here - but the last one went a bit off topic so... OK I have now split my database, (well only on my system) - but...

Is it possible to have two Primary Key in a single Table? Why do I ask this question? After many misdesigns, I understand that it is a mistake to join one PK...

There doesn't seem to be much information around about Access Pivot Tables, and I don't do much in Excel. MS Help is no help whatsoever. I'm trying to create...

I have to convert an access database to an oracle database. Does someone has tips or can someone tell me how to do that? -- Message posted via...

Is there a way to prevent a user from choosing (or even seeing) a value in a table in a form? For instance: I have 7 software version entries in a table that...

In the past I created an Access database front end for our end users for the purposes of querying our Oracle data. I noticed that in this older Access...

Hi, I have a table containing customer information. The unique value consists of a customer ID like this, 000000-0000, and it has been set it to Indexed -...

I'm trying to get a handle on normalizing my database to better manage a very large customer table. (1 million records...) My databases main function is...

I have 3 tables: TblA ID FldX Lookup_To_TblB_For_Product_Type Lookup_To_TblC_For_Product TblB ID

I am trying to design a database for my business. I do custom installations of electronics. For each job: o I have a customer; o I generate a quote or...

Background: I have a database I am rewriting in Access 2000 (split DB) that was originally written in VB 3.0 with Access 2.0. The database has about 70 tables...

I have a time field that I want to store hh:mm:ss. I can set the custom format to 99:00:00 and the user can input the time but no matter what I do the table...

Can anyone give me hints? All advice is important at this time

What is the Validation Rule for a Null Value in a table, because I am trying to eliminate Access's confusing error message and create a simpler Validation Text...

Hi All I have a database that call on specific records to display based on their assigned values. eg. if I enter 1, i get records that are listed as fields...

I work in a school that has students from grades 5-8. We have almost 1000 students (approx 250 per grade). Each student has the 6 basic classes and then the...

Hello there I have table. Is there a way to add auto number field to table with vb code?

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...