Menu

Data Form Deletions

Search this Thread

Prev

Previous Post

Next Post

Next

#2

Report Post

Dave Peterson

Posts: n/a

Default

You may want to contact MS directly:

I'm not sure anyone here can help you.

CyberTaz wrote:

Annoying for years, but perhaps the is an alternative I haven't discovered;

When finding records using the Data Form based on Criteria, the recordset is
restricted to only those which match the Criteria. However, if you delete
those found records one at a time (using the Form's delete button), once you
delete the last _matching_ record the next records in the list appear in the
form -- even though they _do not_ match the criteria. I realize it is a
matter of user recognition to notice that, but I can't begin to quantify the
number of users who have gon on to delete those additional records in error.
Particularly troublesome since Undo cannot be used to recover those records.

If I'm missing something, please advise. Otherwise I would like to suggest
either of two changes be made to the operation of the Data Form. Either;

1- Write the feature to *not* display non-matching records after the last
matching record has been deleted, resulting in an "empty" form and/or a
msgbox indicating no more records match the criteria.

2- A button written into the form to "Delete found recordset" and restores
the form to normal operation once clicked.

Thanks for your remarks |:)

--

Dave Peterson

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you transfer data from an input form in excel to an excel l	mdalzell	Excel Discussion (Misc queries)	0	April 18th 05 06:10 PM
Excel Data printed out as a Form	Becca at MRBC	Excel Discussion (Misc queries)	1	March 14th 05 10:05 PM
How do I get an Access form in Excel to Expand the Data	RogerN	Excel Discussion (Misc queries)	0	February 25th 05 06:04 PM
Pulling data from 1 sheet to another	Dave1155	Excel Worksheet Functions	1	January 12th 05 05:55 PM
How can I transpose data from a spreadsheet into a form that does.	Joby	Excel Worksheet Functions	3	November 30th 04 04:50 PM

All times are GMT +1. The time now is 12:23 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement