If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Form Source StoredProcedureName not found ... "
Hi.
I have a disconnected Access 2002 project (.adp) that runs under Windows XP Pro. Every 2 seconds, the project connects to a SQL 2000 database and invokes a stored procedure in the database to look for new data. If data is found, the project invokes other stored procedure to fetch the data. The project places the data in recordsets. The project displays some of the data in a subform. The Record Source for the subform is set to the recordset returned by one of the stored procedures using VBA code. Once the data is obtained and displayed in the project (including the subform), the connection is closed. Eventually, the user uses the displayed data and clears it for the form and subform. If there is no data to display at this point, my VBA code sets the subform's Visible field to False. Sometimes a couple of minutes after happens, Access pops up a dialog box that says: "Form Source StoredProcedureName not found ... " Here StoredProcedureName is the name of the stored procedure I invoke to set the Record Source of the subform. In my VBA code, I make no direct association between the subform's Record Source field and the strored procedure. I use the recordset returned by the strored procedure to set the Record Source of the subform. At any rate, the subform is not even visable when this happens. Does anyone have any Ideas as to what the problem might be? Thanks for the bandwidth. - Doug |
Thread Tools | |
Display Modes | |
|
|