Pat Hartman
My feedback
-
3 votes
-
4 votesPat Hartman
supported this idea
·
-
6 votesPat Hartman
supported this idea
·
-
8 votes0 comments · Access (Desktop Application) » Automating Tasks · Flag idea as inappropriate… · Admin →Pat Hartman
shared this idea
·
-
4 votesPat Hartman
shared this idea
·
-
17 votesPat Hartman
shared this idea
·
-
51 votesPat Hartman
shared this idea
·
-
8 votesPat Hartman
commented
Is your Autonumber marked as the primary key? If it is not, that may be what is causing the problem.
-
2 votesPat Hartman
commented
This is one of those stupid changes that frankly drives me nuts. I realize it is just a short putt but change for the sake of change is POOR! Why would Access elect to work differently from Windows itself when prior versions worked the same way Windows did. There are numerous other "little" dumb things like that that were broken with A2007 (including the switch from the database window to the inferior nav "pain") and I've almost given up hope of them ever being restored.
Pat Hartman
supported this idea
·
-
181 votesPat Hartman
commented
MS missed the boat when it attempted to respond to requests to make Access web enabled. No one actually wanted MS to develop a whole new (and inferior) FE model. We wanted Access to be a better ODBC client so we could have response times similar to that of web pages. Although Access works well enough using ODBC on a LAN (as long as you use a little common sense), it sucks when the database is somewhere in the cloud. THAT is the problem we need MS to fix. The "Access Way" is bound forms/reports. We need ODBC solutions that integrate with bound objects.
-
95 votesPat Hartman
supported this idea
·
Pat Hartman
commented
Anchor does not solve this problem. There are two issues to address.
1. Resizing when the user changes the size of a form or window. If he resizes the form, the objects should all resize. However, resizing the window shouldn't change anything. When I use Access in less than full screen, it is generally because I want to see parts of two applications and automatically resizing the Access window to be "full" but smaller would defeat this.
2. Different resolutions. This could be accommodated by storing the resolution of the screen on the PC where the app was created. Then when the app is opened on a different system or different monitor on the same system, the forms could adjust. But, to give us some flexibility, I would make this an updateable property in case we change development platforms. -
30 votesPat Hartman
supported this idea
·
-
4 votes
We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.
Stay tuned.Pat Hartman
commented
This was such a pain for me that I built my own. If you belong to experts exchange, send me a PM or post a request for it and I'll find you.
-
11 votes4 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →Pat Hartman
supported this idea
·
-
69 votes6 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
We are designing on a new Linked Table Manager dialog, incorporating suggestions and requests made in UserVoice and other forums.
Stay tuned.
Pat Hartman
commented
I wonder if anyone is actually thinking about this. It has been more than six months!!!! All I know is that if a client asks me to change the way a form is sorted, I can get it done in under 5 minutes. Somethings are simply no-brainers.
Pat Hartman
commented
Making it sizable is only part way there. The real benefit would be to enable sorting on the linked BE. As all of us know (perhaps MS does not know), it is extremely difficult to relink when there are multiple BE's involved since you can't get them all together. I don't know about you, but when I have to select 20 tables from one BE and 3 from another and 5 from yet another, I invariably miss one and then the dialog prompts me to locate the BE for each and every table I selected. Give us a break and allow us to sort the list to give us a fighting shot and selecting all the tables we need at one time. I wouldn't even ask that you make the dialog intelligent enough to relink multiple BE's.
-
31 votesPat Hartman
shared this idea
·
-
9 votesPat Hartman
supported this idea
·
-
15 votesPat Hartman
supported this idea
·
Your database is probably corrupted. Start with compact & repair. If that doesn't work, try rebuilding by starting a new, empty database and importing all objects. Don't forget to reset the back page settings if needed.