Crystal
My feedback
-
24 votesCrystal
supported this idea
·
-
12 votesCrystal
supported this idea
·
-
5 votesCrystal
supported this idea
·
-
1 voteCrystal
shared this idea
·
-
20 votes
-
4 votesCrystal
commented
+1
-
3 votesCrystal
commented
+1 most dialog boxes should be sizeable
-
22 votesCrystal
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 votesCrystal
commented
I have noticed improvements on this -- it is better than it was ;) ~
-
157 votesCrystal
commented
+1
-
3 votesCrystal
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 votesCrystal
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
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.
-
73 votesCrystal
commented
use conditional formatting
-
20 votesCrystal
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.
-
44 votes4 comments · Access (Desktop Application) » External Data Connectivity · Flag idea as inappropriate… · Admin →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 votesCrystal
commented
I get that sometimes -- old computer and graphics card I imagine. To fix, minimize the window and then restore.
-
39 votesCrystal
commented
and why does it matter what the printer is to layout reports? Word, Excel, and PowerPoint don't care ... so why does Access?
-
1 voteCrystal
shared this idea
·
-
0 votesCrystal
commented
It was suggested to have a CurrentRecord ability for conditional formatting. Expanding on this for queries, LastRecord would be nice.
For instance ... Difference: [myField] - LastRecord.[myField]This would depend on the order that records are displayed.
This would also give us the ability to report Running Sums.
For instance... SubTotal: IIF([myGroup]=LastRecord.[myGroup], [myField] + LastRecord.[SubTotal], [myField] )
Crystal
shared this idea
·
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.