Search results

@Gasman: It's not that simple. The Lookup form is a generic form that's used for lots of different data lookups, so it does not check for valid data in that form. It simply passes along the selected data to the target control and expects the target control to validate. This is the system I...

Well, in this case, MakeFormPick() actually displays a lookup form for the user to browse and select the desired value. After the user selects the value in the lookup form, VBA code takes the selected value and populates the target control (cboDefaultVendorNo).

I have a ComboBox cboDefaultVendorNo with a BeforeUpdate event that displays an error msg and sets Cancel = True if a condition exists. If I select data from that combobox using the form, cboDefaultVendorNo_BeforeUpdate fires. If cboDefaultVendorNo_BeforeUpdate sets Cancel = True, I cannot...

You're right. Current does indeed fire after the filter applies, so that's what I'll use. Thanks! Wayne

Does any MS Access event fire when clicking the "Filter by Selection" button? I mean *after* the filtering has completed? I'd like to update a counter on my form after the filtering completes. I tried putting code in the ApplyFilter event handler, but it doesn't work. Online help says this...

Maybe a dumb question, but . . . I have a subform in datasheet view containing data that fills more than the default-sized form. The left-most column contains Unit Numbers of vehicles in a fleet. When the user scrolls to the right, additional data displays for those vehicles. Is it possible...

Your comments helped clarify some things for me: 1. Yes, Form_Error() is really the problem here. If I check DAO.Errors(0).Description when an ODBC error occurs in a form, all I see is "This action was cancelled by an associated object." Not very helpful. This problem is documented here...

Thanks. Would you be able to post your database in mdb format? We're on Access 2003.

I've concluded that Form_Error() will know that the incoming error is from ODBC if DataErr is one of the following: 3146 3151 3154 3155 3156 3157

Your response (and link) reminded me of another angle of attack: Try to identify which set of DataErr values constitute an ODBC error. Not sure if that's what I need, but the following listing suggests a bunch: http://www.fmsinc.com/microsoftaccess/errors/ErrorNumberAccess2010-2003.pdf But...

I'm not convinced that's necessary. Form_Error() does not need to know anything about the back-end in order to do what I want it to do. All it needs to do is answer this question: "Is this error coming via ODBC or not?" Once I have that answer, I have all I need to know to make this work. I've...

Long Story: We have an Oracle back end, Access front end. Unfortunately, when, an ODBC error arrives in Form_Error() from Oracle, say a constraint error, it's very cryptic. We want user-friendly without having to duplicate the error-detection logic in the front-end. I've implemented...

Thanks, Mark. Just what I need!

For any given control on a form, I need to know, in VBA, whether that control is on a tabpage, and if so, which one (Page Index is fine). Can this be done in VBA? Thanks. Wayne

SOLVED: Dropped Back-end Oracle Sessions In Ms Access, Access 2003 I tried that, and it does seem to work! However, I also found another way: Remove the PK column specification from the linked table in Access. The form's RecordSource is an Oracle view, to which we have an Access table link...

The link suggests this might be an ODBC issue/setting. I tried disabling the "Enable Query Timeout" in ODBC. No joy. Wayne

Hoping someone can help. We have an MS Access app that connects to an Oracle back-end. After about 10 minutes of inactivity, MS Access's connection to Oracle gets dropped (as per TOAD's Session Browser); a few minutes later, a form (opened when starting the app) looks like the attached. If I...

Thanks for the many suggestions. This is obviously rather complex. Static, can you give more details re how to use your sub. Thanks. Wayne

I'm using Access 2003. I have a FormView form which contains a Datasheet subform in the Detail section plus a Form Footer that contains tabs displaying additional info about the record selected in the Detail section's Datasheet. (See attached.) I'd like to be able to make the footer resizable...

Yes, and yes.