Search results

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

I'm using Access 2003. I have a subform to which I would like to add checkboxes for the purpose of allowing the user to unassign records from the master form record. When I pull up a master record that displays the details in the subform, I want to be able to uncheck the checkboxes on records...

I'm using MS Access 2003. I need to implement an Assign/Unassign form in Access, and I'm wondering how to do it. I have a Master/Detail situation where the Master table contains an Order record, one column of which stores the number of railcars of a particular commodity ordered. Later the...

I'm using MS Access 2003. I'm wanting to switch my Back-End from MS Access to SQL Server Express. Just not sure the best way to approach this. I've read that pass-thru queries to a SQL Server back-end can be very inefficient (sending the entire table of data over the network), so I'm...