Search results

Thanks Shadez. I appreciate your helpful comments. On the line: "Private SR As clsSetRow", isn't as clsSetRow the property? If not, how do I set the properties?

This doesn't seem to resolve it. I keep on having this "error messages". Any other ideas what could be the problem?

I am lost on this without your help I appreciate any help which you can provide. This issue is slowing me down so much.

When I process the below code in an AfterUpdateEvent of a subform field, I get runtime error 97 (Object variable or With block variable not set). The debug window marks the following line yellow: OrigSelTop = SR.SelTop FYI: I use Access97. ' Our class to hold a couple of Public vars...

I agree. Rich is extemely good. He has prevented me many times from having a heart attack. Many thanks to you both. I'll try to solve this issue. At least I know now what makes this happen.

I have been into VBA for about 5 months now (learned by doing and by learning from the great people in this forum). I have therefore just basic knowledge. Do you agree with me that I will have to check the coding mainly in the OnClickEvents. Do you see any other events that could make this...

Hi directormac Thanks for the response. The same thing happens if I click on control B. This happens regardless whether the subform has already the focus or whether it just gets it.

Thanks Rich What exactly do you mean by that?

I have a subform with the fields A, B, C and D. When I try to click on field C (third field) of a specific record, the cursor goes first to field A (first field) of this specific record. When I then click again on field C, the cursor enters field C of this record (what I wanted to achieve with...

Is there a VBA code to make the blinking cursor disappear during the processing of a time-consuming code?

I am stuck with this question. Please help. Thank you so much.

Any Ideas?

Thank you all. This works perfectly.

for your information: The question relates to a continous subform.

I have a subform with several text boxes (let's say A, B, C and D). When I try to click on text box C (third text box) of a specific recordset, the cursor goes first to text box A (first text box) of this specific recordset. When I then click again on text box C, the cursor sets the focus on...

Yes, I re-named it. I don't get any error message but no rows are colored.

Thanks Rich The numbering works well. However, the coloring is not working with the code below. Did you get it to work? Stefan

This message was once put in this Access Forum: ____________________________________________ Below is the code from the Microsoft Access 97 "Reports" sample db that alternates the color between rows within a report. You should be able to modify the code to use in a form. Private Sub...

Custom solution for this common problem This did not work unfortunately, the cursor stays in the first record. I guess that this problem is quite common. There must be an easy solution for that.

I agree But how do I get the cursor actually staying in the original field even if I refresh form B? And how do I make sure that the subform A does not move after the refresh (there is plenty of space below). The subform A actually moves in a way so that the record in which the cursor is...