Give us feedback – How can we help you work faster and more efficient?

In the VBA IDE References dialog the Available References list box now has a horizontal scroll bar. This is a great improvement. But, the location (full path name) of the actual .dll, .exe, .ocx, etc. is still obscured at the right end for deep paths. It would be nice to always be able to see the full path.

We desperately need support for standard web services (government sphere). SharePoint is not a solution since existing services will never be moved to SharePoint.

I agree - buy Speed Ferret and add it into the package, for that matter, buy the whole of FMS Inc and incorporate all their products. Can we have a small area in the query and table designer to make notes so that someone supporting the code can be advised as to why the query/table was put together in a particular way. Can we have really robust means of locking people out of our code so that the IP is truly safeguarded.

Raymond, If you don't mind me asking... "Can we have really robust means of locking people out of our code so that the IP is truly safeguarded." Exactly where does MDE/ACCDE/ADE falls short here? If you were to ask data, I would agree with the point, but code, AFAICT is actually better protected inside a MDE/ACCDE/ADE than in an EXE, and if you're sufficiently concerned, you can even buy Wayne Phillips' service to strip out the compiler stuff from your MDE/ACCDE/ADE, making the reverse engineering much less likely.

The expression builder should be replaced with something more modern. It hasn't changed since Access 1.00.

Sizing Fieldlists takes longer now

Bug: field won't take value

Bug: query design: double-click Remember Import/Export Directory

Autonumber to Long Integer in Make-Table Queries

~~~ Hi Neha, hope you don't mind, but I have more comments ~~~~~~~~~~~ Sizing Fieldlists takes longer now Sizing fieldlists used to be easier and quicker when the fieldlist would size just one dimension if you dragged a horizontal or vertical edge. Now, unless you position the mouse a distance from the corner, both dimensions resize. This makes it difficult to change only the width since there is just a small part of the bottom border you can drag to size in one direction. It is difficult to resize the height of a short fieldlist for the same reason. [ Feature Request: make sizing fieldlists behave like they did before by requiring one to grab the corner to drag in 2 dimensions ] ~~~~~~~~~~~ Bug: field won't take value I have a field where the value is supposed to be --> "" I cannot enter a quote (or 2 quotes) as a field value using the datasheet view of a table. This update query does not work right either: UPDATE Tablename SET Fielname = """"""

WHERE (ID=10); ~~~~~~~~~~~ Bug: query design: double-click If the properties window is open in the query design, it is difficult to double-click a field in the fieldlist to place it on the grid If the properties window is not open, this works fine ~~~~~~~~~~~ Remember Import/Export Directory When I import data, chances are pretty good that I will get data from the same path I last imported from -- in fact, it is often from the same database. When I export, such as a report in PDF format, chances are I will export to the same path. The directory was remembered in previous versions of Access. [ Feature Request: Please remember the path for importing and exporting, at least for the current session, as it used to be ] ~~~~~~~~~~~ Autonumber to Long Integer in Make-Table Queries It used to be, when we did a make-table query, autonumber fields would become Long Integer, which is usually the desired outcome. When I create a cross-reference table from existing data, there will be more than one autonumber field on the grid. Because Access now wants to keep the definition as autonumber, this is no longer allowed unless one of the autonumbers is wrapped with CLng, which means a different fieldname must be used. Once the table is made, the fieldname(s) must be edited. If CLng was not used, Autonumber must be changed to Long Integer. [ Feature Request: When using Make-Table queries, change Autonumbers to Long Integers as was done in the past. At least change them if there is more than one autonumber on the grid ] While I can understand the rationale for keeping autonumber, since you have to do update queries to create it again if the data is already there, I think copying a table, not using a make-table query, would be more likely if this is the case. thanks Warm Regards,

Crystal * (: have an awesome day :) *

note on "Bug: field won't take value" today, I can enter a quote mark for a field value ... strange -- but not 2 of them (which is what I need). note on "Bug: query design: double-click" Today, I am not having issues double-clicking a field from a fieldlist to place it on the QBE grid. I am also in a different database. note on "Remember Import/Export Directory" My import path (still not export) was also remembered whereas yesterday, it was not. I am still using the beta so these may not be real issues comment on "Autonumber to Long Integer in Make-Table Queries" If the behavior is not changed this back to the way it was, can it be made so just the first autonumber on a grid keeps its autonumber designation in a make-table query? A table cannot have 2 autonumber fields. This new behavior will break some existing applications. For instance, if there are intense calculations, it can speed the process to do make-table queries as opposed to nesting queries to arrive at the final result. These make-table queries may include autonumber values from more than one table. I used make-table queries in one of my apps to cut the time on a calculation process from more than an hour down to 5 minutes. If a user wants to keep autonumber, IMO, it would be better for them to make an empty table and the use an Append query -- as was necessary before. thank you Warm Regards,

Crystal * (: have an awesome day :) *

I would very much appreciate being able to have 2 or more lines of text as the caption in a datasheet. Datasheets are more flexible than continuous forms in many ways (hiding columns, moving columns, subdatasheets and so on), but they are let down by not being able to scrunch up the caption so they only take a limited amount of space horizontally. If you have a long caption, you are basically stuck. In the meantime, does anyone know how to get round this using a Windows API?

