Recent content by Cameo

It has 'Expression Is' '[Descr]="Volume" ' Have you tried to recreate this? Using both duplicates on and off? Thanks!!

On a report field, I have Hide Duplicates=No AND conditional formatting on that field which depends on a value for this field. I get #NAME as result. If I remove conditional formatting or set Hide Duplicates=Yes, I get the correct data. I've found this error in other posts, but no answers...

createobject("Excel.Application") ActiveSheet.Outline.ShowLevels won't work. I only want Level 1 and Level 3. I just want the data, then a count of rows.

I want to have the Excel file show the data and end with a Grand Total row (number of rows), no subtotals. Anyone know how to do this, please?

What is a dashboard component called? You know, the separate "screens" or "windows"? Widget doesn't seem right since those can be individual controls. Metric lacks also since not all dashboard "windows" calculate something. I have a really cool Access form made up of several sub-forms, together...

Thanks, Trevor. We are going to do that. Is this a documented bug in Access?

When trying to export a table to text using the Export Text Wizard, when I choose columns to skip, I get error "The Microsoft Jet database engine could not find the object ''. Make sure the object exists and that you spell its name and the path name correctly." When I do not skip columns, it...

Can't use On Current as the record is not physically deleted til after the On Delete, On Current, and a few more events that fire off when the user deletes a record. Try it in debug - you'll see. Also, the Help for "Delete Event" states this. I REALLY appreciate everything. I'm in the US, it's...

I have a mainform that lists a count of items. The subform lists the items. If a user deletes an item, the mainform's count should decrement by requerying the underlying data table. This is a simplified description of what's needed.

It's on a subform; I'm wanting to update controls in the main form. But, from what I've read, this is not the problem.

Anyone watching this thread should be learning a lot about DELETEing a form record and how it's treated in the background. Current Event doesn't help. Record still not physically deleted til after the Current Event. (So the global I set in On Delete to be utilized by Current Event didn't help.)...

Thanks, gemma. That was my last resort. I know even though it will be hitting the Current Event A LOT, it will be fast. But, so inelegant. I was hoping someone knew a "secret" event or something. Thanks. That's the way I'm going.

Yes, the record disappears from the form but not the table until after it's ended the ON DELETE event. You can debug the ON DELETE event and you'll see that the table record stays until you've left the ON DELETE event. I have other form controls I need to requery after the physical record's been...

The ON DELETE event fires off BEFORE the record is deleted from the physical table. I need to requery the table after it's been updated.

One way is the user clicks on the left-hand record indicator arrow, and hits the DELETE keyboard key.