07-09-2009, 10:59 PM #5 Max D Newly Registered User Join Date: Jul 2009 Posts: 91 Microsoft Access Runtime Error I found some other code examples which may work with 2007, but they all are much much more complex and the code I have does everything i need it to.

Developer Network Developer Network Developer Sign in MSDN subscriptions Get tools Downloads Visual Studio MSDN subscription access SDKs Trial software Free downloads Office resources SharePoint Server 2013 resources SQL Server 2014 see here You are correct in using square brackets, but the correct code should be: query = "SELECT [Unique ID] from tblPatients WHERE [Unique ID] =" & id Please note the removed underscores. There are three forms of the Resume statement. Galaxiom View Public Profile Find More Posts by Galaxiom 07-12-2009, 09:29 PM #13 Artimus Newly Registered User Join Date: Jul 2009 Posts: 8 Thanks: 0 Access 2007 Runtime Error 94 Invalid Use Of Null

Loading... Just fix (repair) the installation of Microsoft Office/Access. Now when you run your VBA code, the "Object required" error should no longer appear. this page because rs has been declared a recordset, it will never be Null.

The On Error statement directs execution in event of an error. Microsoft Access 2007 Runtime Error Artimus View Public Profile Find More Posts by Artimus 07-12-2009, 08:30 PM #10 Galaxiom Super Moderator Join Date: Jan 2009 Location: NSW Australia Posts: 10,238 Microsoft Access and Data Access Objects (DAO) provide additional language elements to assist you with those errors.

Show more Language: English Content location: United States Restricted Mode: Off History Help Loading...

the query designer can help you pinpoint syntax errors ... The Number property is the default property of the Err object; it returns the identifying number of the error that occurred. If your Help file includes topics for each form, you can also set the form Help Context ID property so that the Help file opens directly to the most relevant page.Setting Access 2007 Runtime Problems I try to set default selection so the label template will match the bottle size.

Access Runtime instance of a sample applicationSimulating the Access Runtime Environment from Full AccessAccess 2007 provides two methods that you can use if you want to see how your application looks If no error handler exists in Procedure B, or if it fails to correct for the error and regenerates it again, then execution passes to the error handler in Procedure A, Note: If the File version shows 12.0.4518.1014, you have Access 2007 Runtime and if the File version shows 12.0.6304.5000, Access 2007 SP1 Runtime installed on the system. Get More Info The combo is showing the available label templates.

This may include uninstalling runtime versions of Access.