mrs_doctor_jones

I have two databases in which I have created reports. After creating each report I save it and verify that it is in the list of reports. However, when I close the database and open it again, the reports have vanished. Yet still, if I try to create a new report with the same name, it says I can't because there is a naming conflict.

I do have other databases that do not have this problem.

The common link between the two problem databases is the actually data itself in the tables.

I had earlier posted a problem about an Excel script created in Excel 2000, bombing out in Excel 2003, but failed to write the error message. Here it is:

Runtime Error 1004

Insert method of range class failed

Does anyone know what this means?

When you debug the error, it goes to the spot in the script listed below. In the debugger, the last row of this text is highlighted in yellow.

Dim targetRow As Integer

targetRow = getSubtotalRow()

'Insert a blank row above subtotal.

Sheets("TimeSheet").Range("A" & targetRow).EntireRow.Insert

I've tried using the list feature in 2003, as one person suggested (which works nicely) but I don't know how to edit the script.

I have an electronic timesheet that was created in Excel 2000. There are approximately 26 rows in which people can enter their time for various jobs that they work on. In Excel 2000, once they enter time on the last row, the timesheet automatically adds one more row. In Excel 2003, instead of adding another row, it returns an error. When you debug the error, it goes to the spot in the script listed below. In the debugger, the last row of this text is highlighted in yellow.

I'm not a programmer by nature, but if anyone could tell me if these commands changed any in 2003, I would appreciate it. Thanks.

Public Sub AppendNormalTimesheetRow()

Dim targetRow As Integer

targetRow = getSubtotalRow()

'Insert a blank row above subtotal.

Sheets("TimeSheet").Range("A" & targetRow).EntireRow.Insert

All of the users on our network can access the Access 2000 DB on the server, except for one person who keeps getting the above error, "File could not be locked".

I can also use his ID from a different PC and log in successfully.

The databased is set to "shared", not "exclusive".

He had no problems originally accessing the DB until the day that I had to

repair his Office installation to fix a problem he was having with Outlook.

I've even tried uninstalling and reinstalling office, with no success.

I have a Eureka Maxima bagless vac that I love. The suction on it is great, but lately only half of the dirt (hair, dust, etc.) falls into the cannister. The rest just hangs around the filter. I've tried replacing the filter but that doesn't help.