10-30-2007, 12:14 AM #3 sachin.modak Registered User Join Date: Oct 2007 Posts: 3 Thanks: 0 Thanked 0 Times in 0 Runtime Error 91 Access Vba Join Date Aug 2007 Location India Posts 2,158 Re: Run-time error 91 Object variable or With block variable not set is this line ok? Access 2007 Runtime Error 3349 Dev centers Windows Office Visual Studio Microsoft Azure More...

Reply With Quote Jul 2nd, 2012,04:11 AM #6 seenu_1st View Profile View Forum Posts Just a Member! see here Alejandro Chavez Castillo 3,081 views 2:41 Using a Range Variable in Excel VBA - Duration: 6:39. StrSQL = "SELECT tblIngredients.lngIngredientID FROM tblIngredients WHERE tblIngredients.IngredientName = '" & cboIngredientName & "'" 'IngredientName is a text field. ' The next line is flagged as a problem. Get 1:1 Help Now Advertise Here Enjoyed your answer? Access 2007 Runtime Error 6 Overflow

Connect with top rated Experts 14 Experts available now in Live! Public Function GetNextNumber() As Variant Dim strSQL As String Dim rs As Recordset GetNextNumber= Null // creating sql to execute MYSP stored procedures with 2 parameteres strSQL = "EXEC MySP '" I'm predicting something is wrong with my SQL statament on the previous line. this page The object is a valid object, but it wasn't set because the object library in which it is described hasn't been selected in the References dialog box.

or am i off with that? Runtime Error 91 Object Variable Or With Block Variable It may be something stupid but I've been staring at this error trying to fix it for over an hour. What is a plural of "To-Do"? "To-Dos" or "To-Does"?

EverydayVBA 60 views 4:39 Excel VBA Introduction Part 9 - Object Variables - Duration: 21:16.

Sign in Transcript Statistics 10,893 views 8 Like this video? However, I don't see where you actually instantiated this object; i.e. Featured Post 6 Surprising Benefits of Threat Intelligence Promoted by Recorded Future All sorts of threat intelligence is available on the web. Runtime Error 91 Object Variable Or With Block Variable Not Set Excel We appreciate your feedback.

Jun 29 '06 #3 P: n/a Richard Hollenbeck "Richard Hollenbeck" wrote in message news:[email protected] "John Mishefske" wrote in message news:hY******************@tornado.rdc-kc.rr.com... Register Help Remember Me? Richard Hollenbeck wrote: I've marked the line in this subroutine where I've been getting this error. Get More Info The example then queries the table of authors and instructs the user to send a bonus check to each author based on his or her royalty share (the total bonus is

Working... But the related forms are open and pointed at valid records.