Search results

Travis Hey, thanks for responding. I tried out your code, added an END WITH statement following LOOP, and got Error 91 (Object VARIABLE NOT SET). I wonder if this module has to be directly in the form from which the table derives its data. If you have any other input, please let me know...

Hi, I'm still a beginner in programming and the .Recordset stuff is troubling me a bit. Hope you guys can help a bit. I have a database in which patient appointments are stored in a Table called 'appointments'. Some days we have more than one patient and on others, we have only one or none at...

grizzes: If your salespeople don't mind, you can use ctrl-' (apostrophe), and it will automatically fill in the field with the data that was used in the previous record. As in: if you have a field called Product Type and you are entering "Electronics" for every single record, you can...

You have to enter everything in for a particular record, then on the form you have to move to a different record--either previous or next. You should have those record selection buttons (the left and right arrows) on the form that go between different records. Every time you want something to...

Travis Well, your magic worked. Thanks a bazillion. We've memorialized you in our credits. Have a good one. Todd

Travis, hey thanks. It's working better though still not to its full extent. I made all the changes you suggested but an error message (again...) pops up saying The Object 'Blah' is not Open. Where Blah = the Last Name of the current patient I happen to have the form on. I think the...

Travis, thanks for the help, although it's stuck with a MISSING OPERATOR syntax error, which happens right after typing in the last name. Here's what I have: I turned your public sub into a function Function SearchField(stFind As String) With Me.RecordsetClone .MoveFirst .FindFirst "Last...

Hi there. This problem probably requires a macro or code, but since it occurred on a form, I put it here. There are problems with the "search" button on a form which contains various names of clientele. This form has several subforms that are linked, but I don't think this has any bearing...