I need have memo filed for my table. I would like to know what are the difference between memo and text field. I know that text filed has maximum 255...

I am in the process of writing a report but for some reason my footnotes are appearing on a preceeding page as opposed to the bottom of the page where the...

I will admit I new to designing databases, but I am not a computer novice by any means. I am trying to design a simple database about ocean currents at...

On this one computer, running Windows XP Pro SP2 and Office 2002, when I want to use the Linked Table Manager, and get to the point of selecting the new...

I am responsible for an already existing database that will have infrequent updates/changes to the existing records. I would like to be able to keep track...

I have a table with several fields set up. The first field is Product # (AutoNum) and the last field is Unit Price. I want to create a form with a combo box...

I really screwed up I bought 2007 and put it in my PC without removing 2003 and now nothing works. Any command developed with Event Procedures is not...

I'm building a process-flow type program, keeping track of 20-30 steps and sign-off dates and emp Ids. I'm wavering between a flat table design, with all...

Greetings; I have a database that I need to create that has many single checkboxes. This is a medical assessment and has many different sections to rate. ...

I'm fairly new to Access, and I'm trying to create a database with multiple relationships. This is what I want to do: Search a student to find: The Class they...

Hi: I create a table with 5 field without any records, and i want to import a text file to update the table. I have a field "ID" which is primary key...

I've about run out of things to try so maybe you all can help! I've got an old Access 97 based VB application that was not well documented and the programmer...

I have to track 4 generations of pedigree for horses. I created a pedigree query using self joins by copying the Horses table and joining the sire and dam...

I was wondering if anybody has done this or wanted to do this. I want to relate row headings in table a to Column headings in table b. or put another way I...

Dear Friends I have got 2 sub table with autonumbers -both are primey keys There may be problem while consolidating data of 2 tables in querry So I want to...

How do you set up a date field in a table that reads just the month and year (no day). Ex. 05/08 or 05/2008. I tried an input mask and it comes out...

Which is better to use prefix - pk or suffix -pk or none. I honestly like using suffix of _pk, but if I had a reason to use the prefix version I would. I...

I have designed a form that will display a main form & subform in response to a parameter entered by the user. I've designed a parameter query for that...

Hi all, I have a question about a table and relationship design. I am building a Task management system for my current workplace (well an upgrade of an older...

I have designed some forms that use a combo box to pull from a table. The table has a list of ~ 50 choices, and despite alphebetizing the source table, I...