>>>I am new to VFP and am attempting to write a timekeeping program. The requirement is to have all entered records for the pay period on the screen at once (so I use a grid on a form) and to be able to input data directly into the cells(right word?) or to be able to press a trigger of some sort (I used double click) to display only valid values from a reference table (free table) or a table from another database for each cell(?) I can get this to work for the first 5 cells(?), but when I add the double click method to the 6th cell and run the form, I get the message "Too many files open". To confuse me futher, when I click on help, which is supposed to (as I understand it) give me help re: my error message. I get a completely different error. This error says something about I am trying to pass something invalid between methods. Is there a better way to achieve what I am trying to do or Iam I on the path I want to follow and need a little help to get past this roadblock. If I
>>need
>>>a little help, can you point me in the right direction?
>>
>>
>>How are you opening your files? When you are testing and get this error, have you tried suspending the program and looking at the View Window to see exactly how many files ARE open? Keeping in mind that for every .DBF that is open you are using a file handle for it, its .CDX (if existing) and one for the memo file (.FPT), if existing.
>>
>>What are the file handles set to in the config.sys? for the network? what Windows is it running on?
>
>Barbara, I'm a newcomer too, but maybe this will help. If you want the user to be able to select from a set of values, you might put a combo box in the grid. Clicking on the column will display the combo box--easy for the user and easy for you (nothing to write to handle displaying the choices).
>
>Also, if the set of options for each field is not too long and doesn't change, you don't need to keep that table open all the time. You could read all the values into combo box by using an AddItem loop in the INIT method, then close the table and free up the file handles.
>
>VFP5 allows more files to be open than VFP 3...
I will try the combo box for the files that don't change often, but would the combo box work for a file that is constantly being updated? One of the files I have open is the database to put the timekeeping records in, one of the files I open is changed about once a year, the third file I open is changed weekly and the fourth file I open is the one being constantly updated. and thats all the files I open so far. Also, fyi, I am running VFP5.