I would like a suggestion on the best way to design a membership database in regards to single and family memberships. I am taking over this database from...

Could someone please point me in the right direction or offer some advice... I am trying to import a table containing names and addresses in to my...

I need to convert an enrollment date to the month of enrollment. I have tried several things with no success.

I would like have a control button to perform a comprehensive search for names, dates, number, etc. I am able to search specific queries based on matching...

I copied a database that I have used for years. It has always worked on these two computers. I made some minor changes to a form using Access 97 SP2. Everyhing...

Hello I made a replica set and now when I want to synchronize I get the message: the search key was not found in any record! What does this message...

Hi all, In one of my tables there is a field defined as date/time. When I add a record for example 07-12-2004 12:15:00 this is ok. but when I add a record...

Hello I am a bit confused on table construction. I thought I was ok with Access but here is my question. I want to create a form based on a table....

I have a database that is the design master. I had copied a table (i assume the parent)and pasted it(table 2). It was redesigned to fit my needs. I then...

I have an application developed with a Spanish access version. When running on the English version crahes. Is there any way to avoid it ? Joseph

I am creating a table that is being used to collect recipes. Each recipe has a varying list of incredients. Are my only two options A Combo Box A Memo...

I have an existing Access 2000 database with internal tables and existing forms, reports, etc that use those tables. I want to dump the data out to SQL which I...

I have an application developed with a Spanish access version. When running on the English version crahes. Is there any way to avoid it ? Joseph

How can I enforce referential integrity in unary relation, as i enforced in binary relationship.

How I enforce referential integrity in unary relation, just like i enforced in binary relationship,

anyone know how to have one field for say author and then swop the text round as in enter john smith and save and display as smith, john

Hello, I created a table using MS Access 2003 (Which uses Access 2000 format database), the default value for the attribute, "Allow Zero Length String" has...

When I look at my relationship window I have duplicates of most of my tables. They arn't there in the data view of my tables. If I delete them in...

I currently have two tables: * CustomerData, with fields CustID, Country, and some other misc fields * CountryData, with fields Country, Year and...

Can anybody tell me how to customize the contact fields so I can use outlook much like I use ACT 6.0?