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.

Excel users expect to highlight a block of cells, press the [Del] key and have those cells cleared. That's not supported in Access. It'd be nice to highlight a set of fields across multiple records, press [Del] and have them cleared if they don't violate any constraints. If a constraint is encountered, the delete process should stop just like it would if a user manually selected each field and pressed Del. This would make Access more intuitive and similar to how Del works in Excel and Word tables, and save hundreds of keystrokes for clearing a simple block of fields.

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