Search results

Excellent, that worked! THANKS:D

I have a report with costs that I want to round up to the nearest .25. I have tried the round function but it will only round to the nearest .25 (rounds down if closer, I don't want that). This will round to the nearest quarter but not always round up. =0.25*Round([num]/0.25,0) I have...

Thanks for your suggestion!

I have two forms in my database. One for equipment and one for the network information. I want to open the frmIP from the frmEquip and be on the coresponding record by matching the NIC Mac address field. Currently, I can do it but it is done by a filter...I don't want a filter...I just want to...

Thanks a ton Jon K! That worked for me! I know it was a horrible standard to use....the users weren't very knowledgeable. You guys are great!

I have a table with Patient names. If the patient is deceased, they put *** after their name. Not sure who the bonehead that thought of that is. Anyway, I want to create a list of those for deletion. I'm having trouble with my query. Three columns: Patient Number, Last Name, First Name Example...

Ah, Great! I do appreciate your efforts! Thank you very much! Jeff

I appologize for not clarifying that. Sorry, about that. Thanks again.

My database is setup with a qryPatient as the main form and then tblData as the subform. Each Patient has several tests which are stored in the tblData. Your code is only searching on the current patient and data....it doesn't search through the rest of the patients. The link between form and...

Also, I put a MsgBox .Bookmark after the find, and it returned a "?". Notice, I had to use FindFirst I got an error trying to use Find. It said Method or Data Member not found.

OK, the code runs without error but it doesn't move to that record. Yes, the ProcNumber is a text field. I had to import from a spreadsheet they were using and they used 2k2 to designate year 2002...just great. I have the reference DAO 3.6 selected. Here's my code so you can look for typo's...

I was trying this from the subform.

Yes, I did try the ADO & ADODB. And then also made sure the reference was there to Microsoft DAO 3.x Object Library was there and unchecked the Microsoft ActiveX Data Objects 2.x Library, as the artclie explained, when trying to use the DAO.

I get a type mismatch error (same line) when trying the .clone.

Still struggling TTT I am still struggling to make this search in the subform work: textbox and then the go button. Any assistance is greatly appreciated! Jeff

I tried using DAO and I get a compile error: User-defined type not defined. Here's the code: Private Sub cmdSearch_Click() Dim rs As DAO.Recordset Dim strSearch As String Set rs = Me.RecordsetClone strSearch = txtSearch rs.Find strSearch Me.Bookmark = rs.Bookmark...

I am trying to do a search in a subform. I am trying to use the Recordset clone method. I have a text box on my subform (txtSearch) and the ProcNumber is the field on the subform that I want to match. I get a type mismatch on the line where I try to set rs=Me.RecordsetClone. Any ideas why...

Thanks, I appreciate your time. You are close to what I am trying to do. Your code seems to filter out only the "input" record. Can I just jump to that record and still show the other records for that patient? Like if a patient had 5 different procedures, your search only shows the one entered...

I couldn't get it to work at all. When I tried...it would only search the record displayed in the subform....if wouldn't search all records. I don't really know how to do it....I had just tried the wizard to create a button with the search feature. Thanks

TTT Really need some assistance! THANKS