Search results

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

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

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

When a user DELETE's a record, how can I refresh or requery the form AFTER the delete's been done in the physical table? I am not performing a DELETE Confirmation, therefore I cannot use AFTER DEL CONFIRM or BEFORE DEL CONFIRM events. I've tried DIRTY-ing a control in the ON DELETE event, but...

Any way to tell when a ROW on a continuous form has been exited? I ask because the underlying record source table does not get updated until the ROW is exited. I then want to refresh after the physical table is updated. Hope this makes sense. Thanks.

I've created a list box in a subform, but the property List Rows appears to missing. Is it just me? Or is this the way it is? Thanks.

I feel so stupid...like I should know this. But... I have an After Update event, whereby when the user inputs a value into a text field and then tabs over, the code checks for the value's validity. If invalid, I issue a msg to the user stating such. BUT, the cursor moves to the next field...

This is driving me crazy! I don't know how this got changed. Under Combo Box properties, when I click on the Row Source ellipses (...), it used to go straight to the Zoom window, now it goes to the Query Builder. How do I reset this default to go straight to Zoom? This has changed for all my...

How can you verify if the VBA statement "rst.Update" actually worked? I'm looking for something like the RecordsAffected check after a DoCmd.Execute. Thanks.

Anyone else find this to be true? Whereas, OutputTo does allow pass-throughs.

I know how to open and pass a report a parameter from VBA using OpenReport. But how does the report accept this parameter? The parameter will be a table name. This is probably so easy, but I can't find the answer. Thanks.