Search results

When I click on "Link Child Fields" I get an error message in the Subform Field Linker that says "Can't build a link between unbound forms". I get the same message in the Link Master Fields. I don't see any unbound forms!! Also, I know what the primary key is in the master form, but what is a...

Sorry, was out of the office yesterday. The subform contains information held in the CCP dbase table such as DateSTarted, DAteAwarded, LetterSent, etc when I try to make a subform connected to the main form, the information doesn't carry through. I can click from subform record to record, but...

ok, that takes care of the part of the form that's based on the master dbase query. Now what about the part of the form that's based on the CCP dbase? Is this a subform or what? And do I base it on the CCP table?

If I understand you correctly you don't need to setup a relationship. In your CCP dbase you have the main table linked and then a query that filters out the CCP contacs and this query contains the AutoID of each record, correct? TRUE/YES I would base everything in the CCP dbase off of that...

Rob, I am gratefui for your assistance! In the ccp dbase, I linked to the master dbase, then created the query on it to filter just the CCP contacts. I tried creating a relationship from the AutoID in the master dbase to the CCP table but since there was no "common" denominator didn't know...

Yes, I can do that and it works well. However, when I try to get the CCP data in the CCP table to match to the query in a form, I can't get it to work. If I use a subform, the subform goes page to page to page; but doesn't move the main form information, therefore it isn't "connecting" to it...

I am completely stumped and was hoping you could help me. I know I've done this a couple of years ago, but for the life of me I can't remember how I did it now! I have a master dbase that has a table with Name, Organization, Organization addy, phone, email as well as home addy, phone, email...

Ok, I've created ID# field in each table and linked them so the relationships are set. Now, how do I find the duplicates in each table? Suzie Smith at 101 Main St in Duluth, WS may appear in the CCP and the NAC but not the Main table. How do I find where the duplicates are? (hope that was...

hmmm guess I didn't explain myself well .. sorry. Linking them isn't the problem. Finding a field that is logical in each table is the problem. I think I'm just going to have to create an id field in the two tables that do not already have it and assign the numbers to like records so that...

Ahhh! Field List never showed on this. So went looking for it on toolbar. Clicked and voilá! Thanks so much! Appreciate the help

This form is based directly on the table. This is how the information gets into the table. It's not based on a query.

Yes, I thought so. However there is nothing in each that is a specific to that record. I thought about creating an id key for each and comparing the records, then assigning the id keys to be the same in each. However, does that link each database then? Does the information flow from one to...

I need to add another field to a table that has already been created, saved and been in use for a while. I need a field called ContactType - no problem - added it fine. I used the Lookup Wizard to create the appropriate names, either CCP or NAC. Saved the table and went to Forms to add the...

I have 3 databases, NAC, CCP, Master. These weren't created by me, I'm coming in behind and trying to make sense of this. The President of our company wants the NAC and CCP dbases to link to the Master for name, address, phone, fax, email and contact type. All other pertinent information will...

Ahhhh! Thank you, Sohaila. Appreciate it greatly! *goes off to kill bugs in databases* :p

I have created 4 databases for different users in the same office on same network but for different uses. In two of the databases, the labels work perfectly well every time. However, in the other two databases, the first time the 5160 Avery labels are created, they run fine. However, the next...

Thanks so much for replying! The dates have already been changed to reflect the correct years, so I won't be importing again. However, I think you have hit the problem. Knowing the users of the Excel sheets, I am sure they didn't change the date column to format as date; but left it as...

We imported data from Excel into Access. The dates that were 2003 and 2004 in Excel changed to 2002 when the Access database was opened. This has happened twice. It takes a great amount of time to correct this. Can anyone tell me what happened? I didn't do these imports and don't know if...

:p Heheh ... that's what I finally did. Maybe if we're lucky, the next upgrade for Access will include this :D :rolleyes: Appreciate all of your help ...thanks so much. :D

UH OH Well bummer! My fix worked for that paragraph ... but when have a paragraph with few words on last line, it spaces them all the way across ! Noooooooooooooooo! Any other solutions:? *tears hair out in frustration* This seems like it should be ever so easy and I'm lost!