Results 1 to 10 of 10
  1. #1
    npsnps is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    2

    Complete Novice

    Hi,



    Very new to access, normally an Excel person, but I think access is the best way forward for what I need.

    I basically need to create a form that multiple users can be in at one time.

    There needs to be a few boxes -

    Name – This needs to be a drop down list, and the list needs to be able to be edited with more people if needed.

    Number – Text box for a number

    Type of request – Drop down list

    Date – A calendar selection or date input

    When they complete the relevant boxes I would like the name, number and type of request to save in a file named with the date they choose and as more people input work on a certain day it slowly fills up with information.

    Is that possible in any way?

    Thank You

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Yes ,this is the basis of access.

    you can use the form wizard to build forms.
    BUT for multi users, you MUST split the db. Tables (backend) on the server for all to access, and the Forms,(front end)
    goes to EACH user.

  3. #3
    npsnps is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Posts
    2
    Ok, I have absolutely no idea how to do this so I might have to give up already.

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    get a book.(or use Google) Its not hard if you see how. They are easy instructions.
    It IS hard, if you know nothing.

  5. #5
    shadowsedge is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    19
    I am a novice to intermediate. I started way back in 2003 and stopped. Now learning to use 2016. I used this website for help.

    http://www.functionx.com/access/

  6. #6
    Join Date
    Jun 2015
    Location
    Wales. Land of the sheep.
    Posts
    1,228
    Code:
    I basically need to create a form that multiple users can be in at one time.
    * split the database to have a backend and then a front end for users.
    Code:
     Name – This needs to be a drop down list, and the list needs to be able to be edited with more people if needed.
    Combo box data would be linked to the table for your "people" whom ever they may be. Then if you want users to have the ability to add people make a buttom somewhere thats a data entry form for this table.
    Code:
    When they complete the relevant boxes I would like the name, number and type of request to save in a file named with the date they choose and as more people input work on a certain day it slowly fills up with information.
    have a table for the appointments/work whatever it is. This would then link to the "people" so... person 1 can be on several jobs.

    To manage this data at a later stage you query it. eg. date = 08/04/2016

    maybe some of my points are a bit vague to you but your question is vague. If you have any specific questions just ask.

  7. #7
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Chrystal has an excellent “basics” tutorial:

    Access Basics

    This is a little more advanced, but still a great starting point, having 37 well written, well defined, clearly named chapters. It also has four or five sample databases which could help.

    Microsoft Access 2010 Desktop Databases

    MVP Allen Browne has an extensive list of tutorials and on-line reference materials:

    Allen Browne's links to other Microsoft Access sites

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  8. #8
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Further to Linq's great list I would recommend
    -the set of 8 free videos by Dr Daniel Soper on Database starting here

    - a full series of Access and programming videos (70+) by Steve Bishop

    -also the tutorials from RogersAccessLibrary re database and table design
    listed under the Examples on this page. These require that you work through the tutorial to experience the process; and what you learn can be used with any database.
    Last edited by orange; 04-10-2016 at 08:25 AM. Reason: spelling/grammar

  9. #9
    laelling is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Apr 2016
    Posts
    4
    I am a novice user and used Lynda.com tutorials - I now feel fairly comfortable with tables, queries, and forms, as well as formatting. It takes patience but you can do it if you want to.

  10. #10
    kagoodwin13 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Feb 2012
    Posts
    181
    One solution that might work for you would be to task an Access developer through a freelancing website. Upwork.com is a popular site where you can post jobs and find Microsoft Access experts. (Shameless plug - I use Upwork for Access development jobs all the time!)

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

Similar Threads

  1. Replies: 21
    Last Post: 04-14-2014, 09:33 AM
  2. Novice in need of direction
    By garamon in forum Access
    Replies: 5
    Last Post: 10-24-2011, 11:24 AM
  3. Novice at best
    By jmorse in forum Reports
    Replies: 8
    Last Post: 04-19-2011, 03:21 PM
  4. Help me i'm a novice!
    By andrew99 in forum Access
    Replies: 2
    Last Post: 12-30-2009, 10:19 AM
  5. Some advise for a complete novice...!
    By 450nick in forum Access
    Replies: 1
    Last Post: 09-11-2009, 02:23 AM

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