Feedback by UserVoice

Access (Desktop Application)

Welcome to the Access Desktop feedback forum! This is the place for users to send us suggestions and ideas on how to improve.
We have partnered with UserVoice, a third-party service and your use of the portal and your submission is subject to the UserVoice Terms of Service & Privacy Policy, including the license terms. Please do not send any novel or patentable ideas, copyrighted materials, samples or demos for which you do not want to grant a license to Microsoft.

  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback
  1. MS Updates are killing us

    In Dec... Your update wiped out our ability to query. We go through it. Last month SQL Server wouldn't query. We got through it. NOW On particular NEW MS OFFICE Installs my query is returning Gargage. I have the details with pictures. But I am recommending we shut off MS updates to both of my clients. If this "bug" is not fixed and it spreads to the whole company computers, we stop working.

    No place for me to attach the graphic details of the NEW BUG.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  2. add semantics to Hyperlink data type to allow escaped pound sign (#)

    The Hyperlink column data type uses embedded pound signs (#) to separate portions of the definition of a hyperlink. That's just great until the (all too common) moment when some portion of the hyperlink definition includes a pound sign. Access Hyperlink datatype should allow some escape character preceding a # to cause the # to be treated as any other character rather than as separating a part of the hyperlink definition.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Local Data  ·  Flag idea as inappropriate…  ·  Admin →
  3. search box on form properties

    Add a search to the "property sheet" when in design view on a form. This would make it easier to find individual items.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  4. My access Query

    My access Query with a wildcard is not working. Microsoft had me to change SQL and still not working.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  5. Why not define a Ctrl-". This would fill a field with one date higher than the field above it.

    I do a fair amount of data entry that involves date data into a database table. I can use the Ctrl-' function to add to the field the data in the same field directly above it. This is great. But I have to enter a lot of records with dates, and the new record is for a different date, usually the next date on the calendar. So if there was a function Ctrl-", I would be able to directly add the next day to this record when compared to the record above it. For example if Record 12 has a…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
  6. ODBC call failed in version 2007

    Version 2007 popped in this morning, with new issues not seen before. I have been working on the decimal number issue in 2005, hoping for a fix for that, but instead got an ODBC error when opening a recordset. This error is not present if I have an access backend database. I have not yet had time to dig deeper into this yet.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  7. Bug with Office update 2005 build 12827 - Decimal data type enforced in ADO recordset based on passthru query

    In my testing
    ODBC connection to Postgres v11
    Create a passthru query "SELECT COUNT(id)::INTEGER AS counter FROM foo"
    Mark query as returning records
    Open ADO recordset on above query

    Result:
    rs.Fields("counter").type = 20 ' DECIMAL ?!
    rs.Fields("counter").value = ""

    Same error with "SELECT COUNT(id)::BIGINT AS counter FROM foo"

    Current state:
    Have to revert MSO on 20+ backoffice client machines and hope that ADO will be reverted as well.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  8. En vista diseño de tablas poder definir en la tabla el valor de ControlTiptext y que se herede al crear controles

    La idea es que en vista diseño de tablas definir en la tabla el valor de ControlTiptext y que se herede al crear controles.

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  9. Performance Analyzer needs to be resiszable and NOT modal.

    I recently started using the Performance Analyzer tool on the Database Tools Ribbon, to fix other peoples poorly designed but still quite essential work. Two major problems with it, are that the suggestions are almost always wider than the window, which has no scroll bar, and the dialog is also modal, preventing any manual investigation/repair, without closing the tool - Not very useful at all...

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  10. XML Export and Import of Large Number (BigInt)

    I can't complete round trip ExportXML and ImportXML of a table that contains a "Large Number" (BigInt) field. Currently, the BigInt field is stored in the XML output with an attribute:
    <xsd:restriction base="xsd:decimal">
    When the XML that was exported from Access is imported back in to Access the field type is changed to "Number" and then all values that are bigger than Number fail to import.

    When you say that you support BigInt I expect built-in functions to support it. You can test this using the export and import buttons in the GUI.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  External Data Connectivity  ·  Flag idea as inappropriate…  ·  Admin →
  11. Fix bug when copying ImageList ActiveX controls from one form to another

    I've noticed recently that copying ActiveX control of type MSComctlLib.ImageListCtrl.2 (Microsoft ImageList Control, version 6.0) from one form to another is buggy.

    Whenever I've attempted to copy an ImageList from one form to another recently, the object is copied but I see an error message (usually repeated twice) and the control comes in at 8cm x 5cm instead of its usual 1.005cm x 1.005cm. Any attempt to resize it results in the same error message, which usually comes up twice, presumably once for each dimension.

    Actually, even if I try resizing the original object which is the correct size of…

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  12. allow for table and query views to be snap-docked with adjustable borders

    Currently, objects (tables etc) can only be viewed as tabbed or floating windows. It will be handy to allows the windows to be snap-docked so that space can be be optimised and multiple windows can be viewed with minimum time spent adjusting the borders.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  13. add "Find and Replace" functionality in Queries "SQL view".

    It will be really helpful to change/correct table names/references quickly.

    Many times I need to change the base table names to a different one in a complex query with formulas that refer to table names. Currently, I need to copy the SQL to notepad, make the changes and paste it back in the SQL view. However, this resets the column ordering in Datasheet view. I think "Find and Replace" is quite basic function to have while working in "SQL View".

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  14. preciso de um banco e dados de contato para clientes de imoveis

    banco de dados atualizado para clientes. padrao

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  15. listcount

    Small bug in List Boxes - if you show column headings, the list count includes the column heading. For example - if the list box diplays no records the the list count is zero. If there is one record then the list count is 2

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Forms  ·  Flag idea as inappropriate…  ·  Admin →
  16. 1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  17. Add Tables Task Pane scroll wheel should scroll the list

    Update the Add Tables Task Pane so if you've clicked into the list and scroll the mouse wheel it scrolls the list. Even better if the mouse is over the list and you scroll the wheel it should scroll the list.

    Also arrow keys should allow you to move up and down on the list after you've click on an entry in the list.

    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Queries  ·  Flag idea as inappropriate…  ·  Admin →
  18. Decimal data types and Calculated fields in DAO.recordset (build 16.0.12827.20152)

    Anyone having problems with DAO.Recordsets and calculated fields in the latest Insider update (16.0.12827)

    So long I found:


    • When accessing a table field with "Decimal" data type, recordset returns empty string... Changing the data type to double fixes the issue


    • When accessing a query calculated field (sum) the DAO.Recordset returns empty string... Adding the CDbl to the query field fixes the issue.


    3 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Other  ·  Flag idea as inappropriate…  ·  Admin →
  19. Fix all OST corruptions with EdbMails OST to PST tool

    If you have an orphaned or corrupted OST file then EdbMails OST Recovery tool that Convert OST file to PST is exactly what you need. Retrieve all OST contents including attachments, all email properties like cc, bcc, to/from address with just a few click using EdbMails.

    Some of the reasons for OST corruption can be:

    Network issues leading to synchronisation errors
    System failure
    Abrupt termination of Outlook
    Virus or other such malicious infection

    Feature of the OST Recovery tool from EdbMails include:
    Repair corrupted OST file and convert it to PST.
    Maintains the Folder structure intact.
    All the data such…

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Flag idea as inappropriate…  ·  Admin →
  20. GroupWise to Microsoft Outlook Converter tool - Shoviv

    Shoviv Groupwise to Outlook PST converter is an effective and safe solution for all GroupWise users who plan to convert GroupWise mailbox data into Outlook PST format. The tool also allows converting multiple Groupwise mailboxes into Outlook PST format, which saves users valuable time and additional efforts. It supports all Groupwise mail clients as well as the Windows operating system. The following are the well-known features of the tool:


    1. Export GroupWise local/remote/archive data into MS outlook
      The tool also convert Groupwise mail data into various formats such as EML, MSG

    2. Provides various GroupWise connectivity options such as Cache mailbox login,…
    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Product Marketing  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Access (Desktop Application)

Categories

Feedback and Knowledge Base