General information
Category:
Coding, syntax & commands
Environment versions
Network:
Windows 2008 Server
>>>Kenneth,
>>>
>>>Don't use the root of c drive for your temp folder. Use a directory.
>>
>>changed to C:\TEMP
>>
>>Same problem.
>>
>>I found somewhere I was resetting the RecordSource to the cursor. I took this out and the references to the columns.
>>
>>So now I have this:
>>
>>Form Load Method: Creates blank cursor called CaseSQL
>>GRID Record Source is set to CaseSQL originally.
>>GRID columns are set with the appropiate fields from CaseSQL
>>
>>Now, run system on one machine and comes up fine.
>>Start on second machine and Grid comes up completely white.
>>
>>The recordsource is still there (CaseSQL) but the grid is completely blank.
>>
>>I am confounded. It must be me because I have done this many times before but I am besides myself at to why this now.
>
>Can you post code which is re-selecting records?
>
>Also you may want to grab all form's code using Class Browser View Code feature and look where you reference the grid. May be there is some strange code hidden somewhere.
>
>Finally, when you select records to your temp cursor, are you using NOFILTER clause? It may be important.
Taking another line of thinking here. It has something to do with the column ControlSources. I am starting from scratch and building the grid up one column at a time. First column works ok so it looks like the creating of the RecordSource (CaseSQL) is working fine and not the cause of the Grid error.
Will keep you posted. Thanks for all your ideas.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only