Please give us the ability to do "Select Distinct", "Select Distinctrow", union queries, cartesian joins and aggregates in web queries. Web databases are brilliant, yet are lacking these fundamentals in web queries in Access 2010. Go on, you know you would really love to squeeze them into Access 2010 RTM....

Oh and being able to use action queries in web databases would be brilliant. Not having these is a pain.

Yes please make available all sort of queries in web databases in Access 2010 RTM

I use MS Access 2003. I really need in next Access: 1. Pop-up Window (Shift+F2) can remember font and size of font in MDE file. Now font is very small. 2. Increase number of indexes in table. Now there are 32 indexes in table. It is not enough. I have to make not all links between tables. On increasing number of links between tables Access informs that too many indexes in table. It is not good for complex project. Sometimes there are a few data in tables. But business logic is very complex and needs many links between tables. Every link is an index and finally Access can not make links. Finally I have database without links. It is not good. 3. More powerful form editor. Exact control position. And other great features. Like in NetBeans or similar IDE. 4. Returning of ID of last inserted record in multi user environment while different users use simultaneously ADO and DAO, also use AddNew and also use direct input into table. In other words when users use different methods for adding new records. So that I want to receive correct last ID of inserted record in situation when different methods have been used parallel. Now I have situation when I add new record in multi user work – finally I can receive incorrect ID. Because of ADO and DAO do not see each other. And so there is only one method to return last correct ID, using AddNew. Sometimes it is not good. I think there is need to add SQL command for returning in variable ID of last inserted record like this: INSERT INTO t1 (...) values (...) returning lastID 5. Export table subform into Excel without any code and with full style of subform (color of columns, width, font end etc. First row of Excel table can have Me.Caption as header. 6. Export report into Excel without any code with full style of report (color of columns, width, font end etc. 7. Position of form controls on layers. Navigation (switching) between layers manually or using code. 8. Auto form resizing for any screen resolution. 9. DataGrid control. With groups, totals, filters, double click details, color cells, trees in cells, comboxes in cells an so on. 10. Database window is in like MS Access 2003. 11. Increase number of simultaneously open tables. Very great need. When Access can not show many tables, data on screen and Access starts to remind and gives up to show data on the screen. It seems there is number 2048 open table (error message 3048 Can't open any more databases). I have to limit interface of program. But work situation needs a lot of tables on the screen. 2048 limits my work. 12. Month control like Lebans. www.lebans.com It is the best month calendar I ever saw. 13. Font autosizing (increase and decrease) in text field. So that in case of constant height of control I need size of font in text control can be changed automatically and placed into control entirely. Like at Lebans. There is a project at Lebans. 14. Editable reports or reports with response. When I click on cell of report for example another report or form can pop-up with detailed data. 15. Export report into Word without any code with full style of report. 16. Table subform in ribbon form.

1. Opening such table in ribbon form with click on plus on the left.

2. Also a table control in ribbon form. Like in reports when row contains subreport 17. More the one Me.OpenArgs. For example Me.OpenArg1, Me.OpenArg2, Me.OpenArg3 and so on up to 10. 18. Hierarchical data grid control like Microsoft MSHFlexGrid Control from Visual Basic 6.0. Very great control with ADO Shape (MSDataShape). Export such control into Excel. Even I do not understand why such good control is absent in Access 19. Remembering subform column width, position, column queue (order) for MDE file. 20. Tree View control. Exporting its contents into Excel. 21. Open File Dialog control. 22. Editable linked Excel tables. 23. Opportunity when I work in Russian Access I can switch interface into English. Russian Access now creates names of controls in Russian. I want Access can switch between languages. 24. SnapShort viewer. 25. Time control. With vertical or horizontal line of hours in a day. 26. Correct form behavior in different screen resolution. 27. Protocol of all changes of database objects (who, when, where, what). 28. Conditional formatting more the 3 condition. 29.Good sql-editor!!! Like MS SQLQuery Analyzer. 30. Combined Date and Time control. Date and time after date. 41. List of users who works with linked tables in multi user work.

Hi Neha, I'm often creating form based applications with Access 2003. In Access 2010, it would be very helpful to zoom in/out while working in the form design view. When creating reports, it would be very nice using reporting features and controls like the SQL Server Reporting Services. Kind regards,

Daniel Schunk

Desperately need support for CHM help files, see support.microsoft.com/.../275117. Can't make it work in A2007 under Windows 7 64bit (Czech). P.S. A2007 has BIG problems with - it crashes after a few attempts to call CHM help via hhctrl.ocx (HtmlHelp function, KB275117). And HLP files are not directly supported by Windows 7. :-(

In Access 2007, collect data through e-mail messages, is there a way to update data rather than adding data using HTML? I have run through the wizard several times based on the demo in the help menu and the dialog box that is shown does not come up for me. When reading the how-to here, it looks like the update ability is limited to InfoPath. Please advise. Thanks! Kathleen