Re: "Set" command anomaly results in Null

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, I hope you can make this arrangement work for you and
the performance is acceptable.

For API stuff in Access, your first stop must be
www.lebans.com
Be sure to check Stephen's SetGetSB. If it doesn't take
care of your problem, it will at least provide ideas and
example code.
--
Marsh
MVP [MS Access]


BogMonster via AccessMonster.com wrote:
I agree it's messy. Like I said, I'm coming from an Excel background where
I've developed fairly sophisticated models but Excel is not a database and a
recent merger has resulted in the old model becoming obsolete overnight, due
to size. Hence a database solution became necessary. This is my first serious
venture into database development and I effectively have about 6 weeks to
design, develop and implement the new solution (while holding down my regular
responsibilities!). So I really had to run with my first instincts as I don't
have the time luxury or experience to try different approaches. There aren't
any other developers in my department and the formal IT group just don't want
to know my problems!! :-(

Yes, the HasModule was a subtlety as I don't have any code specifically in
those Grid forms and I read that performance is slightly better if you can
exclude them. One more notched down to experience. ;-)

When you mentioned that object can't be null , it was one of those "Doh"
moments. I've been programming long enough to know that but the class error
and lack of sleep combined to give me tunnel vision. :-(

Fortunately, this is a really good forum and I would be significantly further
behind schedule if it wasn't for people like you generously giving up their
time to answer other people's questions. Maybe one day I'll be good enough to
contribute!

I would certainly love to have the opportunity to have an experienced
developer look at my model when it's complete and critique it as that is an
excellent learning aid. Any volunteers? :-)

I think I'll be posting another question later regarding how to get a control
that is off-screen but that has focus, back onto the screen. When I skip
across the grid textboxes, those that are off-screen get the focus but to see
them I have to use the scrollbar. SetFocus doesn't seem to do it. It's been
quite frustrating that Access forms don't seem to have any way of
programmatically controlling the scrollbars, like Excel does. I think there
are probably some API routines that will achieve this but I'm not strong on
those yet.


Marshall Barton wrote:
A seriously messy situaion and I am not convinced that you
must use this approach. However, it's easy for me to say
that when I don't have to produce your app ;-)

A form is not a class object unless it has a module, so the
HasModule setting is absolutely required when you want to
use it as a class. It's a rather subtle requirement that
can easily slip through the cracks if you haven't seen it
before.
Many thanks for you prompt response. I guess I did go on a bit but I was
worried that I may leave something important out. :-)
[quoted text clipped - 39 lines]
invisible button controls over an area of a form and use the
button's MouseUp event to get the click's X,Y coordinates.

.

Relevant Pages

  • Re: 3vl 2vl and NULL
    ... > or API to the stored data is of primarily interest to me. ... >> designers are capable of defining the world for application programmers, ... I am more of an end-user (aka developer) looking to those ... But building an enterprise database is a lot more than succeeding at a lot ...
    (comp.databases.theory)
  • Re: GEDOM as a database format
    ... proprietary database, without the need for convoluted import/export. ... utility conforming to the description of that API. ... I can see commercial vendors having valid grounds for objecting if they were then expected to provide support for databases mangled by anything from well-meaning but ill-designed 3rd party tools to direct tweaking. ... any software author with strong feelings about non-SQL RDMBS such as rdb or about using persistent objects would rightly feel excluded - and who's to say such implementations may not be better? ...
    (soc.genealogy.computing)
  • Re: Big numbers
    ... information on how the API converts database values ... This is a numeric struct as defined by the ODBC standard: ... Database binding tends to be very specific either to the database (in ...
    (comp.lang.c)
  • Re: Open challenge to Fa-Goon
    ... world where all apps are written to read from, and write to, a single ... Each document would be a database entry, ... local database, in a flat file, in the cloud, etc.). ... API calls, and the code implementing the API would worry about those ...
    (comp.sys.mac.advocacy)
  • Re: Password management on Windows Domain Controller
    ... There is no API to do what you are asking and your only ... Joe Richards Microsoft MVP Windows Server Directory Services ... Password in AD are stored in AD database. ... >>access the password hashes. ...
    (microsoft.public.security)