Menu
Home
Forums
New posts
Search forums
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Log in
Register
What's new
Search
Search
Search titles only
By:
Current visitors
New profile posts
Search profile posts
Menu
Log in
Register
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
DickyP's latest activity
DickyP
replied to the thread
Add a table to a split database
.
Alternatively (assuming you've built the new table in your front end) simply use DoCmd.TransferDatabase with TransferType:=acExport...
Today at 2:26 PM
DickyP
replied to the thread
Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.
.
Agreed to both but MSysObject never updates unbound forms and reports .DateUpdate, whereas CurrentProject .DateModified is good enough...
Yesterday at 10:07 PM
DickyP
replied to the thread
Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.
.
The trouble with using MSysObjects is that DateUpdate field is not as accurate or up to date as the...
Yesterday at 9:29 PM
DickyP
replied to the thread
NumLock
.
See what you mean - of course information about the 32 Bit API isn't easily available anymore, unless. like me, you still have a copy of...
Yesterday at 12:11 PM
DickyP
replied to the thread
NumLock
.
Don't worry about it being 32 bit code: it still works. And given how just how much 32 bit code is still used by the Access 64 bit...
Yesterday at 8:56 AM
DickyP
replied to the thread
Can't change form names or copy and paste forms
.
You can achieve much the same by: In the 'good old days' with Access 2003 an Visual SourceSafe when this happened I just recreated the...
Tuesday at 8:15 PM
DickyP
replied to the thread
How to test program before releasing new version?
.
I've read the thread with great interest and generally all the advice is good. However, I would point out the steps you need, all...
Tuesday at 8:00 PM
DickyP
replied to the thread
Save the names of tables, forms, and reports in a Microsoft Access database to a table named "ObjectNames.
.
Learned something in this thread! I have always use Application.CurrentProject for the All(Object) collections and bodged it with...
Tuesday at 12:35 PM
DickyP
replied to the thread
Another mass shooting
.
A word of warning about gun control. In the UK we have the strictest gun control laws anywhere probably. The normal citizen may not...
Tuesday at 10:38 AM
DickyP
replied to the thread
How to find an Administrator
.
To contact an Administrator go to the main forum page and Right Click on any of the Staff Online and start a conversation. I had the...
Tuesday at 10:17 AM
DickyP
replied to the thread
Solved
Exclude Duplicate Records from a Query
.
If that's what he meant then you are right - however, what he said was duplicate records and that is exactly what DISTINCT ROW does...
Monday at 10:11 PM
DickyP
replied to the thread
Solved
Exclude Duplicate Records from a Query
.
The initial post says duplicate records and this is what DISTINCT ROW does. A record is a row: if they are duplicates only one will be...
Monday at 3:14 PM
DickyP
replied to the thread
Solved
Exclude Duplicate Records from a Query
.
Have I missed something but is there any reason why nobody has suggested using the DISTINCT / DISTINCT ROW predicate? As a aside, which...
Monday at 12:35 PM
DickyP
replied to the thread
Use of Attachments Datatype.
.
You are absolutely correct - my accounts database which has at least one attachment for most transaction has 1181 attached files running...
Saturday at 1:27 PM
DickyP
posted the thread
Use of Attachments Datatype.
in
General
.
Does anyone else find the limitations of the Attachment data type frustrating. I tried it at some length when forced to move from...
Saturday at 11:50 AM
Home
Members
Top
Bottom