Search results for query: *

Great that fixed it thank you very mucho!!!

Hi Andrzejek, ExitHere: Set cmd = Nothing Set prm = Nothing cnn.Close <--------- E R R O R THIS LINE IS THE ON THAT CAUSES TO GO TO ERRORHANDLER. 88888888888 Set cnn = Nothing Exit Sub ErrorHandler: ' Grab Access/VBA Error lngError = Err.Number strError =...

Placed the code as suggested but sill get the run-time error.

Would the follwoing code be the correct to set it? Set cnn = New ADODB.Connection

Using Access 2010 have the following code on a Control Box's NotInList Event. When the user selects NO from the popup asking to add new item the following error apprears: "Run-Time error '91' Object variable or With Block varialble not set" It points to this line in the code: If...

Good afternoon, In Excell have Sheet1 with 10,000 rows in 4 columns. Need to transpose (in rows of 8) rows 2 to 9 of column A to rows then rows 2 to 9 of column B and so on for columns C and D in Sheet2. Then rows 10 to 17 of column A in row 2 of of Sheet2 and soon on for all records in...

Using Windows XP, MS-Excel 2003 SP1 I hava a report where the user selects a country from a validation list and it shows results for that country. It also show five or less questions for the country selected which the user has to anwser in specific cell. Is it possible to create a macro that...