Replies

John,

Sounds like you want to use Julian dates – without the reference to the year.

Check here for Microsoft’s take on converting to a Julian date.

It’s only a start, but should get you on your way.

Tom

The Snapshot Viewer is available from Microsoft here. You’ll need it to view the files in a *.snp format. (You can also make files using the same program with Access.)

As for getting it to work through a browser, perhaps some other loungers can help.

HTH,

Tom

Don,

While you could work up a sophisticated database to pull only the records (from Names) you need for the one-time event, it may not be worth your time and effort.

The simplest thing to do is to create a new database (TheEvent.mdb), and import the appropriate tables, forms reports, etc., from the Names database. Next, add a (Yes/No) field to the table to indicate who will be attending the event.

When you get positive responses for people already in TheEvent.mdb, make them a “yes” in the field.

When you get positive responses from people not in Names, add them to the database, and make them a “yes” in the field.

If you need to keep track of who was in Names, you could add a second (Yes/No) field. People who were in Names would be given a “yes” in this other field.

HTH,

Tom

John,

You might try setting up your rotated text in Excel. Then, you can copy it to the clipboard, edit as needed and pop it into an image control in Access. Or, you could tell your label to look for the image file you just edited.

Of course, this idea won’t be very efficient if you have to do this more than once. Then, as mentioned above, third-party controls are a much better alternative.

HTH,

Tom

Scott,

Attached is an Access 97 db that shows how to use a rolling crosstab report – it seems to do what you want.

This one is designed for twelve months of data, but you can modify it to meet your needs.

HTH,

Tom

Open your query in design view.

Click on the Column Heading (Crosstab Row) and open Properties.

In Column Headings, type in the dates in the order you want, as in “11/01″,”12/01″,”01/02″,”02/02”, etc. Include the quotes (maybe single quotes, to keep things consistent in your query).

HTH,

Tom

Paul’s right about the difficulties in storing the elapsed time in minutes:seconds. Even as text.

You might want to consider storing the elapsed time in total seconds, and let your math calculate the minutes:seconds later.

Tom

It could be a case of a Missing Reference.

To check it, have your former student open the Switchboard form in Design View. Next open the code behind the form. Now display the References (maybe Tools | References – it’s that way for Access 97). Look for the word MISSING along the left side of the window.

If you see any that are missing, click on the reference name (not the check mark) and write down the name of the library and its location. Then, deselect the references and re-select them. (He/she may need to close the dialog box before re-selecting will work).

If it’s not Missing References, please post back.

HTH,

Tom

My guess is that mailto needs to in there. Perhaps Access Help has more under mailto.

When you copy and paste, please do not paste into the autonumber field. Access will assign numbers to it (the autonumber column) as records are added.

Here’s a pasting hint (in Access) – to select many rows of data (like in one column) make the cursor a white plus sign (near the left edge of the cell you want), then click in the cell. It should look black- the reverse of the normal formatting). Release the mouse button. Hold down the Shift key and use the “down arrow” key to select more cells. You can also use Shift + Page Down.

HTH,

Tom

SOS,

With such a small number of records, you might try copy and paste.

If you run into difficulties, please post back.

HTH,

Tom

Wendell,

When I’ve tried to run a similar report (based on a crosstab query, which was based on another query), I had to use the Query . . . Parameters dialog box to get the query to recognize the Text box in the selection form. Used the [Forms]![frmFormName]![txtTextBoxName] name in the Parameter column, and Date/Time in the Data Type column.

I used the Query . . . Parameters box on the first query, not on the crosstab query itself.

HTH,

Tom

Cat,

Here’s how you can do this. Design a new query. Add Table 1 to the QBE grid. Then add Table 2 and Table 3. Join the tables using ID.

Now, doubl;e-click on the join lines. When the dialog box comes up, select either 2 or 3. Which one? The one that makes an arrow going from Table 1 to Table 2 (and to Table 3 for the other).

Bring the ID field from Table 1 to the bottom half of the QBE grid. Do the same for the ID field of Table 2 and Table 3.

Click on the Totals button (Greek Sigma, or funny looking capital E). Under Table 1’s ID field, leave Group By as Group By. Under Table 2’s ID, change Group By to Where. Under Table 3’s ID, change Group By to Where.

In the Condition cell under Table 2’s ID, type in Is Not Null. For Table 3’s ID, go over one and down one and type in Is Not Null. These conditions must be on separate rows to get the correct results.

Run the query. Your results should be contacts – OK, their ID’s – who had transactions in 2000 (Table 2) or 2001 (Table 3) or both years.

HTH,

Tom

Andrew,
You are AWESOME!!! And your code works great, too!

Thank you very, very much for saving me from a lot of manual steps. Yippee!!

Tom

Andrew,

I’ll give it a try. Many thanks!

Tom