Search results

If I add a command button to the Header, that command button does not seem to appear in Datasheet view. Wayne

I should have mentioned that I'd like this code to work within Datasheet view, where the user could otherwise select and delete multiple records. However, I just noticed that KeyDown does not seem to work in this view, nor does a CommandButton appear. So it appears that what I want to do is...

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

Thanks for pointing out AccessError. Unfortunately, I still don't get everything that Oracle is sending. When I just allow the ODBC error to display, it looks like this: However, when I print AccessError(DataErr), I see this: I posted this question on UtterAccess, where BananaRepublic...

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

This was not quite the issue, but it got me working down a path that led to the fix. I'm still not sure what *caused* the problem. However, the form's recordsource (query) had a join to an Oracle view that used a lot more tables than necessary, some with outer joins. (The view was initially...

(Previously posted to Reports section, incorrectly. Sorry.) I'm using MS Access 2003. I have a form that displays in datasheet view. When I select a record and hit my keyboard's Delete button, I see the following error: This error *always* appears when deleting any record from this form...

Sorry, I posted to the wrong area. I need to re-post this to the Forms forum. Wayne

I'm using MS Access 2003. I have a form that displays in datasheet view. When I select a record and hit my keyboard's Delete button, I see the following error: This error *always* appears when deleting any record from this form. After clicking OK on this error, if I refresh the form, the...

Hmmm. Your suggestion worked. Weird thing is that I've used the % wildcard in other Access queries, and it's worked. Thanks. Wayne

I'm using MS Access 2003. I have a SQL Server table with some records (not all) whose "description" column contains a vessel name embedded inside. I'd like to select the records whose description contains one of the vessel names in another table. In SQL Server Mgt Studio, if I run the...

That works great. Never thought it would be so simple. It's too bad that selecting that option doesn't also go to same field in previous record when pressing Shift+Enter (or something like that). But hey, this will do the trick. Thanks! Wayne

I'm using MS Access 2003. I've noticed that with a form in Continuous (Tabular) View, when I click the DownArrow on my keyboard, the focus does not move to the next record, same column, as it does when in Datasheet view. I want to use Continuous view because I need to put command buttons on...

Makes sense. However, some of my forms are Continuous forms listing many records with only a partial set of columns. On each record I have a button they can click to open up the record in a single-record form so they can see more fields. When the user is finished viewing or editing the...

I'm using MS Access 2003. I have several forms that have functionality that can change depending on what happens in other forms. My question is this: What is the best way to ensure that a given open form is current when it becomes active, given that its data might have been changed by another...

Yes, that's what I did and it worked. I call a function from the Switchboard, which sets the OpenArgs. Then in the the Form_Open event, if the OpenArgs parm indicates so, I use the custom filter rather than the default one the form would normally use. Thanks. Wayne