Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 28-08-2009
Member
 
Join Date: Jul 2009
Posts: 74
Runtime Error 91 : Object Variable or with block variable not set

Hi,

I get error message in excel VBA, and then my user data input. And then click on send, I get the following error!

Run-time error 91: Object variable or With block variable not set

What does this error and How can I still send my favorites ?

I have already removed the tool and once downloaded and installed again, but it continues to give the same message!
Reply With Quote
  #2  
Old 28-08-2009
Member
 
Join Date: May 2008
Posts: 353
Re: Runtime Error 91 : Object Variable or with block variable not set

To remove the error message "Run-time error 91: Object variable or With block variable not set" try the following:

(1) try to change If objItems (i). userProperties ( "exported") = 0
If cf.Items (i). UserProperties ( "exported")

(2) If this fails, make sure the 'exported' properties exist. From the sounds of it, which is a deprecated attribute, so you'll have to find an equivalent, perhaps viewing the properties of cf.items
Reply With Quote
  #3  
Old 28-08-2009
Member
 
Join Date: May 2008
Posts: 244
Re: Runtime Error 91 : Object Variable or with block variable not set

Make sure the Recordset object is not based on the form's recordset if you plan to use the Delete or UpdateBatch methods. For an example, see the following code:

Code:
Sub Test()

   Dim rs As New ADODB.Recordset
   rs.Open "SELECT * FROM TableX", CurrentProject.Connection, _
     adOpenKeyset, adLockOptimistic
   rs.Delete
   rs.UpdateBatch

End Sub
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Runtime Error 91 : Object Variable or with block variable not set"
Thread Thread Starter Forum Replies Last Post
Scope of Object or variable in Object oriented Programming Languages Dėfrim Software Development 3 08-01-2011 06:20 AM
How to setup a JavaScript Object Notation variable? hatred Software Development 4 04-02-2010 02:25 AM
How to change a variable that is saved in an object structure in JavaScript? DANIEL 602 Software Development 5 25-01-2010 04:59 PM
What is Global Variable static? Declaring static variable instead of Global variable Reckon Software Development 3 25-04-2009 11:34 AM
Undefined variable error in Php Capers Software Development 3 31-03-2009 05:14 PM


All times are GMT +5.5. The time now is 12:42 AM.