How do you guys go about with your table design... how do you make sure that it's right before proceding with the implementation/coding? Any pointers for a...

I just starting to use Access 2003 and will try to create some applications for our office. I would like to know what the best way would be to open a table...

i have a two column combo box with one column for employee number and second column for employee name. On the form both columns appear but i want to have the...

can you hide relationships so they don't show?

First, this is a handful of question's I'm asking and I'm just asking for suggestions. I understand this is my puppy but some of these issues are troubling...

Hi all, I posted the same question in access.gettingstarted forum but no answer, I think I may have posted in the wrong place so I am trying this forum. I...

In a db built for surveys, can I sort (rank) multiple numeric fields for one record? Each record has 24 fields ranking students on performance. I want to...

Question: How can I program Access 2000 to sequentially create the scheme for each new record: A001, A002, A003, ...A999, B001, B002, ....B999, C001, C002 and...

I am using Access 2003 and am trying to figure out the RowSource for a field in one of my tables. I am trying to limit the values that can be entered in said...

I have a pre-designed table that contains a memo field which I need to convert to a text field for use in analysis. I'd like to automate the process rather...

Before Christmas I was asked about the possibility of setting up a training database for the employees. Instead of typing out the fields for every table I...

Using Access 2003. I have a school volunteer database. Trying to figure out the best way to design my tables. The database contains families where the...

I am creating a form with a subform...the tables behind the forms are PatientData and MedicationRecord in a one-to-many relationship with strChartID as the...

Tried everything I can think of and it looks good right up until the new field is displayed

I have a question about splitting the database and making into an MDE file to distribute front ends. I have several reports in my database that run and use a...

Hello, First, I'm not sure if this a "tables" design question or "forms" question so I'm posting in both groups. I receive a daily force / headcount report...

I have a field which is a primary key field in that table. In another table, I set this field as autonumber but it disallow me to do that because I have...

I need to create an autonumbered field in my access 2003 database that looks like the following: DCR-07-000 The DCR is a constant, the 07 is the year and...

i've created a custom input mask (which is now a part of the input mask wizard) and want to remove it so that it doesn't appear as an option from within the...

I have created a table to capture the system date but it will not work. It says there is a "in table-level expression" error. For the date capture, I used...