I have created a couple of Dbs which the table structure seemed to simply fall into place, it was just logical in my head. That said, I am working on a new...

I am a self-taught novice (the worst kind!) so am hoping I can get a nice simple answer to my question. First the history: I want to re-build a database...

I have a table that lists employee names, employee ID, Badge numbers and other info on the employee. This table is used in multiple queries. When employees...

My last two posts (on the "microsoft responds...." thread never showed up.

Every now and then, some or all of the database objects that i have assigned to "custom groups" get unassigned and appear in the "unasgined objects" group....

I am fairly new to Access and am designing a new database. I retreive all of the data from various Excel worksheets. I have 5 tables that I will update from...

Office 2007, just upgraded from 2000 ( OMGOODNESS!! What a flippin' NIGHTMARE!!) I am simply trying to import a tab delimited text file into an existing...

I have a table which holds the ID, DivisionID, Division term (ex: 2007-2009, 2009-2011), followed 10 fields (type = number) for the 10 officer positions. I...

I'll try to describe the situation pretty thoroughly and then I have a pretty specific question. For an Inventory database, we are trying to keep track of 2...

sorry for the cross-postings - not sure where this best fits. running access 2k, in front/back split configuration. focusing on front end application. my...

Here is my challenge. My work has a wretched almost unsearchable "database". I am trying to cobble together my own relational database from that...

I have PMs that are due - sometimes within 1 day and sometimes within 3 days. I record the date done and have a query extract the next due date. When that...

This is more of a design question about how data should be stored in a table. While importing information from Excel, some records in the same field have...

on just a PART of a field? Here's the structure so far: Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins. Here's the design & some sample...

I WOULD LIKE TO ACCESS A TEMPLATE THAT WOULD HAVE DAYS ON THE ROWS AND MONTHS IN THE COLUMNS. DOES ODDICE 2002 HAVE SUCH A TEMPLATE, IF NOT WHERE CAN I FIND A...

I have set up 5 different queries to calculate one specific total each. I have also set up 5 accompaning forms. They work great. When I try to produce a...

I am using a simple form for the user to enter data into the main table. one of the fields available is "Box Number" and each of these boxes holds 16 items....

Hello, Not sure how to approach this: We have an inventory database that has a variety of item types. Workstations and printers have quite a difference...

I want to add a child table to my table and using one of the primary key of the table. For example: MyTable is PKey1 PKey2 PKey3

Hi Karl, You’ve answered a bulk of my questions so a special thanks to you. I sure appreciate all the contributions you make. You’re always helping...