Search results

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

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

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

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

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

Bonehead question here: In a datasheet, how can I get VBA to set an unbound control's value on only the current record, but none others? Thanks. Wayne

I'm using Access 2003. In the AfterUpdate event of a checkbox control on a subform, I have the following code: Me.RecalcThis line seems to cause the entire form to save (or at least it causes the form's BeforeUpdate event to fire). Is this behaviour expected? I don't see this mentioned in...

I'm working with Access 2003. I have a subform on which I need to set the focus away from controls I need to disable, but only if the focus is on the columns to be disabled. I need to do this in the Form_Current event handler, where I run code like this: fNeedToSetFocus =...

I'm using Access 2003. I hope someone can shed some light on a problem I have with an MS Access subform connected to an Oracle back-end. If I do the following, I see #Deleted on all the fields of an inserted record in a subform: 1. Insert the new record. 2. Enter a value in a nullable field...

I'm using Access 2003. Is it possible to set the top margin on the first page of an Access report different from all the other pages? Thanks for any help you can give. Wayne

I'm using Access 2003. I have a simple form that is exhibiting behavior that seems very bizarre. I've attached the mdb. Here's how to see what I mean: 1. Open frmEmployee 2. In the Vehicle combobox, select the first entry (2005 Pontiac Montana). Note that for this vehicle, Inactive = No...

I am using MS Access 2003. I have a report whose Detail band contains a zero-height Comment field positioned at the bottom of the other single row of fields. It has Can Grow = Yes, so it sits waiting to grow if there's any data in this Comment field. (See attachment 1, where this Comment...

In a form's VBA code, I'd like to know whether a full record has been selected, like when the user selects one or more rows before deleting with the Del key. Is this possible? According to http://msdn.microsoft.com/en-us/library/office/ff823187.aspx, Me.SelHeight returns the number of rows...

I'm using Access 2003. I'd like to override the default behaviour for deleting records in a form. Specifically, I want to build my own custom delete procedure so that when the user presses the Del button, my code fires to complete the deletion of the selected record(s). In order to do that...

Probably a bonehead question . . . I'm trying to extract information from Err.Description within a form's Error event. Alas, Err.Description does not seem to be available from there. I have a form that normally displays in DataSheet view. If a trigger on the Oracle back-end raises an error...

I'm using MS Access 2003 with an Oracle back-end via ODBC. I have Oracle triggers that raise various error numbers on the back end, like this: EXCEPTION WHEN billing_details_exist THEN raise_application_error(-20000, 'Billing details exist for the rate period for rate type ' ||...

I'm using MS Access 2003. I have a custom function that opens a recordset using a temporary pass-thru QueryDef object. Here's the guts of my code: Public Function OpenRecordsetPassThru(ByVal pstrSQL As String, Optional ByVal pstrDatabase As String = "ORACLE", ...) As Recordset On Error...

I'm using MS Access 2003. I need to create a temporary pass-thru query with Type = dbQSPTBulk. Here's my code: ' Create a temporary pass-thru query Set qdTemp = db.CreateQueryDef("") ' Set properties of temp pass-thru query qdTemp.Connect = strConnectString qdTemp.ODBCTimeout =...

I'm using MS Access 2003. I'm puzzled about some behaviour that I cannot explain. Was hoping someone might be able to illuminate me. I have a form on which I have a combo box, call it cbo1. In its AfterUpdate() event handler, I have the following code...