Crystal
My feedback
-
50 votesCrystal
supported this idea
·
-
21 votesCrystal
supported this idea
·
-
11 votesCrystal
supported this idea
·
-
8 votesCrystal
supported this idea
·
-
1 voteCrystal
shared this idea
·
-
20 votes
An error occurred while saving the comment -
4 votes
An error occurred while saving the comment Crystal
commented
+1
-
3 votes
An error occurred while saving the comment Crystal
commented
+1 most dialog boxes should be sizeable
-
226 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,
Ebo [MSFT[An error occurred while saving the comment Crystal
commented
most important to me is ZOOM ... my eyes cannot read as well as they used to. I often have to copy SQL to Word just to read it because it is too small for me. I put a lot of SQL into Word anyway as I wrote a function to format it and there I can also search/replace -- would be nice if the SQL statement would be saved as formatted.
Rather than revamping Access to be a word processor, how about if Word could be used as the editor?
-
22 votes
An error occurred while saving the comment Crystal
commented
you can manipulate and move in the OPEN event for forms (not sure about reports) in an ACCDE or MDE ... not saved so not too efficient though
-
7 votes
An error occurred while saving the comment Crystal
commented
I have noticed improvements on this -- it is better than it was ;) ~
-
170 votes
An error occurred while saving the comment Crystal
commented
+1
-
3 votes
An error occurred while saving the comment Crystal
commented
you can use Validation Rule and Validation Text. For email (from Jeff Conrad), this would be something like: Is Null Or ((Like "*?@?*.?*") And (Not Like "*[ ,;]*"))
-
7 votes
An error occurred while saving the comment Crystal
commented
rearranging the tabs by dragging would be nice when I use tabbed view (which most of the time I do not)
-
4 votes
Thanks Bruno for posting.
I’m unclear of the issue you are describing. Could you please elaborate?Thanks
An error occurred while saving the comment Crystal
commented
sometimes MsgBox (displayed using VBA) does not have a border -- this makes it very hard to see! This does not always happen, just sometimes since Fall 2015.
-
76 votes
An error occurred while saving the comment Crystal
commented
use conditional formatting
-
20 votes
An error occurred while saving the comment Crystal
commented
Report View is interactive. My preference is Print Preview because it is faster, especially for lots of data, but not interactive. In those cases, I offer the user a choice of view so if they want interactivity, they can have it. If they just want to see the data quickly, they can choose Print Preview.
-
47 votes4 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Crystal
commented
The tables that store import/export specs are:
MsysIMEXspecs
MsysIMEXcolumnsWhile you cannot modify the tables directly, you can use APPEND queries to add records to those tables -- and you can delete records from them directly. You can probably use UPDATE queries on them too, but what I usually do is
1. make-table from the columns of a spec using MsysIMEXcolumns
2. delete rows from MsysIMEXcolumns for a particular spec
3. modify specs
4. use APPEND query to write records back to MsysIMEXcolumns for a particular spec -
7 votes
An error occurred while saving the comment Crystal
commented
I get that sometimes -- old computer and graphics card I imagine. To fix, minimize the window and then restore.
-
39 votes
An error occurred while saving the comment Crystal
commented
and why does it matter what the printer is to layout reports? Word, Excel, and PowerPoint don't care ... so why does Access?
I add SaveAs to the QAT ... do not like how SaveAs is currently implemented as a backstage command since once we click it, we can no longer see what we are working on which makes coming up with a good name harder.