I Have Encountered Two Problems - Access Developers


	Back to Access Developers Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

I Have Encountered Two Problems

Werner Mildt

3 months ago

1) I am using Richards ThirdWed Function and it works just fine.
However, I am getting a compile error. Please view picture.
2) I am also having problems with the helptext function.
It works on some forms I have, but not on others.
Like a new form I crated.
Please see code attached.
Thanks Werner

	Werner Mildt OP @Reply 3 months ago

	Werner Mildt OP @Reply 3 months ago

	Kevin Robertson @Reply 3 months ago
You have 2 Do While loops but the first is missing the Loop keyword. The error message tells you this.

	Werner Mildt OP @Reply 3 months ago
Thanks Kevin, I fixed that. What I don't understand is, I never touched or edited. This is Richards Function??? Any way's, it's fixed. Thank you for your help. Werner P.S. You would know what the second item could be? There is no error but the textbox stay's blank.

	Alex Lewis @Reply 3 months ago
Is your SetHelpText function in a public module, or do you just have it in each form?

	Werner Mildt OP @Reply 3 months ago
Alex, it is public. Option Compare Database Public Function SetHelpText(S As String) HelpText = S End Function

	Werner Mildt OP @Reply 3 months ago
Thank you all. I have solved the problem.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developers.

Next Unseen