Search results

Hi Wayne, I like your solution a lot :) Thank you! Nice! :) I spent hours on this problem! hehe Still, this is my first Access DB and VBA project :) I wanted to do some kind of Hover function, to change the color of the row the mouse is over. However, whilst a command button on the form...

Sweet :) The problems I found with my original implementation (hence the addition of the Label 'Sheild') were: 1) A user moving the mouse rapidly could interfere with the results of the GetNumber stage 2) After formatting (bearing in mind I was referring to alternate 'Row' colors not 'Field'...

Hi, After a *lot* of searching, and looking at various code samples, I finally figured out a *very* easy way to get alternate Row colours (colors) in continuous forms. I can't post a sample just yet, but the instructions are: 1) Create the Public function: '(Create the Variable first)...

Hi Roy, Brilliant, thank you for clarifying that :) Pretty much what I had assumed, but interesting to know about the 'Public' form Procedure, nice one :) Kind regards, Geoff

Hi Everyone, I hope this isn't a really stupid question :) Basically, I've searched and searched, but can't seem to find an answer to the following: If I create a Sub or Function that is bound to a Form, so It's only accessible by that form (private). So what is the difference between typing...

Now that WAS a rapid response, thanks Mile-O :) So if I uderstand you, with an example scenario of Private Sub A calling Public Sub (or Function) B. Upon completion, Public B returns the process back to Public Sub A. When Called, Public B may have been handed values that it assigned to...

Thank you so very much for your explanation Pat! The fog has lifted as they say :) I may not have explained my understanding of the difference too well (I don't really speak the lingo ;) ) but it was along the lines of how you described. And thanks Chris for the code samples, I'll be looking...

Hi Mile-o-Phile :) Many thanks for your quick, short-but-sweet reply. The code that I mentioned was your Limit Characters Typed In A Control function. Your original version was a Function, and after following a (very simple) code example on support.microsoft.com, I changed it to a Sub. Is...

Hi All, Please forgive me if this is a stupid question, I am new to VBA. I was just wondering if someone could explain simply, the difference between a Public 'Function' and a Public 'Sub'. Specifically, when the use of each is recommended, and how they differ from each other. The only...