Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JohnHarkins
  • Order by date
  1. JohnHarkins

    Synchronized Continuous Forms

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

    Synchronized Continuous Forms

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

    Use variable instead of form name.

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

    Errors Galore 2427, 2447, 2465, 3075, 3079, 3420

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

    Access 2002 DB Corruption

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

    Alt Key Causes Continuous Form to Go Back to the Top

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

    Locating Control on Form or Report

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

    Properties Sheet Pops Up... Why?

    Terrific! John Harkins
  9. JohnHarkins

    Properties Sheet Pops Up... Why?

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

    Not-in-List Add Record

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

    DBCS Chinese Characters in Record

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

    Date or Null into datetime Field of Make-table Action Query

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

    Spinner ActiveX Control

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

    Text to Date Conversion Using SQL Select Query

    How simple; how elegant! John Harkins
  15. JohnHarkins

    Text to Date Conversion Using SQL Select Query

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

    Invoking Same Subform from Two or More Forms

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

    Referencing a Continuous Form Field Where Cursor Resides

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

    Referencing a Continuous Form Field Where Cursor Resides

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

    Continuous Form Current Record

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

    Formatting Continous Forms

    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

Part and Inventory Search

Back
Top