Replies

Keith,

Getting back to the original issue…. I would take a serious look at printer drivers, at least to eliminate that as a possible cause. (No, really. It sounded to me at the time, at best, “unlikely.” But… )

We traced very similar symptoms back to printer drivers which were not working well with Vista. Sometimes a reboot would “fix” the issue, other times it would take several/many reboots before the machine would begin to operate normally. Nothing in Task Manager suggested anything in particular was grabbing the processor, but the machines would just crawl along. Finally one day (since my machine was one of the ones affected), I just started killing processes. When I got down to spooler.exe (the Print Spooler process), and killed it, my machine came back to life immediately.

In the end, finding updated printer drivers helped us immensely.

I would look at what printers are installed, removing any printers and driver files not absolutely needed. Then I would look for updated drivers for printers that need to remain. Might be worth a shot.

Jim

P.S. Apologies if this posts twice, I didn’t get any kind of confirmation when I posted the first time, and couldn’t find my reply. So, trying again.

So upgrade it to SP1 and let’s see if it breaks the drawing borders function!

Mine shows: “Microsoft Office Excel 2003 (11.6355.6408) SP1”

Thanks for trying!

>Ive managed to get to a 2003 PC.
>My pencil stays on when I draw borders.

Is your 2003 installation SP1? Maybe that’s a difference….

>Are you using the Borders toolbar where you have
>the option of Draw Border and Draw Border Grid??

Yes, exactly.

Double-clicking doesn’t seem to work. I see what you mean about double-clicking the Format Painter icon…that does work. But I tried double-clicking everything I could in the borders toolbar, and everything responds to a single-click, and none of it leaves the pencil cursor active after drawing one border.

Just a note to say that it takes effect immediately. No reboot required.

Just a note to say that it takes effect immediately. No reboot required.

Outstanding, Hans! Way to go!

Thank you for taking the time to follow-up in this thread, many months later!

And our estimators thank you too! Their file names are like this: 0302038.Est. And the only way they could see the estimate title without opening the estimate was to hover over it. They can now do that again. Yippee!

Outstanding, Hans! Way to go!

Thank you for taking the time to follow-up in this thread, many months later!

And our estimators thank you too! Their file names are like this: 0302038.Est. And the only way they could see the estimate title without opening the estimate was to hover over it. They can now do that again. Yippee!

Thanks everyone. I finally figured it out!

Mark tried to spell it out for me, but I still missed one important step. It only took me a couple hours to catch it. :~|

Here’s the code I was using…

Dim SavedRecordID As Long
Dim rs As Object

Set rs=Me.RecordSetClone
SavedRecordID = RecordID ‘Save current record ID
Me.OrderBy = strFieldToSortBy ‘Re-sort the data
Refresh
rs.FindFirst “RecordID = ” & Str(SavedRecordID) ‘Go back to starting record in recordset
Me.Bookmark = rs.Bookmark ‘Go back to starting record in form

See anything wrong with that code?? Everything worked right up until that last statment. The form just would not move.

I was using the Locals window in the VB editor to follow the contents of Me and Rs. I could see the Rs.Bookmark change when I did the FindFirst. But the Me.Bookmark would not change when I tried to set it to Rs.Bookmark.

Then I remembered seeing a difference in the contents of Rs at the critical point when Rs was set to Recordset.Clone vs. when Rs was set to RecordsetClone. In comparing those, if I used Recordset.Clone, Rs still had Bookmarks (for some reason unknown to me), but if I used RecordsetClone, Rs did not have any bookmarks (“Object invalid”).

After seeing that “Object invalid” a few times, it finally dawned on me that I had to re-establish the recordset again after re-doing the OrderBy and refreshing! Doh! Of course!

So, in the end, the code looks like this:

Set rs=Me.RecordSetClone
SavedRecordID = RecordID ‘Save current record ID
Me.OrderBy = strFieldToSortBy ‘Re-sort the data
Refresh
Set rs=Me.RecordSetClone ‘<==== The missing link!
rs.FindFirst "RecordID = " & Str(SavedRecordID)
Me.Bookmark = rs.Bookmark

Thanks again,
Jim.

Thanks everyone. I finally figured it out!

