Search results

I get the following error when I try your code: Any ideas?

I'm using MS Access 2003. I have a form containing a subform control sub1 whose Source Object is frm1. I also have (on the same form) another subform control sub2 whose Source Object is frm2. Both subforms display in Continuous view. Subform sub2 offers the user the ability to filter its...

Thanks for editing your post. I was scratching my head wondering why it wasn't working. But it's working now! Woohoo! Anyway, kudos to both you and mdlueck. BTW, any chance of getting a Coles notes of what your additional code does to make this work? (I had tried injecting "Me.txtCurrent =...

I like your solution. It works and is simple. Thanks! Wayne

Here you go. I have stripped down the DB to the essentials that show the behavior. To reproduce the behavior: 1. Open frmLiaErrorCorrection. 2. Click the Delete button on any record except the currently selected one. 3. Notice that the MsgBox appears before the row is highlighted, even...

I'm using Access 2003. I have code that highlights each record selected, based on code that lives in the form's Current event handler and conditional formatting. I also have a button displayed on each record that deletes that record when clicked, but only after displaying a warning. Problem...

That did it. I thought maybe there was a simpler way, but perhaps not. Thanks. Wayne

I'm using MS Access 2003. Probably a dumb question, but I'm not finding the answer anywhere. I have a command button that I'd like to use to logically delete the record and update the change to the database: When the user clicks the button, the Clicked event would change the value in the...

I'm using MS Access 2003. I have the following code behind a command button: Private Sub cmdRevalidate_Click() On Error GoTo ErrorHandler Dim liaArchiveCount As Long Dim myWorkSpace As DAO.Workspace Dim myDatabase As DAO.Database Set myWorkSpace = DBEngine.Workspaces(0) Set...

Could you please elaborate on how you would use a dereferenced variable, rather than a form reference? How does the subform know where to get the value for the variable? Thanks. Wayne

No, because neither of the dropdowns have reverted to old values yet when those requeries happen. I need to somehow be able to run the requeries *after* the values revert. I can do that after the fact by manually by clicking on the parent and child combos, but I had hoped I could do that in...

You're right that Undo does indeed fire on ESC; however, if I look at the form after it hits the breakpoint, it still has not reverted the values. So it appears that it's a timing problem: The Undo event fires before Access restores the values, so the requery happens but it's still against the...

On Current does not seem to fire when I click Esc. The combo box Click event fires only after I click one of the *entries* in the combo box list (which is still the unrefreshed old list) rather than when I click the combo box to display the list. But I'd want the list requeried before it is...

But it seems that the user can no longer cancel the record update because I'm always trapping the Esc. Or am I missing something?

I'm using MS Access 2003. I have a cascading dropdown on a columnar form that works well except when the user cancels a record update by pressing the Escape key. Not sure where to code the cure. DropDown #1: cmdDestinationCode After changing the DropDown value, DropDown #2 is refreshed as...

Thanks, Bob! Works great!

I'm using MS Access 2003. I have a form whose underlying Control Source (query) returns the column "TugArchiveDetailId". From within VBA, should I be able to access the value stored in this field and make decisions based on it? I can access the value if I put it on the form as an invisible...

Yes, a bit clumsy bit it works. Here's another link I found with more details: http://www.pcreview.co.uk/forums/enable-disable-command-button-each-record-continuous-form-t3668995.html Thanks. Wayne

Is there a workaround or alternative approach to accomplish basically the same thing? Wayne

I'm using MS Access 2003. I have a form in Tabular (Continuous) View, so there are many records displayed at a time. I would like to add a command button to each row, enabled or disabled based on the nullness of a specific field on each record. I cannot seem to make it work. Here's the code...