I need some help with table design. Below is the structure of just a few tables from a database. There is a One-To-Many relationship between...

Hi all: I'm a newbie to MS Access. I have an Access 2000 database with many tables and users can insert/update/delete rows to any of these tables. Is there...

I'd like to run a problem w/ you and hope to get some ideas as to what may be the most efficient way of capturing matrix data (and transferring an Excel data...

I have a database with four tables that I use and each month I get a new database with the same four tables in them with updated and current data. I have...

I need help with either importing or exporting tables from one Access database to another Access database. The tables from the two databases have the same...

I am in the process of designing an access file to sort and analyze data from a survey. There is one survey question that has multiple answers (respondent can...

I am about to split a large Access 2000 DB. The BE end will reside on a file server with 4 versions of FE distributed to a variety of users on their desktops....

My Union is starting a food bank for our members. We'd like to track who is contributing, Who is getting helped and an inventory of what we have available,...

I am wondering if someone knows how to create a validation rule in a table that would throw an error message in a form. Here's what I have in a table: Field1...

I have a question about table design (in conjunction w/ form design). Although this question is focusing primarily on table design, I'd like to start out...

Does anyone know why when you create a one-to-many relationship between 2 tables the line between them in the graphic does not show the 1-to-infinity symbols...

Hello there I want to write a code as follows for the table : CheckCriteria = Forms!! .Form!IM_Name I have a checkcriteria function which refrences to...

Hello there I want to write a code as follows for the table : CheckCriteria = Forms!! .Form!IM_Name The above code have a checkcriteria function...

I have the assignment to imporve a database's performance. The data is in a separate back end database that has just under 3 million rows. It has no index. ...

And now, just to absolutely mystify everybody, I'll suggest it CAN be done, sort of. Write a query that shows: Fred Gerbil Fred Snake Tom Bird Tom ...

Dear Friends: Format, Input Mask, and Caption are three things seen in the lower part of the Design View for Tables. They are not reflected, as far as I can...

Dear friends: Using Access DDL, I have not been able to use WITH COMPRESSION on a column definition. I don't find an example of this in the help, nor in some...

I am using Office 2003. Included is an example database named Northwind.mdb that has an image associated with each record. I am try to mimic...

If Tabe A is linked to Table B using a left outer join, everything in Table A displays on a query, even when records don't exist in Table B. So far so...

"PURVIANCE" wrote in message ... I can't seem to get a date...