Crystal
My feedback
-
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.
-
72 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.
-
41 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
·
-
9 votesCrystal
commented
I imagine Mark's intention is to make reporting from multi-value fields better as currently, we have no way to copy the comma delimited list of values in code when it is clearly already being done.
Additionally, it would be nice to have this for related tables as well so we don't have to write our own loop and combine procedures.
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.