Search results for query: *

There is also the is-a/has-a/contain-the-doubt analysis methodology. If it is-a thing, it is derrived from the thing. If it has-a thing, it contains the thing. When in doubt, contain the thing. It's easy to remember, and works very well as a general rule of thumb. Wil Mead...

Don't confuse diaplay with storage. Dates are stored in a date value. Most date aware programs accept almost any date format. Ouch with that code! It kind of hurt all over, my eyes and brain will eventually find a way to forgive you. if isdate(data) then DateConversion = format(data...

Access should serve you well. Two things to be alert for are Slack Space and Filesize. Editing the Access database creates slack or unuseable space. Combined with the 1GB filesize limit a dynamic database could get itself into trouble. With only thousands of books, a Gig is a lot of space...

Try Forum116. Wil Mead wmead@optonline.net

Autoincrement is OK if you don't need to keep track of the record. It sounds like the Record Id that is duplicating is the tracking key. To make the ID work, you'll need to find a new way to categorize your records. For example a user id. After adding the record the ID will be the highest...

Jon4747, Upper limit of the search should be the square root of the number in question. change For intA = 3 To num \ 2 Step 2 to For intA = 3 To (num ^ .5) Step 2 for greatly improved performance. The factor pairs occur in pairs around the square root. Wil Mead wmead@optonline.net

Wild guess... Some things have a hard time with spaces in the filename. Quotes usually clear it up. Wil Mead wmead@optonline.net

Great when you are assigning, what about select statements or loops or if statements. I also prefer Constants up front in conditionals (saves me from getting burned in C). I find the control-space combo a handy tool. No solution to the humpelator but, gets me past well enough for now...

Both your frames already have the object embedded, just assign it. Assuming your declared them as AddObject in both, FrmMain should invoke frmAdd with Set frmAdd.AddObject = Me.AddObject frmAdd.Show'... or Load Wil Mead wmead@optonline.net

You'll be much better off finding a way to externalize the value. You said recompile, so you have control of the source. Shift the Value to an external object. INI File, registry, or whatever. If that's the only configurable item the envirionment and command line are other places you can...

You might want to try FORUM207 or FORUM708. Wil Mead wmead@optonline.net

You can even change the on error state. HandleError: Dim ErrorCount ErrorCount = ErrorCount + 1 If 3 < ErrorCount then ON error GOTO FailError endif '... Adjust to attempt error resolution ... Resume FailError: MsgBox &quot;Just cannot find a way to do it&quot; On...

You need both options. Option #1: Create method allows manipulation of the properties to specialize the unit creating a new unit. Option #2: Copy method allowing the unit to duplicate an existing similar object. The difference between the two is subtile. The main difference is the source...

We both still crumble to the floating point requirements for the large numbers. What happened to that thread about Mod on Huge numbers? Limiting the search to prime numbers might speed up your process. The problem becomes making the cost of getting the next prime worth it. The cost of...

Apply what you know about prime factorization in fraction to the problem. Above I told you how to reduce ALL fractions. Applying the information to this sppecialized situation we can easily simplify the process. This is decimal reduction, so all denominators are Powers of 10. The prime...

John, You are right, MyFunc() represents the value. The syntax also permits to use a Function as a Sub. In VB this means dropping the parenthisis OR putting CALL in front of it. VB uses the parens to signal the type of call. Assigning the value to a dummy creates the trivial problems of...

I recommend a slightly different solution. You must assure that the authorize/authenticate method makes the decision returning only results. This puts your password package in jepordy less often. Assuring that the decision making process remains in the authorization method standardizes the...

Factoring is easy once you remember a few tricks. Prime numbers makes the problem so much more fun. When looking for factors, start (or stop) at the square root of the number (nearest whole number is fine). That is the point where you factor pairs begin to repeat. HCM = Product of non-shaired...

The drawback to Personal.XLS is it's personal. Remember where the functions you depend on come from. For a personal implemetation of XLS it's seldom a problem. Imagine the embarasment when you give the sheet to someone who doesn't have your macros. Wil Mead wmead@optonline.net

Chip, I was looking for Forum222. Works just like threads and FAQ. Wil Mead wmead@optonline.net