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!

Recent content by jcarroll

  1. jcarroll

    (3426) This Action was Cancelled by an Associated Object

    Platform: Access 2000 Hi, I am having trouble correcting an error that occurs when I issue the addnew command on a dynaset type recordset. This recordset is set to the .recordset property of a bound form. ----------------------------------------------------------- Dim rstStatus As Recordset...
  2. jcarroll

    Form Dies After Deploying DB

    Platform:&nbsp;&nbsp;Access 2000<br><br>Hi,<br><br>I am having quite a bit of trouble with my access 2000 database after deploying it.&nbsp;&nbsp;<br><br>When opening my database and using it through the regular access interface, the same one that I have used to design it, it runs...
  3. jcarroll

    Subform Filteron Property Triggers Current Events For Parent Subforms

    Version: Access 2000<br><br>Hi guys,<br><br>I am having trouble when setting the filteron on property for a subform which I'll now refer to as sfm1.&nbsp;&nbsp;sfm1 shares a main form with two other subforms.&nbsp;&nbsp;Basically how it is set to work is that I have a list box with which I jump...
  4. jcarroll

    Platform: Access 2000 logic with forms

    Hi guys, thanks for your reply's.&nbsp;&nbsp;My biggest problem isn't deciding when to load up my forms.&nbsp;&nbsp;In fact, Bigfoot, loading the forms your way would be perfectly fine for my application.&nbsp;&nbsp;Heck, I don't really need to pre-load at all.&nbsp;&nbsp;<br><br>To summarize, I...
  5. jcarroll

    Platform: Access 2000 logic with forms

    Platform: Access 2000<br><br>Hi,<br><br>I am having difficulty figuring out the logic behind closing the forms in my database.  I have just changed the structure of my database sothat it loads all forms in hidden mode on startup and then unhides<br>them when the user chooses to open them.  When...
  6. jcarroll

    Query: Returning 3 most recent records for each parent record...

    Thanks rochelle, I was eventually able to solve this problem however I did not get around to trying your solution.&nbsp;&nbsp;Instead I ended up using a MS KB article Q153747, which detailed a custom function as a criteria for my query.<br><br>Justin
  7. jcarroll

    Query: Returning 3 most recent records for each parent record...

    Hi,<br>&nbsp;<br>I am having trouble constructing a query which will pull out the three most recent child records for each parent record in a table.&nbsp;&nbsp;I tried using the top statement, however, this only succeeds in pulling out the three most recent records in the entire child table, not...
See more

Part and Inventory Search

Back
Top