Alan Cossey
My feedback
-
10 votes
-
246 votes
An error occurred while saving the comment An error occurred while saving the comment Alan Cossey
commented
How are you getting on 4 months into this, please?
-
81 votes8 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
We are well aware of this issue and are working closely with the Windows team on resolving it. Although we believe we have a solution to the problem, it introduces some new issues that we need to investigate and resolve before we can deploy the fix.
Regards,
Access EngineeringAn error occurred while saving the comment Alan Cossey
commented
How are you getting on working closely with the Windows team on resolving this issue which came up in October 2018, please?
-
13 votesAlan Cossey
supported this idea
·
-
71 votes
A new data connector that allows users to link to and import from Graph API is on our roadmap and will be released to O365 customers in the next few months.
Stay tuned!
An error occurred while saving the comment Alan Cossey
commented
"Link to and import from" would be read-only?
Alan Cossey
shared this idea
·
-
150 votesAlan Cossey
supported this idea
·
-
153 votesAlan Cossey
supported this idea
·
-
183 votes
An error occurred while saving the comment Alan Cossey
commented
Remember you can also have subdatasheets to your datasheets as well. You can't have headers and stuff to the datasheet, but you could put the datasheet on a top-level form so you have the datasheet as your subform and then the subdatasheet runs off that.
-
4 votes2 comments · Access (Desktop Application) » Automating Tasks · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Alan Cossey
commented
And it doesn't always work well. Sometimes something goes wrong and no-one notices until they notice loads of files in the same folder as the original Access database named Database1.accdb, Database2.accdb, Database3.accdb or something similar.
-
4 votes
An error occurred while saving the comment Alan Cossey
commented
I would suggest you don't save the password. It is better to run a connection to the back end when you start up your app, e.g. by using OpenDatabase (with an Access back end) or a SQL pass through query (if an ODBC back end). This creates a cache which is then automatically used by linked tables so they will then connect.
-
364 votes
The Access team is adjusting our status for this request – we are planning to embed the Monaco Editor (support for SQL Editor improvements) into Access, to be released within the next semester (first half of 2021), which will provide capabilities such as syntax highlighting, IntelliSense, SQL comments, and more. We are excited to have this capability released by next year, and we appreciate the energy and enthusiasm on this feature request. We still have a long ways to go to improve our experience with SQL, so please stay tuned as we execute on this objective!
Thanks,
-Access Product TeamAlan Cossey
supported this idea
·
-
23 votes
An error occurred while saving the comment Alan Cossey
commented
Bullzip is good for this for doing it programmatically.
-
3 votes
An error occurred while saving the comment Alan Cossey
commented
Is there a situation where just unhiding existing controls is not as useful?
-
2 votes
An error occurred while saving the comment Alan Cossey
commented
PS Such "roll your own" progress bars are likely to be more flexible and adaptable than anything Microsoft might put into a built-in one.
An error occurred while saving the comment Alan Cossey
commented
There are a number of ways to create a progress bar. Searching on "access progress bar" gives access to some of them.
-
130 votes
An error occurred while saving the comment Alan Cossey
commented
As in over and above the use of the Anchor property?
-
13 votes
An error occurred while saving the comment Alan Cossey
commented
I would vote for this, but have no votes left.
An error occurred while saving the comment Alan Cossey
commented
I agree. Access is different to the other Office programs. When I create a database with no access to the design stuff, e.g. Navigation Pane, design view for forms and reports, etc., I don't want "tell me what you want to do" stuck on my ribbon. It has no relevance to my database. It might as well have an advert for Siberian hamsters there.
Clippy 2 or what?
-
0 votes
An error occurred while saving the comment Alan Cossey
commented
Sorry, there are 6 CommandBars in Access 2016 with no Name other than " ".
Alan Cossey
shared this idea
·
-
31 votesAlan Cossey
supported this idea
·
-
65 votes
An error occurred while saving the comment Alan Cossey
commented
As well as the problem with the borders of windows, Access has other problems with high resolution screens.
When text size is set in Windows (10?) to more than 100%, the following happen:
1) The Navigation Pane updates slowly and jerkily when scrolling down it (even on my super whizzy PC).
2) The horizontal scrollbar at the bottom of a form obliterates the right half of the Search box next to it when the size of the Access window is reduced to a size which causes the horizontal scroll bar to appear.Please note that if you want to check this out by altering your Windows text size, you will need to log off and log in again to see the change.
An error occurred while saving the comment Alan Cossey
commented
I've already used up my votes, so I can't vote for this as well. I have just bought a high resolution screen and the Navigation Pane text is now tiny with large vertical gaps between each line. It's a mess.
-
17 votes
An error occurred while saving the comment Alan Cossey
commented
wilo,
That's all part of vbWatchdog and, no, I have no connection with them apart from using their product(s).Alan Cossey
shared this idea
·
It looks like the development team aren't in much of a hurry with this (or have sorted it and not told us). This has been waiting for a whole year now.