Search results for query: *

As has been noted in other posts, the FindNext does not work when used in a UDF (User Defined Function). This can be quite irritating / frustrating because the exact same code will work in a Sub. However, for those wishing to have the FindNext feature available in a UDF, here is an alternative...

this seems to be a simple question, but i don't know how to do this... so here is the problem: within the pre-defined VBA constants there are names and coresponding values. When using the constant's name, you have easy access to the value. For instance, the simple command of...

Hi everyone, Here is a confusing one: I have a form, which is based (indirectly) on a crosstab query. This means that the resulting number of columns and thier names are different for each load of the form. I have worked thru almost all the issues of handling the dynamic columns (upto a...

Hi everyone, I've been banging my head against a wall over this problem, and am about to give up. but I hope that someone can help me with this one. the idea is simmilar to thread http://www.tek-tips.com/viewthread.cfm?qid=768863. basically, I have a parent form (form_A) with 2 subforms...

Hi Everyone, First I want to say as someone new to VBA, that this site / Forum has been very, very helpful to me. THANKS FOR ALL THE POSTINGS!!! also, a quick question: How can I create a new table that is based on the defintion of an already existing table? for example, my code process...