Opening a database and displaying no records

[Chris1977]

Hey folks,

Hopefully some of you will be able to help me with this.

I have a form called "ResourcePhone" where employees go to log calls they take. Each employee may log as many as 100 calls per day in this form and it is all written back to the resource phone table.

As it stands now when an employee logs into the MDW for the DB every record is displayed, making it painfully slow to open. I can set the on open event to go to a new record but all the others are still there regardless. I realize going to a new record will only open a blank sheet so how do i get it so that when the form is opened the record count is back at 0 however all the records are still located in the table for reporting purposes?

Thanks in advance

 

[Darrylles]

Hi,

Try this.....

On the form that calls the 'ResourcePhone' form - paint a button. A wizard will pop up asking for details.
When it asks if you want to:

Open the form and show all records
or
Open the form and find specific data.
choose this.

Finish the wizard.

I don't know how you call the form now, but copy the code out of the button you just created and use this.

Regards,

Darrylle
"Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[Chris1977]

Hey Darrylle,

Thanks for the quick reply.

I did what you advised and filtered by date entered. It did show the records as not being there however when i clicked the filter button on the toolbar to turn it off they all re-appeared. The thing with that is are they still loading in the background even though they are not being shown due to the filter?

Thanks

 

[PWise]

how about opening the form in add mode

 

[Chris1977]

Hey Pwise,

Pardon my ignorance but i've never heard of add mode. Could you give me a little explanation as to what it is and does?

thanks

 

[goodfela26]

Why not create a history table with identical fields as your current table and create a function which will move anything before a certain date over to the history table. You can then run this function whenever your table starts to get too large.
Also, Create a form identical to your current form which will show the info from the history table, but don't allow users to add new records via this new form. Only let them view. ---------------------------------------

In my limited experience, 80-90% of all problems brought to my attention can be attributed to PEBCAK...the other 10-20% can be attributed to MS!

 

[Rick39]

Might try setting the forms Data Entry property to Yes