How To Delete Column-Data Without Query or Macro?

[johnywhy]

Ok, fair enough.

But in this case I think we've established that the shouldn't is misplaced.

And I think the only "mistake" is that microsoft's implementation of bulk operations in sheet view is partial and incomplete.

 

[dfenton]

And I think the only "mistake" is that microsoft's implementation of bulk operations in sheet view is partial and incomplete.

Only if Excel is your model for how it should behave, and I think a spreadsheet is a very poor model for designing the user interface for data tables.

 

[MSAccessRookie]

Only if Excel is your model for how it should behave, and I think a spreadsheet is a very poor model for designing the user interface for data tables.

I agree, David, as will most people who have worked in Access for any length of time. While Datasheet type Forms have their place, and can be very useful at times, they are not and should not be considered to be the best and/or safest way to enter data.

 

[johnywhy]

Are you referring to datasheet FORMS which the access developer must create, or the backend sheet view, which is available automatically for all tables?

 

[MSAccessRookie]

Are you referring to datasheet FORMS which the access developer must create, or the backend sheet view, which is available automatically for all tables?

I am referring to the DataSheet type of Form that resembles the sheet view of a Table, but has much more Flexibility and control available.

 

[johnywhy]

So you critiquing the design of the Microsoft product. datasheet style forms are built into the Access product, so obviously Microsoft considers them legitimate.

Since you are advising developers that sheet-style forms are unsafe and undesirable, can you offer a reason?

 

[dfenton]

I'm not sure who you're trying to provoke, but there are a number of issues here:

1. expecting the UI in Access to behave like a spreadsheet -- not reasonable.

2. using table datasheets instead of form datasheets -- a reasonable rookie mistake, but anyone who has tried it should quickly realize it's a mistake.

Table (and query) datasheets are provided for convenience. But when you're creating an app for other users to use, they are not helpful.

 

[johnywhy]

hello

the question is about using FORM-based datasheets for user-entry. No one has suggested using backend datasheet table-view for front end user entry.

 

[dfenton]

Then I don't know what the dispute is. Nobody has suggested *not* using form-based datasheets, just that one should not expect them to be like Excel.