I have noticed this issue whereby you move columns and when the user exits the form, the datasheet columns revert back to the original (pre-saved) order. The work around I found was to hide/show columns, toggle one field on then off, close dialogue and then it will save. Not very intuitive.

Thanks for fixing.

If you select part of a column in Excel, it will provide a total as well as the number of rows selected.

It would be great to have this feature in Access.

For example, I use access as a work tool. It would be great if I were able to put the contact of a Research PI as one person and then put the whoever else working in the lab as a separate contact but be able to electronically link the names to the Research PI so that when I pull the PI's name up I can see who else is working in the lab.

If a user has selected the rows that they are interested in by means of the filters on the datasheet they will expect that the download will deliver a spreadsheet with those rows. Instead they are getting the full list of records and must repeat the filter in excel.

Should include fertilizer and pesticide application rates, dates, times, lot numbers. Planting, harvest, temp tracking. Cultural managements such as pruning and mowing.

Please allow to customize the color and font for the selected row.

I can't right on here even the other Microsoft apps.

I want first name, last name, address, city, state, zip , sent, received, email.

It needs to be more difficult to accidentally delete data in the database. I don't know how you do this, but all I know is Access automatically saves changes even when I don't want it to. If I accidentally delete something, it's gone forever.

Instead of manual ctl-A, Ctl-c, open excel, new worksheet, ctl-v.

For medium/lower bandwidth connections to SQL Server attached tables, Access datasheet performance (scrolling, window refreshes) slows down when "allow additions" is set to false and "allow edits" is true. If set to true but set to false on form open, the performance is good.

I am trying to arrange datasheet columns for users, when a form loads. I have code (in a module) that sets the "ColumnOrder" property, using the OnLoad trigger for the form.

I receive the runtime error '7771':
"You can't set the ColumnOrder property when you are in Form view or PrintPreview."

I'm also updating ColumnHidden, and ColumnWidth, using data saved in a table, so that users can save their datasheet view settings and have them regardless of which desktop they're working on. This is an access front end, linked to a SQL server storage.

their should be more improvement on the app

Sometimes when I do a CTRL+F search on a column in datasheet mode, it takes much longer to complete than if I apply a column filter that does more or less the same thing. I suggest that you re-program your CTRL+F search function so that it makes use of query filters, to make it work faster.

Should be in 14pt and vertical lines between items. spacing of horizontal lines should be 1/4 inch wide.
Primary use would be for 2nd hand store, or pawn shop.

Unlike Excel/Visual Studio Code/Chrome. Currently, Access Desktop has no split screen/windows feather. It is hard to compare the data and check data structure to write query.
It would be better to have a split screen feature.

I need to input both business and personal email addresses when I receive them. So having an Email 1 and Email 2 line would be fantastic even if the Email 2 line is optional.