Is there a way to simulate a Modal Datasheet?

[Guest]

We have a case where Utility Names were hand-entered into a regular textbox
and therefore there is no consistancy in how a particular utility name was
entered. I have changed this TextBox to a ComboBox with a list of utilities
to select from.

What I want to do now is update the existing data by using a one-time
procedure that will:

1. Select distinct utility from the main table AS OldUtility and Space(60)
As NewUtility Into Old-NewUtil.
2. Open a Datasheet-like form based on the Old-NewUtil table that has two
columns, 1. A list of all the distinct utility names 2. A list of blank
fields where the user enters the appropriate Utility Name.
3. When the user closes this form via the X button, have a MsgBox prompt
"Continue?"
4. If answer is No, End Procedure.
5. Use an Update Query to Update the Main table Utility old name to the
NewUtility value.
6. Select Distinct NewUtility from Old-NewUtil Into Utilities 'This is the
source for the ComboBox list

I believe I've got it all working except for number 2.

I was going to use a datasheet view of the Old-NewUtil table for the new
utility name entry.

That is until Rick Brandt was kind enough to inform me that Datasheets can
not be Modal. Well, doesn't that royally screw my plan?!

I need a way to simulate what a Datasheet does that can also be made Modal.

Urgent help needed.

Thanks in advance

Gary Z.

 

[Guest]

We have a case where Utility Names were hand-entered into a regular textbox
and therefore there is no consistancy in how a particular utility name was
entered. I have changed this TextBox to a ComboBox with a list of utilities
to select from.

What I want to do now is update the existing data by using a one-time
procedure that will:

1. Select distinct utility from the main table AS OldUtility and Space(60)
As NewUtility Into Old-NewUtil.
2. Open a Datasheet-like form based on the Old-NewUtil table that has two
columns, 1. A list of all the distinct utility names 2. A list of blank
fields where the user enters the appropriate Utility Name.
3. When the user closes this form via the X button, have a MsgBox prompt
"Continue?"
4. If answer is No, End Procedure.
5. Use an Update Query to Update the Main table Utility old name to the
NewUtility value.
6. Select Distinct NewUtility from Old-NewUtil Into Utilities 'This is the
source for the ComboBox list

I believe I've got it all working except for number 2.

I was going to use a datasheet view of the Old-NewUtil table for the new
utility name entry.

That is until Rick Brandt was kind enough to inform me that Datasheets can
not be Modal. Well, doesn't that royally screw my plan?!

I need a way to simulate what a Datasheet does that can also be made Modal.

Urgent help needed.

Thanks in advance

Gary Z.

Problem Solved!

Rick Brendt wrote in a diffetent topic:

A datasheet form cannot be modal. Why? I have no idea.

Dirk Goldgar wrote in a different topic:

Wow! I didn't know that. How strange! Thanks, Rick.

Solution:

Gary, it sounds like your best workaround would be to display the form
in Continuous Forms view, formatted if necessary to look like a
datasheet.