Search results

I can certainly see the value of having properties and methods at your disposal when creating a custom control such as Mile's--which, by the way, I'm totally going to use as the basis for my own custom date/time picker that will work in a continuous form, unlike MS's ActiveX control. Yet...

Search Access help with the phrase "Activate Event". --Active Mac

Looking back at your earlier posts, I think (as was suggested earlier) that you may have a problem with the basic structure of your tables and their relationships. Zip up your db and upload it so those trying to help have a better point of reference. --Structured Mac

A perfectly valid reason, and one that has inspired a couple of my own projects. This makes it all the more important that you start with a list of very specific goals to make sure that YOURS doesn't suck as well... --Goalie Mac

Other Options Please don't take offense at this, because I truly mean it in a helpful spirit... (1) Have you considered purchasing an off-the-shelf piece of rental property management software? I'm not trying to discourage you--if you WANT to do this in Access as a learning exercise, then...

OOP in VBA Having done some VB.NET, some C++, and even some Cocoa, I understand the concept of Classes--what I don't get is (1) if they are handled/stored differently in Access VBA coding than a typical sub or function is and (2) how they fit into an Access/VBA application. Since each record...

Methinks you need a statement in both case 1 and 2 that increments intMyCount, else it's always case 1. But I just woke up... --Groggy Mac

Forgive me showing my ignorance, but I have my reputation as the world's oldest newbie to protect... When you say "Class Modules", are you referring to something different than a typical VBA module file? I always plundered old db's as well, but I've grown too tired and lazy anymore to remember...

Having been off the forums for a looooong while, I feel the need to get some new discussions going... here's a question for all you guru's out there. Do you have your own "Standard Library" of functions that you have found so useful that you just automatically include them anymore? What are...

Makes perfect sense. If there is any kind of identifier for each of the houses (or whatever) that you have recorded before the client fills out the paperwork, I'd suggested adding that to each line to help them organize. Otherwise, just: #1: _________________ #2: _________________ etc...

Looking briefly at your first attachment, I'm not sure WHY you want a report with all those blanks on it. BUT, I'd probably use a bit of VBA code to create a temp table with a # of records equal to your # of units, then whip up a subreport with one "blank line" in the detail sourced to the temp...

Try IsNumeric, IsString, "number", "Numeric", and anything else you can think of. Also "between", depending on what your actual data is. And search the forums. --Hinting Mac

What version of Access are you using? Search Access help for the function IsNumber. --Helpful Mac

This is what queries are for. If you've been reading manuals all week, should be a breeze... Give us a little more info on your table structure and what you want to do with these summations (i.e., do you only need to see that kind of summing when you print a report, or do you need it for...

This topic has been covered endlessly in other posts. Search the forum on the keyword "null". Also check Access help on the words "null" and "nz". This article will probably also be useful. Always search the forum before starting a new thread. 99.999 percent of the time your question has...

BTW, you can always run a one-time update query to fit your old data to a new & improved structure without loss. --Upgrade Mac

Did you add autonum keys to the other tables as well? I promise it will make life easier... Check out the attached. It uses your own structure, basically, but with slightly cleaner relationships due to the use of autonums everywhere. Be sure to check out the queries and form recordsources as...

Forget the above, just use subforms. See if the attached is at all helpful. It doesn't tally, just displays at this point. Set the OnClick event of the rectangle next to each answer to run some code to add the appropriate record to tblResultsDetails. Also needs a form for the creation of...

Thought you wanted a radio button / option group, or something like it? Look at the Northwinds sample and search Access help on how they create the main menu forms. Couldn't you do something similar? --Pondering Mac

And the answers definitely repeat way too much... --Still-Working Mac