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!

  • Congratulations strongm 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: *

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

Part and Inventory Search

Back
Top