Mark tried to spell it out for me, but I still missed one important step. It only took me a couple hours to catch it. :~|

Here’s the code I was using…

Dim SavedRecordID As Long
Dim rs As Object

Set rs=Me.RecordSetClone
SavedRecordID = RecordID ‘Save current record ID
Me.OrderBy = strFieldToSortBy ‘Re-sort the data
Refresh
rs.FindFirst “RecordID = ” & Str(SavedRecordID) ‘Go back to starting record in recordset
Me.Bookmark = rs.Bookmark ‘Go back to starting record in form

See anything wrong with that code?? Everything worked right up until that last statment. The form just would not move.

I was using the Locals window in the VB editor to follow the contents of Me and Rs. I could see the Rs.Bookmark change when I did the FindFirst. But the Me.Bookmark would not change when I tried to set it to Rs.Bookmark.

Then I remembered seeing a difference in the contents of Rs at the critical point when Rs was set to Recordset.Clone vs. when Rs was set to RecordsetClone. In comparing those, if I used Recordset.Clone, Rs still had Bookmarks (for some reason unknown to me), but if I used RecordsetClone, Rs did not have any bookmarks (“Object invalid”).

After seeing that “Object invalid” a few times, it finally dawned on me that I had to re-establish the recordset again after re-doing the OrderBy and refreshing! Doh! Of course!

So, in the end, the code looks like this:

Set rs=Me.RecordSetClone
SavedRecordID = RecordID ‘Save current record ID
Me.OrderBy = strFieldToSortBy ‘Re-sort the data
Refresh
Set rs=Me.RecordSetClone ‘<==== The missing link!
rs.FindFirst "RecordID = " & Str(SavedRecordID)
Me.Bookmark = rs.Bookmark

Thanks again,
Jim.

I’m just modifying the form’s Order By property and Refreshing.

Would that fall into the category of requerying? Or invalidate the bookmarks?

I’m just modifying the form’s Order By property and Refreshing.

Would that fall into the category of requerying? Or invalidate the bookmarks?

(Edited by HansV to make URL clickable – see Help 19)

Thanks, Hans. That works too, and I may end up using that.

But, I’m afraid I didn’t ask the right question.The really inefficient part of this procedure is the jumping around from field to field just to do the search for the starting record (which I must do twice). Is there another way I can get back to the starting record without jumping to the RecordID field, searching for the initial RecordID number, then jumping back to the field in which I started? It’s unsightly to have the cursor jumping all over the place.

I tried Bookmarking, which didn’t work at all for me.

I also tried defining a recordset.clone and doing a FindFirst (based on the Method 1 shown here:
http://support.microsoft.com/default.aspx?…kb;en-us;287658%5B/url%5D
That didn’t work either, but maybe because the last statement uses the Bookmark function, which doesn’t seem to work for me for some reason.
I’m not sure what I’m doing wrong…

Maybe I just need a way to hide the cursor during the jumping around and I just continue using the procedure I have??

(Edited by HansV to make URL clickable – see Help 19)

Thanks, Hans. That works too, and I may end up using that.

But, I’m afraid I didn’t ask the right question.The really inefficient part of this procedure is the jumping around from field to field just to do the search for the starting record (which I must do twice). Is there another way I can get back to the starting record without jumping to the RecordID field, searching for the initial RecordID number, then jumping back to the field in which I started? It’s unsightly to have the cursor jumping all over the place.

I tried Bookmarking, which didn’t work at all for me.

I also tried defining a recordset.clone and doing a FindFirst (based on the Method 1 shown here:
http://support.microsoft.com/default.aspx?…kb;en-us;287658%5B/url%5D
That didn’t work either, but maybe because the last statement uses the Bookmark function, which doesn’t seem to work for me for some reason.
I’m not sure what I’m doing wrong…

Maybe I just need a way to hide the cursor during the jumping around and I just continue using the procedure I have??

More info …

I’ve since found that, on the affected workstations (those with SP1), if I move the file to a local drive, the additional information shows in the InfoTip box. The additional information does not show when the file is on a network drive.

The unaffected machines (those without SP1) do not have this problem — the additional information shows whether the file is on a network drive or on a local drive.