don94403

Here's a small .mdb that is handy for someone to use to track hours spent on one or several projects. By creating a desktop shortcut to the .mdb, it is very fast to click to start or stop accumulating minutes on a work project, then close the .mdb again. Also reports total accumulated hours per project. I didn't provide a Form to add or edit projects, you can just open the tblProjects table to do that. I also didn't provide other reports, since everyone probably has their own reporting requirements. ...

Attached Files

• ProTrak.zip (28.8 KB, 32 views)

I needed a quick way to award a door prize for our monthly Access User Group meeting, so I wrote a small Access database and in the process I learned (or recalled what I had forgotten) several small things that might be of interest to others, so I'll post the .mdb here.

Things I learned or re-learned:

• When you use the Rnd function and you want it to start with a new seed each time you open the application, use the command Randomize.
• When you're in a loop and need to update controls

...

Attached Files

• doorprize.zip (17.7 KB, 5 views)

I have another web site that can access a database that contains 2,100 records of past crew members of my old Navy ship. I wanted to make it convenient to search for personnel who were aboard the ship during any particular year, and I also wanted to be able to search in alphabetic groups. This isn’t the same kind of pagination we’ve been discussing, but it’s another way to display data conveniently for the viewer. Visit usselectra.org and click on the Database button on the left, then select ...

More complicated pagination:
That’s pretty much it, for simple pagination. Sometimes you may want added features, such as allowing the viewer to sort the results they see. I have a poetry web site that illustrates such a feature. Take a look at The Poa Tree - Home and click on the Go To The Poems button in the upper right. The script for that page follows:

PHP Code:

<?php
session_start();

if (isset($_SESSION['login'])) $login = $_SESSION['login'];
if (isset($_GET['sort']))

...

Simple Example:
This is pretty much the simplest example of a pagination script:

PHP Code:

<?php
// set the page number – if it is not passed in the URL, set it to page 1
if(isset($_GET['pg'])) {
    $pg=mysql_real_escape_string($_GET['pg']);
} else {
    $pg=1;
}
if($pg < 1) $pg=1;

$perpage=10;  // <-- set to how many items you want on a page
$startrec=($pg - 1) * $perpage;  // <-- starting record for

...