Search results for query: *

Thank you so much for such a quick response and quick solution. Both of the codes are returning the same results. Great forum, but greater people!

Private Sub Search_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs = Me.Recordset.Clone rs.FindFirst "[OLD_PN] = '" & Me![Search] & "'" If Not rs.NoMatch Then Me.Bookmark = rs.Bookmark Else MsgBox "Please Enter a Valid Part Number" End...

Hi everybody, I have a combo box that I’m using it as a search for replaced part numbers. Right now combo box is searching only in the old part number field. Can I set up the combo box to search in new part numbers as well or I have to create a second combo box? Thank you all!

I restart everything from the beginning and I get the message not found. I'm sorry to ask so many questions... to much espresso... But how do I sync the 2 combos and when I open the form all the fields to be empty? Cristian

I've done it but nothing happens. Cristian

One step closer to the goal. I could not find the option 1 (Remember this value for later use). I don't know if this is important, but I use Access 2003. Is working great with some exceptions: 1. I create 2 combo boxes in the same form. Looks like they are independent. I search an old part...

Yes, it will. I create a form using the wizard. For Tables/Queries I used table. I added all the available fields and modified the form in design view. Deleted first 2 fields and replace them with combo boxes with option "Find a record on my form..." I manage to create a single form, but when I...

Ok. I've done that, but now instead of having 1 line I have as many lines as I have in the table. I search a record and if is found all the lines are filled with the record name. The other properties are not shown. This is the code I have: Option Compare Database Private Sub...

These is some of that code. I looked over all and nothing apeares as a procedure or function. I'm looking in the wrong place? Private Sub Detail_Click() End Sub Private Sub Detail_DblClick(Cancel As Integer) End Sub Private Sub Detail_MouseDown(Button As Integer, Shift As Integer, X As...

I hope this is what you need. Name Old Part Number Row Source Type Table/query Row Source SELECT [Superceded Items].OLD_PN, [Superceded Items].NEW_PN, [Superceded Items].ECN_NO, [Superceded Items].CHANGED_BY FROM [Superceded Items]; Column Count 4 Column Heads Yes Column widths 1;1;1;1 Bound...

Thank you Remou for the fast response. Yes, my form is based on the same table that the combo is based on. I create the form with option “Find a record on my form based on the value I select in my combo box”, and still not working. Cristian

Hello everybody I’m having problems with the combo box. I have a db with the following fields: OLD_PN; NEW_PN; ECN; CHANGED_BY. When I’m doing a search, if I enter a part number that is not in the db I get a message that says that the item is not in the list. That’s great, but when I have a...

Hello! I do have that set to yes (I have options Yes or No) C

Hello everybody!, Darrylles I go my self a very similar question and I hope is no problem to post that here. After reviewing the posts I feel that I'm very close to my expected result. I use a combo box to find data entry's from the table. When I enter a value not in the table I get a message...

I think I have it! I split the db and convert the front end table in to mde. On the converted db I hide the table. You can’t design the form, you can’t see table. Objective achieved!!! Thank you again for your knowledge!

Thank you all! I like challenges and new trails! Darrylles, I did a test on your directions, but I have two forms. One data entry and one search part numbers from that data entry. Both forms look to the same table. I will have to find a way to start both forms in the same time, or to have a menu...

Thank you for the prompt response! This is a tricky way to hide db. But this can get of hands very easy. Is enough one person to know the back door... Also, I have 2 forms in the db. I don't know if you can put both in the Startup... I'not a MS Access savvy... :( Can you have some setings at the...

Hello everybody I have a db on the network and I created 2 forms for the users: one for data entry and one for search ability of data from the previous form. Users will have access to the db thru the regular login in Windows. How do I put restrictions that user to be able only to enter data and...

Thank you for the prompt response. I will try to do that. I'm new user in Access. If I will have any problems I will post it. Thank you!

I'm so sorry about my way of describing the question. I have a data base with 5 properties. I was wondering if is possible to have the following: When I open the table in Object -> Tables to display only one row, and to have like a pull down window and see all the entry’s in the table. I tried...