Search results

Thanks for the help. That seems to do the trick. I have one more question if you have time to help me. I have a search box at the top of that screen capture. I have the following code for the search: Private Sub OffCitSearch_AfterUpdate() 'Find the record that matches the control...

Sorry for the long wait. We've been getting ready for an audit and things have been really busy. I have attached a shot of the screen. Things are working ok but there is one little kink in the system. The subform 'Memo and Ressponse' is combining all records of the same 'OffCit'. I need...

I made a database that was working fine. It was only after I had finished the database, and data was being entered, that I was informed that the field I designated as the primary key would not work. Origanally, I used 'OffCit' as the single primary key. Now they tell me that one 'OffCit' can...

I've tried several things from different people and none have worked. I think I have a different version than some people. Or maybe I'm just sutpid. I have Word 2002. If anyone has some other suggestions I would love to hear them. I'm in the process of creating a brand new query for this...

I tried to do that but couldn't find anything related to a query. Thanks for the help though.

I have a Word document that is supposed to be tied to a query in my database for a mail merge. For some reason it doesn't work. This whole thing was created before I started this job so I'm not sure what query is linked to the Word document. Is there a way to tell which query is linked other...

This is probably a really simple question that I am just overlooking the answer to. However, I can't figure it out. My report is linked to a table (Complaint Register). One of the fields in this table links to another table (Product Line). They are linked by 'Product Code'. My problem is...

The form view is attached to my first post. The design view is attached to this post. I have 15 combo boxes on the form for 'Memo Sent To'. There is also a box for their job title next to it. The records store everything right. I just can't get the right number of combo boxes to display for...

Thanks for the input. However it's telling me that there is a 'Else without If' when I try to run it. I guess I am overlooking something small but I tried to put this in the onOpen event and I can't get it to work. If you have any further help I would appreciate it.

Thanks anyway.

Thanks for the help. I'm still confused though. This is the code I put in on the 'On Load' event. Private Sub Form_Open(Cancel As Integer) If Me![Memo Sent To5] = Not Null Then Me![Memo Sent To5].Visible = True Else: Me![Memo Sent To5].Visible = False End If The Cancel as...

When my form opens only certain combo boxes show. I have set the others to show only after I click on the preceeding box. My problem is when there is data in one of the combo boxes that is hidden, it won't show. I have attached a screen shot. The shot is when the record is first opened. It is...

Thanks CEB!!!! That worked great. I figured there was something simple I could do. As usual I make everything harder than it has to be. I guess that's all part of learning from your mistakes. Thanks again.

I have a form that opens as soon as the database is opened. There is an attachment showing the problem. The problem is that it opens in the middle of the form. The form is not maximized(not that it matters because it opens this way regardless). If I want to see the information at the top of...

Thanks for the tips. I'll play around with it and see what I can come up with.

OK. I'm not real sure how close I am on this. I have a feeling I'm not too close so I was hoping I could get some help. I have a database with 11 tables. These can be seen in the screen capture attached. For the 'Action Taken' table there are 10 fields for 'Departments Involved', 15 fields...

Thanks for the input everyone. I really appreciate it. It seems to be working just fine. I will also try the form and subform approach and see which one my supervisor like better.

I have attatched a screen shot of the form. My supervisor would actually like to have all of the combo boxes set up so that they can add an additional one if needed. They mentioned possibly hitting the TAB button, or some other button on the keyboard, to open another combo box. The 'Memo Sent...

I was wondering if you can hide a combo box and then while you are in form view have it appear. I have a form that has 15 combo boxes for one section. The section refers to a table called 'Memo Sent To'. Very rarely will I need all 15 boxes. Most of the time I will not need more than 4-5 but...

Thanks Thanks for the help. I was starting to think you couldn't do it but I wanted to make sure. I will leave it like it is.