i think i may be making things over complicated and need to know if there is a simpler way of doing things compared to the way i am doing them It is a...

I am designing a database program for a Fantasy hockey league. table A gets Players current stats from an excel spredsheet it is linked to. Table B is to...

I just inherited a large Access 2K3 application that is designed with 1 front-end mdb file that links to one of 3 dozen back-end mdbs. Each of the back end...

I'm working on a project and have very agrewssive time restrains so don't have time to create from scratch. I need an access 2000 database template for...

I have a very small Database with 4 tables a few qrys and frms. This database has been used for years with only one table. Recently I added three tables to...

Due to some remote user actions the My database became in accessible. The only sign of living was by the start: AOINDEX is not in this index. The socalled...

I have a report that relies on a query of a table of customer specific data (imported fr Excel) joined with a couple of other tables whose content is fixed. ...

This may be more suitable for the new users section since I'm a new user, but it's about design, so I'll try here first. I've got a monster spreadsheet I'd...

Hi, If I have a form showing results of a query how can I get them to automatically rerun/refresh the query each time that I open or close the form to give...

Does anyone know how I can open a database file and have a form menu open up automatically as a front end and hide the back tables and queries? I know you...

I added a table to my Access 02 back end and now want use it as a look up for an existing table. Since I need to update all my users backends, I need to do it...

How much memory is needed to store memo fields? Would it be more efficient to create a large text field?

Here is my situation. I already have a database with a list of all the parts our facility manufactures: PartID, PartName, PartNumber, etc. I need to create...

One of our teachers is trying to create tables in an Access database. When they design the table and have every field as a text field, the user is able to...

Is it possible to re-number an Autonumber that is the primary key on a table? For some reason my autonumber is skipping in sequential order and when I create...

i would like to have a number required in a field, but only when a specific text is present in another field of the same table using Access

This is probably a bit of a basic question but since I am new to both database design and access it has been a challenge at times to get my head around...

I am setting up a series of look up tables. Users will be restricted to the lookup table list via a combo box in a form. the data being listed is text. On...