User Profile

Collapse

Profile Sidebar

Collapse
kjv1611
kjv1611
Last Activity: May 19 '11, 09:06 PM
Joined: May 16 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Whichever code you're using to set the control to visible/invisible.

    The "Detail" we're talking about is the Detail section of the form. On a continuous form, the detail section is where the changing list of records is listed. So if you have 100 records, you may have 10 of them on the form at a time, for instance.

    Post back to acknowledge whether that makes sense to you or not. I may not be on here much longer...
    See more | Go to post

    Leave a comment:


  • Select Current Record

    One note on this - you CAN specify the control for the current record in the detail section of a continuous form.

    Code:
    Private Sub ShowHide()
         'Make sure looking at correct record of course..
         DoCmd.RunCommand acCmdSelectRecord
         MyButton.Visible = Not(Me.NewRecord)
    End Sub
    That part of selecting the record may not be correct, I forget, and don't...
    See more | Go to post

    Leave a comment:


  • kjv1611
    replied to Excel Formula Question
    That code looks interesting, though I don't know of a current need, I could see the need in the future. Can you give an idea of how well it performs? I mean how long does it normally take for this to run and find the solution? Does it take "a while", or is it practically instant?

    Thanks
    See more | Go to post

    Leave a comment:


  • kjv1611
    replied to Memory optimization
    A guess

    If you are using objects, try releasing the object after each iteration (if possible in your scenario, and re-instantiate for the next iteration).

    --Not an expert on vb.net at all, just thinking about object usage.

    Basically, it SOUNDS like either 1 of 2 things is happening:
    1. Something really large is being opened in memory (within an object apparently)
    2. Or else some object is...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...