Richard, you are great to watch on RUclips to learn some of the Access principles! You e taught me a huge amount!! Thanks, and keep 'em coming!! "There is a way out of every box, a solution to every puzzle; it's just a matter of finding it." (ST)
Thank you for your wisdom sir! Ran into someone complaining about a "non-updateable" issue on one query but not another-- now I have something to look for on someone else's database XD
Great info. I'm trying to find how to resolve error 3021 when synchronizing .RecordsetClone.Bookmark = .Bookmark Do you have any videos that address this? Thanks!
I haven't covered that error specifically, but it's usually caused by an empty recordset, or you've moved beyond the bounds of an existing recordset (before the first record or after the last one). I'll be covering this in an upcoming Developer lesson.
@@599CD No errors creating (.Recordset.AddNew) & saving the record, just when I execute .RecordsetClone.Bookmark = .Bookmark I'm looking forward to the developer lesson & will be watching.
Hi, I have this problem on all fields in my database. Was working fine last week but today I cannot add or edit any information on my database. I get the error This Recordset is not updateable". I checked and the database does have Primary Keys. Any ideas please? Thanks in advance.
Thank you I have a query If I have a report and a group operator in the name of the company, and I want to make a different arrangement for the names of these companies So how is it possible since the available arrangement is alphabetical and I want it to be custom arrangement
Hi, i have a problem. I making a simple form and the result will showed on query transaction. But, after i fill the form, the query doesn't showed all my field. Any solution? If u need my video about my problem, i can send through ur email, lemme know your email!🙏
Richard, you are great to watch on RUclips to learn some of the Access principles! You e taught me a huge amount!! Thanks, and keep 'em coming!! "There is a way out of every box, a solution to every puzzle; it's just a matter of finding it." (ST)
Thank you for the kind words. Glad you enjoy!
Thank you for your wisdom sir!
Ran into someone complaining about a "non-updateable" issue on one query but not another-- now I have something to look for on someone else's database XD
Glad to help
Great info. I'm trying to find how to resolve error 3021 when synchronizing .RecordsetClone.Bookmark = .Bookmark
Do you have any videos that address this? Thanks!
I haven't covered that error specifically, but it's usually caused by an empty recordset, or you've moved beyond the bounds of an existing recordset (before the first record or after the last one). I'll be covering this in an upcoming Developer lesson.
@@599CD No errors creating (.Recordset.AddNew) & saving the record, just when I execute .RecordsetClone.Bookmark = .Bookmark
I'm looking forward to the developer lesson & will be watching.
Hi Richard B. Why my text box does not shows calcs automatically, until I chose and open the form... tahnks
No idea. Not enough info.
Hi, I have this problem on all fields in my database. Was working fine last week but today I cannot add or edit any information on my database. I get the error This Recordset is not updateable". I checked and the database does have Primary Keys. Any ideas please? Thanks in advance.
599cd.com/NotUpdateable
599cd.com/Trouble
i can't go to design view so that i can fix the primary key, it's disabled
599cd.com/QQ
very important topic. Such a simple thing can mess things up; hard to find by any novice like me.
Yep
Thank you
I have a query
If I have a report and a group operator in the name of the company, and I want to make a different arrangement for the names of these companies
So how is it possible since the available arrangement is alphabetical and I want it to be custom arrangement
Add a custom sort field. 599cd.com/CustomSortOrder
Hi great video! But what do I do if it is not allowing me to even access design view so that I can input the primary key?
Sounds like you've got a bigger problem with your database. 599cd.com/Trouble
Thank you!
Welcome
Hi, i have a problem. I making a simple form and the result will showed on query transaction. But, after i fill the form, the query doesn't showed all my field. Any solution? If u need my video about my problem, i can send through ur email, lemme know your email!🙏
I'd need to see it to help you, but I don't accept files via email. Post in my Forum: 599cd.com/AF