Search results

My apologies, I should have been more clear. I am receiving the error message only when using "Find and Replace" on the field "Organization," which is on sbfrmCompany. The Find function does appear to work in all other areas of the form except this one. Also, thanks for the tip about the...

Here we go.

Hello, I have a form ("Contacts Form") that I use with a few subforms on it. One of the subforms is "sbfrmCompanys" that has information on the contacts company. One of the fields in sbfrmCompanys is "Organization." Users used to be able to use the "find" feature to search for an organization's...

Actually, a contact can have a category without having a company. So, this won't work. Any other ideas?

Here is the relationships: Correct. Each Company can have many of the Categories boxes checked (they are yes/no fields), but not more than one record. Does that make sense?

Okay, so I created a new table -- tblContactCategory. PK is ContactCategoryID with fields ContactID and CategoriesID. I have them linked to tblContact and tblCategories by each respective table's PK to create two one-to-many relationships. Now, back to the form... I have tried to add a subform...

We (my director and I) want to use this database to store her hundreds of business contacts. Most contacts will have a company (but not always), and every contact will have a category of some sort (whether it's one check box or several). I created tblContact to store the contact's...

Thanks for your reply JHB. So, should my subform be linked to the pk in the main form isntead, which is an auto number? That would ensure there was always a value to connect them. I'm a bit lost. Any advice would be helpful!

Hi, I have a form based on tblContact with a subform based on table tblCategories, and another subform based on tblCompany. I have a one-to-many relationship between tblCategories and tblCompany, with the pk in tblCategory linking with a fk in tblCompany. All of the fields in...

Thanks Mihail. That cleared the error message. Now I have another issue I'll make a new post for. It never ends... :banghead:

Hi, I have a form based on tblContact with a subform based on table tblCategories, and another subform based on tblCompany. I have a one-to-many relationship between tblCategories and tblCompany, with the pk in tblCategory linking with a fk in tblCompany. All of the fields in...

I am really stuck on this. It seems like a simple fix but I am getting nowhere. I can't make that message make sense to me and I can't find any help by doing an internet search or from searching these forums. Any suggestions anyone has is appreciated!

Wonderful, wonderful! You were so right about how badly I needed to take a breath and relax. I guess this newbie went a little nuts wanting everything to be perfectly organized that I over-complicated things. I changed a few things with my tables based on your suggestions and all areas...

All of my form fields visibility property is set to "Yes," so I don't think that's the issue. Any other ideas?

Alrighty, thanks so much for the help, Linq! I've got a good start so far and have gotten parts of the form to work. I wondered if you could take a look and tell me what I am doing wrong now. It seems the website/products/# of employees fields, as well as all of the check boxes, are not wanting...

Hello, I have created a database to track our contacts for the office. I spent some time working on the relationships and making sure everything was normalized, as I've only just recently understood that concept. However, I'm afraid something got messed up in the process and I may have missed...

All, I have a form that I am trying to add some yes/no fields to from my table. Whenever I add the controls to the form and attempt to open the form in form view, I receive the dreaded error: "Type mismatch in expression." I can't figure out what is causing this error, or where to look...

Back to work today after a nice long weekend! Thanks for your information, linq. After more thought given to the project, I think the complication level is way over my head and too much for me to take on at this point, given my current work load. We are preparing to do some trasitions and the...

P.S. Did set the visibility property of the listbox to No, didn't seem to help though.

Here it is. Hope you can find something!