the delete is in the "else" and it removes links to non-existant tables.

My suggestion is to add code to a startup form that re-links all the tables with the connetion string of your choice. I run the startup form as a...

You need to find the location of the first space, and truncate the string at that location. To do that, you need to use the instr function.

left([FirstName],len([FirstName]-instr(1,[FirstName]," ")-1)

This will...

You have to work from the center outward.

CVDate([Enter a number for 1st month to compare] & "/1/96")

Means "convert this string to a date using the input value as the month,...

Are you using an MDW?

Have you tried it on the full version of Access with the /runtime switch turned on?

What is your code for DisplayImage?

Wouldn't the fifty-cent solution be to add a zero sale for week 3?

In fact, you could make a table of zero weeks, join on the week number and sum the...