Need Help ASAP

daniel · Post by **daniel** » Tue Jul 19, 2005 9:30 pm

Hello,

I'm trying to do a Dialog box that can be used for data entry. This form should have about 9 columns and over 75 rows, but I want the dialog box to show 10 rows at time and when those are filled, there would be a button that would create basically another dialog box for rows 11-20 and so on.

Then when all data is entered, I want the macro to sort these rows from oldest to newest date. After the sorting has been done, I need for the macro to send the first 75 rows and columns to another screen, which would require evey field to have it's own name. The records over 75, I need for the macro to write a text file or perhaps create an access table where they will be stored for future use.

In this dialog, I need for the macro to search for records 76-150 and send them to another screen at a later time.

Is this possible to do? Thanks for you help.

-daniel

Bob Hansen · Post by **Bob Hansen** » Wed Jul 20, 2005 1:43 am

This was already posted at http://www.mjtnet.com/forum/viewtopic.php?t=2078.

Suggest that you cancel this posting and continue at the above link.