Recent content by rothjm

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