How to get basic system specification info from the PC. Q: Briant Manix writes: “Do you know how to get basic system specification info from the PC? I would imagine that the function would either use a Windows API or e look up in the Registry. I want to get an Access app to use […]
How to sort Reports by date in Access. Access Archon #163 You might need to group records by date using another interval that is not available in the Group On list. If the interval is regular, you can create a query field, such as the Decade field in qryMembers: Decade: Left(Format([BirthDate],”yyyy”),3) & “0” The […]
A reader responds to the AW article on the new “save to PDF” feature in Access 2007. Tom Van Dam writes: just finished reading your latest Access Watch on the new PDF feature in Office 2007. I have often wanted to save files to PDF format for storage and later reading. I came across a […]
Here’s an updated way for you to add backup capability to an Access database. Access Archon #151 Introduction A few years ago, in Access Archon #115, I described a way to create backups of the current database, using several objects that you could import into a database, to make it easy to regularly save […]
How to back up database objects before making changes to them. Q: Jean H. writes: “I am constantly making changes to forms, reports and other database objects, and sometimes I find that a change doesn’t work, and I need to return to an earlier version. I do back up my databases, but it would be […]
