Search results

i get the following error when i try to manully add to the query "cannot add record(s), join key of table "publisher_contacts" NOT in recordset so what does that mean? how can i fix it? is there a relationship missing???? :confused: :confused:

I have a form in which you can enter information in different fields. When you are done and press tab thru them all. it wont save the record. You can try adding a form but you cant. The buttons are not grayed out. You can click them but there is no effect. What can I do to fix this? The...

Cannot Add Records "join key of table 'Publishers_Contact_Type' not in recordeset Cannot Add Records "join key of table 'Publishers_Contact_Type' not in recordeset What does this error mean and how to I resolve the problem? :confused: :( :( :confused: Any and All Help would be...

oh...ok.. and do u have happen to know what that vba code is?

whoops sorry about that. i was reading urs to get help w/mines and mistakedly put my question as a response to urs. sorry again!

I have a form w/a combo box named Category Name. Category name is a pull down and has a bunch of category names. What i want the form to do is when the user picks a category name, the rest of the fields get filled automatically, but I am having trouble with this. Next to Category Name (combo...

Form not working I have a form w/a combo box named Category Name. Category name is a pull down and has a bunch of category names. What i want the form to do is when the user picks a category name, the rest of the fields get filled automatically, but I am having trouble with this. Next to...

got it thanks! i had to change one of the fields in the table to be indexed w/duplicates...and now its one to many as i wanted thanks again! :)

i have a one to one relationship I need it to be one to many. how can i change this? :confused:

if its not the relationship..what else could be causing this error to occur? b/c its still not fixed it wont let me add any new records to the subform.

"You cant assign a value to this object" I keep getting this error when trying to add a record in my subform. I beleive it's due to the relationships. It's one to many and it needs to be one to many but the otherway around. Meaning the one that's right now set up as one need to be many and...

problem solved hey i got it to work thanks! the data entry was set to yes..when i checked again today.. so it put it to NO and wallah it worked :) thanks again

zipped my database the two forms that need to be fixed are: Installed products form 2, re_use_availability_form. the problem in the two form is...when you enter data in the subform...and then navigate to a different company and product...(the bottom scroll)..then when you go back to the...

data entry = No already was on NO.

yes, they must be..cuz the correct values are in the tables.

Hi, I have a form with a subform. The form allows to scroll through all the records. The subform is to save an individual record for each record in the main form. For example, the main form displays Company Name IBM. Then the subform has information about IBM and saves that. The use can save...

i figured it out. thanks anyways all :) :) :) :) :) :) :)

i have a field named publisher name in which you obviously type in a publisher's name, but for some odd reason it keeps giving me an error "Please enter a value between 1-10!. This error message was a data validation/rule I had created for a group of fields named product risk criteria, product...

thanks i got it to work :) :)

You cant assign a value to this object?? Why am i getting this error? How can i fix it? It comes up and doesn't allow me to add in the form, but then after clicking ok. I am able to enter the data and it enters the query. But it is still causing problems. When i open up and view the tables...