Hi, I'm trying to build a datamart using Access as our database. Ideally I'd do it in SQL server, but I belong to a business group and SQL server would...

I created a survey table in database...But my question is how can you create tables and name columns for a survey, if you were me??Are these enough...

I'm looking for help on database construction. We have a current database that would appear to be not normalised so I am looking for help on the correct...

Is there a way to set a primary key in the queries tab of Access? I would like to set the primary key before I run my select query or make-table query. Is...

hi got a table with Week code, Product Code, Quantity now i have done a crosstab with product code as row, week code as column and quantity as value. the only...

can if statement be included in the Calculation field in query?

Is there a way to make a primary key in a linked table. I don't have Access project set up, just regular Access and I don't know much about SQL. ...

Have moved from Office Professional 2000 to 2003 using Access 2003/SP1. My database transitioned without problem on two HP laptops but not on two...

Hi, I have a case where I don't want to save a record to a table if the user clicks the X in the upper right corner of the form. In the before update event, I...

Access 2003. Database was split using splitter to Objects (Forms and Queries) and DataTables. Links all appropriately and automatically established by Access....

I have an old database with a form to set report criteria. It works fine in Access 2002 and 97. I have recently upgraded to Access 2003 and the macro...

I have been fooling around with Access on and off for a couple of years -- mostly simple applications with only a few tables and simple relationships. I know...

Hi again, I have a main table, Policies, which contains general information pertaining to all policies regardless of their type (i.e. LifePolicies,...

im creating a database in school (university). i have 4 tables. one table has two primary keys. each of those keys are seperate primary keys in other tables....

How can I set an autonumber to start at 500, rather than with 1? Thanks! -- Vandy

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

i have a query which selects from my original table all with a price of zero. this is then passed to a form to allow the user to enter a price. after this...

how do you create an auto number field in Access using DDL? the Auto things it an Auto..!

Hi: I’ve used a program very similar to Access, called Alpha Five, for many years. I created a checkbook application in A5 that works great and now I want...

I would like to be able to highlight different records in my database. Does anyone know how to change the color (font or fill) for individual records...