Run-time error '1004'

Mar 6th, 2002, 09:42 PM

when I run the code that displays my userform to insert, update and delete items from a database, i receive the following message:
Run-time error '1004'
(Application-defined or object-defined error).
I have checked my spelling of all ranges and cannot figure out where my problem is.
I would appreciate any assistance. The error is generated when the following subroutine is called:
.tbxNewDest.Value = Range("Database").Cells(iRowNumber, 1)
.tbxCutOff.Value = Range("Database").Cells(iRowNumber, 2)
.tbxNewAirline.Value = Range("Database").Cells(iRowNumber, 3)
.tbxNewFlttime.Value = Range("Database").Cells(iRowNumber, 4)

Thnaks, John

Mar 7th, 2002, 12:10 AM

Error 1004 is often caused by the protection of a sheet.
Could it be that you have Protection ON in your worksheet? If so, you could use Protection with UserInterfaceOnly and you won't have this problem.
Pietje

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 6th, 2002, 09:42 PM	#1
Guest Posts: n/a	when I run the code that displays my userform to insert, update and delete items from a database, i receive the following message: Run-time error '1004' (Application-defined or object-defined error). I have checked my spelling of all ranges and cannot figure out where my problem is. I would appreciate any assistance. The error is generated when the following subroutine is called: .tbxNewDest.Value = Range("Database").Cells(iRowNumber, 1) .tbxCutOff.Value = Range("Database").Cells(iRowNumber, 2) .tbxNewAirline.Value = Range("Database").Cells(iRowNumber, 3) .tbxNewFlttime.Value = Range("Database").Cells(iRowNumber, 4) Thnaks, John

Mar 7th, 2002, 12:10 AM	#2
Guest Posts: n/a	Error 1004 is often caused by the protection of a sheet. Could it be that you have Protection ON in your worksheet? If so, you could use Protection with UserInterfaceOnly and you won't have this problem. Pietje