Recent content by dickhob

I hope I can explain this clearly and still be brief. THINK PLYWOOD. We are assembling laminated parts of varying complexities. The order and placement of the various parts are critical. A series of drawings have been made to visually show what part goes where. Each lamination has a...

The ME.Recordset.EOF does not appear to be working, but it may be my placement. I put it in the form ONCurrent event. In debug I can't display a true/false value, but if I test for FALSE my eof code executes. I know I am getting to the end of the recordset because it contains 130 records and...

I have a single sheet form driven by a select query. As the user completes information I control the advance to the next sheet by setting the form’s cycle property. When I come to the end of the file, the form hangs. I have EOF processing to do but can find no way to test for EOF. Is there a...

I think it must be somehow assoicated with open objects. Last night I changed the font back to Courier (after changing it per the recommand of the KB article) AND made sure no unnecessary objects were opened. (I do a lot of testing when 3-4 forms are opened). Today, everything is working fine...

.Net does no good if your clients use A2k. I seriously doubt they are going to swap out 3,000+ users because I have an editing problem.

Thanks for the suggestions guys, but I still have the problem. I can't believe this is something we have to simply put up with. Anyone else have ideas or better yet a fix? Thanks

Help, I'm going nuts! About a week ago, my cursor in the VBA editor began to act erratically. When I type and press a space, the cursor backs up to the end of the last charater. When I key in a quote mark I get double quotes and the cursor positions before the quotes- this happens a lot when...

PHV, I've been playing with your suggestion all morning- no luck. Here's some code: Dim rs As Recordset Dim sfRows Dim x Set rs = Me.sfrmPly.Form.RecordsetClone rs.MoveFirst ==== I can't get by the SET statement- Error 13 Type Mismatch. I'm not sure this will work...

I need to navigate to a control on a specific row on a subform. I have an control called PLY (think “line item #” in an order processing appl). A user supplied search field = txtCurrentPly. (row selection via clicking is not an option) I can get to the subform. I can get the number of rows...