I'm trying to determine the best way to design a basic database to track contacts who receive periodic mailings from us. I have created a Contacts table...

Hello, Im designing a database for people responsible for applications at my work. We have three groups, ApplicationOwner,...

Ok, so I am building a database for my friend's community group. Many menmbers of the group have children. I was toying with the idea of entering the...

Hi, In my database, I have a linked table called SOtbtext which contain 2 fields, FreeTextCode (Number) and FreeText (Memo) - what is puzzling me is that in...

I am helping to track a dailly contest. Presently using Excel. Contest has dailly results. Number of contestents vary each day, between 15 and 25. I am doing...

Using Access 2003. I have donor ID numbers in a field set by Autonumber (incremental). Perhaps this isn't the best way to do it but it worked fine for 10...

I suppose by "resolver table" you are referring to the table I've got which has PtID & Protocol_ID as foreign keys from tblPatient & tbl Protoocols. This is...

I posted a question yesterday (see below). Ken Snell referred me to the following article, http://www.mvps.org/access/forms/frm0058.htm, which I was able to...

On a continuous form, I have the following code: Private Sub pBin822IANCAudited_AfterUpdate() If pBin822IANCReadytoAudit = True Then ...

Hope someone can help.... I was asked to create a contract databse, however, there are over 100 contracts with a minimum of 5 pages, each page containing at...

I have a small(?) 4-table contact management/sales call report database that I need some help getting off the ground. It basically works but have some form...

Hello! I am looking for MS ACCESS programmers using Visual Basic and C++ in India or off shore. Anyone out there interested in work? Experience with MS...

I am interested in informed feedback on the use of Constraints, Primary Keys and Unique. The following SQL statement creates a Bands tables for a database of...

control arrays can be used in VB which reduces amount of code that needs to be entered. is it possible to use the same concept in MS Access which has...

Hi, I'm working with my first database and can't figure out something. I downloaded the "Contact Management" database template from MS. For the most part,...

I've been working with a database and I recently added a Check Box that I want to be exclusive to each record. However, when I click the Check Box for ONE...

I had a Access DB with 2 tables. After creation the size of DB was 400 KB. To this DB records were addded & removed frequently. Curently there is only one...

Perhaps a "sort of silly" question ... but I find myself doing something over and over I wish I didn't have to do. When I open a table the window it gets...

I am updaing a previously created database and continue to receive the #Name? error on form for a new field I have added to a table. I have checked the...

Is there a way to determine if a control is visible as a column in a form's datasheet view? Thanks, Matthew Pfluger