Recent content by pharrison

  1. P

    Form moved too far down 'page'

    OK, thanks for your help Keith - I will try the gradual migration if this ever happens again.
  2. P

    Form moved too far down 'page'

    I think this must have been an Access glitch. The problem seems to have resolved itself.
  3. P

    Form moved too far down 'page'

    Also tried: Private Sub Form_Open(Cancel As Integer) DoCmd.MoveSize 100, 100 End Sub With the same result. The form is positions 100 pixels in and down from the top of the screen, but at the bottom of the access page (see scollbar in screenshot).
  4. P

    Form moved too far down 'page'

    Thanks Keith, Unfortunately, this only moved the form relative to the bottom of the ridiculously long page! I used the following code: Private Sub Form_Open(Cancel As Integer) Form.Move Left:=100, Top:=100 End Sub I have attached a screenshot. Is my code wrong or do you have any other...
  5. P

    Form moved too far down 'page'

    I have no idea how this happened, but... I have a form that I use as a switchboard for a database. It automatically opens whenever I open the database and contains various buttons that allow me to import new data, run reports etc. It has somehow moved a long, long, long, long (you get the...
  6. P

    Function to concatenate values into a string based upon criteria

    Hi, I have been using Access for a while, but know nothing about VBA. I have a problem that I can't resolve using Access' built in query builder functions and am therefore assuming that I need to use VBA. However, I haven't a clue where to begin :confused: Here's the problem: I have a table...
Back
Top Bottom