Results 1 to 7 of 7
  1. #1
    _Chris_ is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    24

    Question Table style ?

    In Access 2013, I will be trying to create a table, that has the headers vertically down the left side, as opposed to horizontally along the top, plus, some parts must only be editable by me and not some of the users that will be using the table - are these 2 bits possible please?

  2. #2
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    as far as I know you cannot in the table itself. you could make a form to go with the table that would have everything vertical and parts only editable by you.

  3. #3
    _Chris_ is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    24
    Thank you for that. Would a form be the only way please?

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    a form is the only way. Use the form wizard and choose the columnar layout.

    With regards the editable bit, that can also be done. To make certain controls uneditable set the control enabled property to no. To make them editable for you, the form needs to 'know' it is you. this can be done very easily using a tiny bit of vba (and probably a macro, but I don't use them so can't advise) combined with conditional formatting.

  5. #5
    NightWalker's Avatar
    NightWalker is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Apr 2016
    Location
    Midwest USA
    Posts
    253
    I agree completely with Ajax.

  6. #6
    _Chris_ is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Posts
    24
    Thanks, looks like I am in the right place. ;-) Am also trying do some sort of stock check with it as well, so that when a certain item falls below a certain amount, we get an alert. How would we set that up please?

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    when the user enters a stock issue which takes the stock level below the minimum stock level you would have some code to trigger the alert. Depends how sophisticated you want to be but there are lots of ways this can be handled - e.g. issue a 'warning' when stock level is within say 10% of minimum level, or some sort of calculation based on when new stock is coming in and current rate of issue.

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

Similar Threads

  1. Add To Cart Style Table
    By Lewis825 in forum Access
    Replies: 12
    Last Post: 10-30-2015, 09:49 AM
  2. QC form in Pivot Style
    By drunkenneo in forum Forms
    Replies: 1
    Last Post: 05-06-2014, 08:59 AM
  3. Bord style
    By sergran in forum Programming
    Replies: 2
    Last Post: 09-12-2013, 12:04 PM
  4. Spreadsheet style
    By NISMOJim in forum Reports
    Replies: 8
    Last Post: 05-22-2011, 12:24 AM
  5. Extracting data from a disastrous excel-style Table
    By milehighfreak in forum Import/Export Data
    Replies: 2
    Last Post: 12-16-2009, 07:13 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