Search results for query: *

I'll take a look a little later. I'm just a little confused, since I thought that by doing the find's and all that sort of thing that my second continuous subform would reveal only a single record. What I'd like, just to restate and belabor things is to have a kind of "spreadsheet" that shows...

I have a main form with two subforms, each of which is a continuous form that refers to a subset of records. I want the flexibility of continuous forms over datasheets in order to haandle fancier headings and formatting than datasheets would offer. I can easily synchronize the sub forms to a...

I'd like to know a little more re "tag." Please explain this just a little more for someone unfamiliar with tags. Thanks! John Harkins

I'm installing an application for a client who has about 20 simultaneous users. With rare exception, the application works just fine with one user and fails with one or more of the above error codes. 2427 You entered an expression that has no value 2447 Invalid use of dot operator 2465 Run...

I really need more information on these problems, as I am experiencing very ugly error messages that never ever appear in a stand-alone mode. Specifically, I'm getting 3420's, 2465's, 2427's, and other assorted stuff. The client is screaming (well, just raising her voice a little) about why...

Somehow I've either written or copied code that causes the query for a continuous form to re-execute (i.e., requery) simply after holding down the alt(ernate) key. What's the best way to find out what's causing this ugly action? I would think I should just look for key-down or some similar...

This should be an easy question to answer. If I have "funny looking" code in VBA how can I find the control or controls which invoke the event? For example, I usually change the VBA-assigned event name to something meaningful by defining first the meaningful label or combo box name on a control...

Terrific! John Harkins

Hi! I've got a form and subform that work just fine. But... and you knew this was coming... what causes the properties sheet to show up when the subform appears? Did I do something in code (VBA) that would have caused it to happen? It doesn't always happen, but usually at an inauspicious time...

When I set up an event to handle the not-in-list for a combo box, I first invoke a subform which lets me add the data to the lookup table. So far, so good. Since I wanted to pick up the value that the user entered and stuff it into the subform for the lookup table, I do something like this in...

Hi! This is one of the strangest anomalies I've seen: the client had a record (which I cannot delete through normal means) whose words are in what appear to be DBCS format. I haven't a clue how they got there, but on the one record where this occurred, every single field in the record except...

Hi! My searching may be over. So far I've been only modestly successful, so maybe you can help me. I want to create a table from a union query that consists of two SQL action queries. The new field is to be in datetime format and is derived from another date field in the same record. The date...

There's got to be a good place to go to find out how to "install" the OCX for the spinner, but I can't seem to find something succinct. Please advise where I can find out how to find appropriate controls (I have a spinner with a version of 2.0), register it if it's necessary, then use...

How simple; how elegant! John Harkins

I have a date in text format that needs to be treated as if it were a data (i.e., #mm/dd/yy#). Maybe there's a better way to do it, but I have a number of dates in various months that need to be converted to the first day of the respective months so that I can consider all dates within a month...

Hi! I think I've got an easy one: I have a main form and a subform that work just fine. On the main form I have a command button that invokes the subform. In the subform is a query that refers back to the main form to pick up selection criteria. All's well. Now, I want to use the same form...

WOW! I can hardly wait to try out these good ideas. Thanks. John Harkins

I've searched high and low and I know there's an easy answer, but it's eluding me. I have a wide continuous form with lots of fields and want to create an "editing window" that will reflect two things: the name of the field that the cursor's positioned at on whatever row is current...

My client wants a spreadsheet layout with columns frozen on the left (a la datasheet view), but datasheet view won't work for a bunch of reasons having to do with formatting and layout. (Well, _maybe_ it would work, but at the moment it seems there are too many things to consider in that...

Ah, but wouldn't that disallow the field for _all_ records in the continuous form? For the time being, the "enable" feature will work just fine. Thanks! John Harkins