Thanks S7, i thought that it was the SQL Server Native Client too and thats when i realised the server name differences.
But thanks for all your help and you too TheSmileyCoder, cannot believe the level of help I have received from you two.
AvaisShuaib
Last Activity: Jan 25 '12, 02:07 PM
Joined: Dec 2 '11
Location:
-
AvaisShuaib replied to 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin AccessHI All, actually my above comment is wrong,
as i have mentioned, the tables are linked to an SQL Server database.
What i did not mention is that the access 2003 ran on windows xp and the access 2010 runs on win 7. and the win7 is on a different network and atm there are some dns problems, as such some of the tables were updated to include the new dns server name of the sql server but some were not. and the ones that...Leave a comment:
-
AvaisShuaib replied to 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin AccessI have managed to fix one of my problem tables by changing the type to nvarchar(255) from varchar(25). I guess i have to now check all the others and hope this is the case for all of them.
Thanks for your help.
PS. if you know of any other dodgy database types, it would be most welcome as i have quite a few of these tables and not all of them have varchars in themLeave a comment:
-
AvaisShuaib replied to 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin AccessThere are other tables where NAME is not present and they do not appear, although what i have noticed is:
I have 3 radio buttons, and when you click on a aprticular button, a different list of tables are shown in a lsit box, you then select these tables and a tab and click on another button which will execute the code above. Now all of the talbes in 2 of that radio set work fine, the tables in 1 of the radio buttons do not work except...Leave a comment:
-
AvaisShuaib replied to 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin AccessMy backend is an SQL Server 2000.
I have tried setting the source first like below:
The above results in the good tables giving the same error when setting the recordsource so on the first line.Code:'Reload Subform Query objSubform.Form.RecordSource = "SELECT * FROM " & mstrTableName objSubform.SourceObject = mstrTableName & " subform"
...Leave a comment:
-
AvaisShuaib replied to 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin Access@TheSmileyCoder ,
When i do not set the recordosurce, the only change that occurs now is that the same error is thrown but now when trying to requery the form on line 28.
And no, different subforms dispaly different tables.
And no, subforms do not have any linked subforms of their own.
Also, for the DoEvents, to i merely put 'DoEvents' between the two? as this is what i have done and nothing...Leave a comment:
-
AvaisShuaib replied to 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin AccessHi S7,
I changed the ref. To activex 2.8 library but I still get the same error. thanks for the effort thoughLeave a comment:
-
AvaisShuaib started a topic 2003->2010: Setting recordsource of some subforms leads to 'object is closed' errorin Access2003->2010: Setting recordsource of some subforms leads to 'object is closed' error
Hi,
I have a form which has a list of different table names and another list of tabs. When you select a table name and a tab and then click on a button, the following code is executed:
...Code:Dim objSubform As Object Select Case strTabName Case "Tab 1" Set objSubform = Me.tabTableData.Pages(0).Controls(0) intPageIndex = 0 Case
No activity results to display
Leave a comment: