+ Reply to Thread
Results 1 to 2 of 2

Default % value, Autonumber and text field connected to a table

  1. #1
    Forum Contributor
    Join Date
    01-18-2017
    Location
    Poznań, Poland
    MS-Off Ver
    2016
    Posts
    139

    Default % value, Autonumber and text field connected to a table

    Hi everyone,

    I am not experienced with Access and I would like to ask you a few questions how to work with it.

    1. I have created a table and then a form based on this table. In one column I want to have a percentage value. I would like to have a default value = 23% so I chose a percentage format type and put 23% in property sheet. Unfourtunately it actually shows me 2300%. When I want to correct the value manually for 23% after clicking Enter is returns me 0%, and when I put manually 51% it shows me 100%. What property should I change in order to make it by default equal to 23%?

    2. I have also created one text field with the name of the supplier. Is there a way that I make it the way that: When I start typing it shows me a tip with the supplier name that matches to what I have typed in a list that I could choose from but when no results have been found then it automatically creates a new record in a table with the suppliers?

    3. The last problem I have is with Autonumber. I have created an Autonumber field as a primary key. Howerver when I delete a record manually, Autonumber ignores it and goes on counting like the deleted records existed. For example when I have Autonumbers from 1 to 10 and delete 10th record and add a new one record then it does have 11th number instead of 10th. How could I possible make it different?

    Thank you very much in advance for any tips.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Default % value, Autonumber and text field connected to a table

    1. In your table, set the field to number-->Double. Format as percent. Set the default value to 0.23
    2. For this item, look at this link at Allen Browne's site--> http://allenbrowne.com/ser-27-01.html
    3. Your primary key is only used as a key unique value. The deleted number will never return. It really makes no difference. It is only a unique identifier. If you need to have a value that is not unique or the primary key, then create it using a one up formula/VBA in your form.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Parse Delimited Text Field Connected to ODBC Database
    By jennarenae in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-03-2014, 06:17 PM
  2. Pivot Table Value Field Settings Default Options
    By Bill fitz in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-07-2013, 09:23 AM
  3. collapse pivot table field list by default
    By tlafferty in forum Excel General
    Replies: 3
    Last Post: 12-02-2011, 06:39 PM
  4. [SOLVED] pivot table field summarize default
    By Pam Deshazier, SRHS in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-22-2006, 08:25 PM
  5. Issue w/ AutoNumber Field during DAO Record Insert
    By MSweetG222 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-25-2006, 03:15 PM
  6. Pivot Table Field Settings Default value
    By Debra Dalgleish in forum Excel General
    Replies: 3
    Last Post: 11-02-2005, 06:20 PM
  7. [SOLVED] Pivot Table Field Settings Default value
    By MMesarch in forum Excel General
    Replies: 1
    Last Post: 11-02-2005, 06:17 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1