Tables

Help with normalization
I have a table that I need to normalize. It has dates that must be stored, they are project stop and end points, like foundation started, foundation completed. What is the best way to store dates? Should they be a separate table by themselves with just a key? I then have : Project number Project School District... 25 Jan 2010 16:15

VSFLEX3.OCX install
Hi Diana, at my knowledge the VSFLEX3.OCX is an active x compound that's installed with Microsoft project. If it isn't used in your access application you just can unchip the reference in the VB window (Tools -> References). If it's used and missing you'll have to install it as an add-in. Be sure it's correc... 26 Jan 2010 00:03

How to change the path to a split database file
I recently split my database and it automatically placed the be version of the file in My Documents. Where do I go in Access 2007 to change the path if I move the file from My Documents? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/201001/1 ... 25 Jan 2010 20:45

Avoiding Redundant Records
It is my understanding that surrogate keys are generally recommended to ensure uniqueness of records. Is it not true that using surrogate keys implies taking extra precautions to prevent duplicate records? I mean, with surrogate keys there is nothing to prevent the proliferation of multiple records all contai... 2 Feb 2010 17:26

como corregir el error:No se reconoce el formato de base de datos
Como puedo corregir el error: No se reconoce el formato de base de datos actualmente elabore una base de datos con access 2007, pero al ejecutar el programa elaborado en VB me presenta el aviso de error Que version de Access debo emplear para no tener problemas con VB 6? Gracias de antemano ... 21 Jan 2010 13:29

Prospective Client Tracking Database - stevie is PIMPing again!
"Steve" <notmyemail(a)address.com> wrote in message news:eTG707rmKHA.2164(a)TK2MSFTNGP02.phx.gbl... I provide help with Access, Excel and Word applications. My fees are very reasonable. Let me work with you to design the tables for your database. I have worked with numerous customers designing the tables fo... 21 Jan 2010 13:29

Question and Answer tables
I'm trying to create a set of question and answer tables, similar to the tables in Duane Hookom's "At Your Survey" sample application. In his answer table, the field for the response value is type Text. My question: What do you do about response values of other types, such as Numeric, Boolean, Multiple Choice,... 21 Jan 2010 00:13

Report page break problem
Hey - Access 2003, vista, I have a DB that manages reports of researches. Each research is in a separate report (same access report, but printed in a filter mode). Some time I need to print a bunch of reports in one time, so the filter is using a query to show all the researches relevant. My Problem is - I n... 19 Jan 2010 14:41

How do you normalize a table?
I've been user of Access 2003 for a while and am ok using databases but somehow lack practical knowledge when it comes to redesigning or normalizing existing database and hope someone can guide me step-by-step. I'm trying to redesign our dog training club membership database. Out membership is based on househol... 20 Jan 2010 02:57

Tables and relationships?
First, the overall objective. A few others and I work in a dispatch office in a homeless shelter. (I will just be upfront about it.) We are responsible for … scheduling the trucks to pickup donations, keeping track of pending pickup and the expected items, and keeping track of past donations incase the IRS q... 20 Jan 2010 14:04