Recent content by Bennet

  1. B

    Apparent MS Access bug related to hidden navigation pane

    Here's how I sometimes use set parameter to feed parameters into queries: DoCmd.SetParameter "TheParameterName", 17 <- example value DoCmd.OpenQuery "QryWhatever" I'm vaguely aware there are other ways of doing this, but this one I've always found very straightforward to implement and very...
  2. B

    Apparent MS Access bug related to hidden navigation pane

    Just wondered if this is something people are aware of and what might be known about it. I've noticed that you cannot manually trigger a DoCmd.SetParameter BEFORE you have viewed the navigation pane in a database. To demonstrate this in its simplest form, if you: 1. Create a blank database 2...
  3. B

    My "Please Wait" form blackens the rest of the screen

    Perfect! I love this. Thank you! (Is there any particular reason not to just do this?): DisableAllTimers DoEvents EnableAllTimers
  4. B

    My "Please Wait" form blackens the rest of the screen

    Hi everyone, For about ten years I have had a "Please wait" style form that I use to keep the user informed when they are waiting for some long running operation to be completed. I might update this multiple times during a process. "Downloading results" "Calculating totals" "Reticulating...
  5. B

    ADO RS.UpdateBatch - how do I get it to work?

    I'm blown away by the helpfulness of the responses here. Thanks so much for all the thoughts and assistance, and my sincere thanks to arnelgp for providing a working solution. If I've understood your solution correctly, MajP had it right. Binding the recordset to the subform somehow breaks the...
  6. B

    ADO RS.UpdateBatch - how do I get it to work?

    So the code I'm using is more or less lifted from that article. I believe the recordset is connected initially in order to populate it, then it's disconnected. Then it's updated via the code she has on the form. Then the recordset is re-connected to the table. Then she runs UpdateBatch to write...
  7. B

    ADO RS.UpdateBatch - how do I get it to work?

    Thanks for taking the time to look this. I see what you're getting at. I can update rows individually, immediately whenever they are edited, rather than en masse later on.
  8. B

    ADO RS.UpdateBatch - how do I get it to work?

    Hi CJ_London. My experience shows that holding open the connection to a network back end seems to lead to problems. Not sure if this is a general problem or a quirk on my office network, but I find that forms in a front end that directly reference a back end table, and hold that query open will...
  9. B

    ADO RS.UpdateBatch - how do I get it to work?

    (Just to add - I agree that error handling is highly advisable. I'm just trying to test/prove the concept at the moment, and no error is being thrown.)
  10. B

    ADO RS.UpdateBatch - how do I get it to work?

    Sorry, I realised I have muddied the waters by having the "non-wired" button. This occurred because I changed the button name immediately prior to posting and forgot to wire it back up. This isn't part of the issue I'm having though. The error message you are getting there only occurs, I think...
  11. B

    ADO RS.UpdateBatch - how do I get it to work?

    Hi there. Yes I do. Wouldn't be without it. :) Just realised you might be asking if it's an updateable recordset. If so, the answer is definitely yes. It's just one table. No joins. Nothing weird. I'm attaching a file that shows what I'm trying to do, incase anyone can help. (This is just a...
  12. B

    ADO RS.UpdateBatch - how do I get it to work?

    Hi arnelgp, I assume it's disconnected because this line of code appears to successfully disconnect it: Set MyDisconnectedRS.ActiveConnection = Nothing If I don't run this line, editing the recordset (via the subform) edits the underlying table, so the disconnection seems to work. Also, all...
  13. B

    ADO RS.UpdateBatch - how do I get it to work?

    Hi there. First time poster here. Just wondering if anyone can offer me some assistance. I am grabbing data from a local table, placing it into an ADO recordset, disconnecting the recordset, then applying the recordset to a subform. I then manually edit the data in the subform (let's say I...
Top Bottom