Recent content by WilMead

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...