Search results

Hello All, I have searched these forums for multiple days now, and attempted to reverse engineer just about every post on searching from forms so that it works for my database, but, unfortunately, I'm simply not good enough at VBA to get it to work. I would love it if someone could please help...

Thanks, pbaldy! It worked like a charm. This is a classic example of trying to get too fancy with code when an easier solution already exists.

Hello, I think that I've read all of the posts about searching on this forum and they either aren't what I need to do or I'm too ignorant of VBA to understand them and I would really appreciate some help. I have a form that opens when a user opens the database and I would like it to say...

Doesn't the variable designation I posted do this same thing? I was under the impression that if I had the routine I posted, if I have Whatever.Forecolor = Black then it would be black. I don't see the value of first converting from RGB to numeric then to a name if you can go right from RGB to...

As I am clearly a VBA Access beginner (betrayed by my choice of bed-time reading), would either of you be so kind as to explain how I would know that it should be variant instead of long? Also, Guus2005, what do you mean by enum type eColor? Is that some better way of declaring and utilizing...

Hi Everyone, Here is some code to predefine different color variables to make your life easier. This is provided by Alan Simpson via Access VBA for Dummies and is reprinted with permission. Enjoy! Sub DefineColors() 'Delcare color names. Dim Beige, Brown, Chartreuse...