Results 1 to 14 of 14
  1. #1
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9

    Angry Forms


    Hi all,
    Newbe please will someone tell me how to open a form at the last record and also how to add a button on a form for new record?

  2. #2
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    DoCmd.OpenForm "My-Form-Name", acNormal
    docmd.gotorecord acDataForm, "My forname", acLast
    >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
    This is a subject to Mr.(missinglinq)
    http://bytes.com/topic/access/answer...w-blank-record

  3. #3
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    Thanks so much I'll try this as soon as I have had my early mornig tea.

  4. #4
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    Please could someone tell me where I can download the deign schemes add-in?

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Should appear first version of Access?
    What is the tool that you want?
    This is the place to download several tools (additional)
    http://access-2007-add-ins.winsite.com/

  6. #6
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    When I first got Helen Feddema book (long time ago) I got Design Schemes.mda for a whole lot of cool form designs and am wondering where I got it from.
    The web site you sent me to will be jolly useful thanks.

  7. #7
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    Hi my friends please tell me, does this mean the form in which the data is entered ie the sub form or the main form? acDataForm

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Replace My-Form-Name with your main form name.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9

    forms

    Hi all, Please could someone make the form open at last entry focus on date and subform when getting focus start at time. I would like to just enter from date to sub form enter to reading enter to comment enter new record Then tell me how? I'm sorry to be a pest and would appreciate if you could tell me the How. Thanks a lot!
    Attached Files Attached Files
    Last edited by Gainzim; 07-26-2014 at 06:59 AM. Reason: add attachment

  10. #10
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Helen Feddema's site

    Also, there are several good youtube videos on a variety of Access (and other topics).
    Good luck with your project.
    Good list to start

  11. #11
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Review https://www.accessforums.net/access/...red-40057.html

    But why bother? User can just easily click onto the new record row of subform.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  12. #12
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    Thanks very much, just that with poor eyesight the navigation button is rather small. Is there a way of enlarging the navigation bar?
    Thank you all for the help.

  13. #13
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Not without changing screen resolution and making everything appear bigger.

    Was the referenced link helpful?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  14. #14
    Gainzim is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2014
    Posts
    9
    Thank you again for your help the reference link will be a great help. Keep well!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 10-23-2013, 08:11 AM
  2. Replies: 5
    Last Post: 01-16-2013, 03:48 PM
  3. Multiple forms or embedded sub-forms
    By Juicejam in forum Forms
    Replies: 2
    Last Post: 08-23-2011, 07:31 AM
  4. Replies: 1
    Last Post: 01-04-2011, 05:04 AM
  5. Replies: 4
    Last Post: 04-01-2009, 08:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums