Category Archives: Software Development
Removing Security From An Access Application
I have been working with an old Access 2000 application and decided, due to the change in use to a Kiosk type application, where multiple people use the same application without shutting down, that the security mechanism based on Workgroup security will have to go. This application had previously been secured by using a bespoke [...]
How to have a SQL Server stored procedure be the source for an Access report
In converting my Access back end database I came across a little gotcha that took a while to solve. I was trying to dynamically have a stored procedure on the server act as the record source for a Report. But what ever I tried, I kept getting an Error Message “Run-time error ’32585′ This feature [...]
An automated backup regime for a small SQL Server database
I am making this post to show how to make a simple automated backup regime for a relatively small SQL Server (I am using SQL Server 2008 R2 Express Edition) database. I am doing so, because when I was looking for some inspiration for doing this myself I found it quite hard to get all [...]
How to create an Access SubReport which uses as SQL Server Stored Procedure as its data
I am porting an Access Front End/Access Back End application into an Access Front End/SQL Server Back End application. One thing that got me stumped for a while was a report which had an embedded query as a subreport. This query was complicated in that it had many joins, group by clauses on inner selects [...]
Importing Access Database into SQLServer when the former is protected with a workgroup file
I have been trying to explore different ways of populating a SQLServer database with data from a fairly complex multiuser Microsoft Access application, with a view to migrating the application to using SQLServer for its primary data server. The application is split into front end accessing a main backend database (and a couple of other [...]
Calling a Form with Return Values.
I recently learnt a neat trick for calling a form in Microsoft Access and retrieving values from it. It is really nice to encase the whole thing in a function which retrieves a return value. Let me show you with a simple example – I want to return an address based on a post code [...]
A Video about my Air Hockey software
I have made a video about my Air Hockey game, a web based simulation of an Air Hockey table. I repeat it here, although it is also available on my software applications page Making a video that works with Flowplayer seemed to be quite a difficult job. In producing the video using linux I tried [...]
Jumping to a particular record in MS Access
I have been working with Microsoft Access for a while but I had run up against a problem that took me a while to solve. I have a form, with two sub-forms side by side, both of which contain similar subforms displayed in continuous form mode. Each subform is a query based around activities on [...]
Managing SMF software in GIT
Yesterday, I upgraded three sites running SMF (Simple Machines Forum) software to v2.0RC5, upgrading them from v2.0RC4. Some of these sites are more than just a simple implementation of the base software. All of them have some modifications added, one (Melinda’s Backups forum) has a considerable degree of modification, and unlike WordPress, where plugins are [...]
Displaying my RSS feed on Hartley Consultants’ front page
I had always planned to replace the feed on the front page of Hartley Consultants web site with a summary of recent posts from this blog. I had previously sucked in news articles from the local SMF Forum that is on site, but I intend to remove the forum shortly because I am setting up [...]
Hartley Consultants Limited
- Web Sites,
- Community Forums,
- Application Maintenance,
- Software Development.
Contact Us to discuss your requirements
Melinda’s Backups
Alan is the IT director of Melinda’s Backups., the official “Support Association” for Melinda Doolittle
Please visit http://www.melindasbackups.com to learn about our activities
Powered By Wordpress
