Recent content by KirstenII

Hi Rich... That's a very good logical suggestion but I did try that...no luck. Unique records property has always been set to true and still is...this is causing stress. I'm going for a good strong drink soon.

You guys have been v.nice to me. Thanks, I appreciate it. Marion, I've been trying some of your ideas, and you're right, I can't update the query. I also can't figure out how to adjust for that. The relationships seem okay, but that's my real weak point, so who knows? I've got three...

Thanks so much for the quick response, RpBertS. It's nice to know there's someone out there... I'm sure I have the correct query name and data source as it does do exactly what the previous query did. I just tried deleting the query from the form's record source and re-entering it, but...

I did a dumb thing yesterday. While I was tidying up my extraneous "experiemental" queries and forms, I actually deleted a select query that I had based a necessary form on. The form obviously doesn't run without the query. I redid the query this morning and everything seems fine...except for...

Sorry, I'm not following....

I'm back again...thanks for all the help so far. You guys have been far more useful than all the books I've been trying to learn from. I have a mainform with two subforms on tabs...one-to-many relationship with both subforms. What I'd like to do is be able to have a box on the mainform that...

Thanks much for the suggestions. I didn't realized that basing the form on a linked table would cause so many problems. But I've got things sorted out for now....

I have tried to put in a command button on a subform using the command button wizard that would delete just the record in a subform; however, I get an error message stating: "A problem occurred while Access was communicating with the OLE server or ActiveX control. The expression may not result...

Been away for awhile but finally got a chance to try your advice. It worked well; thanks again for your help!!!

I am still having problems with my primary key. I am using "Unit Number" as my primary key in my main form. I would like to use a command button on this main form to go to the related record in another form in order to enter and view data. It seems as though I have the link established...

Background: I have a mainform that is linked to a table...also on this form is a combobox that allows the user to scroll through all available records on pieces of equipment and select the one he wants to come up. On this form is a subform dealing with service dates on this piece of equipment...

That worked quite nicely, thank-you very much. I don't know VBA yet, so this has been a pretty steep learning curve. One more question... Would it be possible just to go to the selected record rather than filtering out the other records??? I would like the user to be able to select the record...

I'm trying to teach myself Access 2K, but there's a couple of things I can't get to work. How do I link the selection that's made in a combo box on one form to the related record on another form? I can get the other form to open, but not to the correct record.