Hello everyone,
I have a userform for data entry, many user complained about error message "Runtime error1004 application defined or object defined erroe"
I have attached screenshots for the error
The database is attached
userform : maintenance
password: maintuser
debug.png
debug1.png
TBRow has no value? IRow seems to be your last row... but TBRow is likely 0 when the code runs?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Arkadi
its not defined in this code, but the error doesnt appear each time
This code supposed to edit an existing record
same code was for adding new record but TBRow is replace with IRow
Sorry of looking dumb am new to vba i found this codes online, but what i mean the error happens occasionaly not all the time
Also another error
Attachment 632998
Attachment 632999
Last edited by Mahmoudelnemr; 07-18-2019 at 09:17 AM.
Looks very similar to your query in attached link.
If the solution offered worked then, apply the same logic to your present dilemma.
torachan.
[QUOTEhttps://www.excelforum.com/excel-programming-vba-macros/1279899-updating-record-using-userform-thanks-torachan.html#post5140190][/QUOTE]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks