Currently, the developer needs to go through the process of importing a file into a database in order to create or edit an import/export spec in the MSysIMEXSpecs table. True, the MSysIMEXColumns can be edited directly in the table, but overall, the process is not very user friendly. There needs to be functionality to create/edit import/export specs without have to pretend that one is importing an external file.

The only way to make a tabbed form have a colour is to resort to some trick like using a coloured background behind a transparent tab or pasting an image onto it. These cause problems when moving controls around.

It would be nice for the tab control to have the same functionality as a form where one can set the background colour.

Replace VBA with VBA.net. You exist because of your customer. Develop solutions to your customers' needs, not your agenda. CUSTOMERS' NEEDS = VBA.NET! I don't understand why your company does not grasp this necessity. Good grief!!

I want to drag multiple files from explorer window onto the listbox to add the filenames to the rowsource (tried mscomctl.ocx: huge problem with other programms that register other versions of the ocx-file)

When using the vbYesNo message box you can only have 'Yes' or 'No' options. I would like to be able to rename these options. Currently the only way round it is to create a form to look like a message box.

Currently (Access/Office 1706), the only formatting capability for column headers in datasheet view is with the DatasheetColumnHeaderUnderlineStyle property, and this only seems to work for value 8 (Double Solid). It would be great if some extra capabilities could be added:
1. Set HeaderHeight (absolute or relative to normal row height, f.i. twice normal).
2. Options to wrap & align text within Header.
3. Set Background color / Font bold & color.

Of course more comprehensive header formatting is imaginable, but these basics would already be a great improvement.

Thanks, Hans (Netherlands)

Especially important if user has runtime Access and/or maybe using an accde file.

Access 2007 added the Rich Text control so we can store rich formatted text in Access. What it forgot to add was an easy way to share that formatted text in Excel or Word. Please add a means to share the rich text data in at least other Office apps and a easy way to strip the formmatting when exporting to formats like .csv.

We should be able to generate reports as PDFs with a password. MS Word has an encryption option when saving a Word Doc to PDF.

For security reasons, more and more organizations want to have encrypted data at rest and in emails. ACCDBs support encryption, so it'd be helpful if it's PDF outputs could too.

It should be available from the user interface and as an option programmatically (DoCmd.OutputTo acFormatPDF).

When one creates an accde database, Ms access 2007 SP3 up to 2016 should also remove the ability to modify tables and queries.

When building a system that shares its data with other systems - I've built an ERP system with Access - you often want to share certain Master data (from the HR system for example), but want to keep it that only HR can modify the data.
If we could set linked tables to be read only, that would remove the need for a lot of 'protectionist' coding.

With comprehensive applications, it isn't hard to get the dreaded "Can't open any more databases" error message.

When this message is encountered, bad things happen internally and the database should be restarted.

If this isn't possible, at least give us a handle so we can determine the number the system currently thinks exist.

Whenever I modify a table or a view in SQL server I need to go refresh the table link. Currently that means
* right click a table
* Select Linked table manager
* Find the table I want to refresh
* select it
* click refresh table links

I would really like it, if we could simple right click a linked table, and just select refresh to have that single table refreshed.

When connecting to a commercial database such as Oracle, it may be trouble if all the columns of the table are not displayed.

Whenever an ITEM such as a heading progress bar is in the Detail section, so if you display the form as Continuous Forms, you will see a progress bar in each displayed record. It will happen whenever a Continuous Form displays more than one record.

The only way to avoid this is to move the progress bar to the form header (or footer) section.

Please refer to the attached design, on the very last page described in microsoft forums.

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_access-mso_windows8-mso_2010/crosstab-query-to-display-all-records-according-to/b98b9372-1a83-402d-b54d-87ca5b7a7407?messageId=c8966d76-2bcd-4a49-a1cc-83cdcf71a483

Either an access development enhancement to enable this would provide more flexibility to create complicated reports.

Thank you kindly.

Often the Datasheet heading is much longer than the values in the column under the heading. Making the column narrower (to see more columns) means I can no longer read the heading.