Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dickhob

    How to test for EOF on Query driven form

    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...
  2. dickhob

    How to test for EOF on Query driven form

    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...
  3. dickhob

    How to test for EOF on Query driven form

    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...
  4. dickhob

    VBA editor acts erratically

    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...
  5. dickhob

    VBA editor acts erratically

    .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.
  6. dickhob

    VBA editor acts erratically

    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
  7. dickhob

    VBA editor acts erratically

    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...
  8. dickhob

    Navigating to a specific row on a subform

    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...
  9. dickhob

    Navigating to a specific row on a subform

    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...

Part and Inventory Search

Back
Top