I create my DB some time ago (2 months). At that time all works, but now I just try open it and entry some records, but when I open form I got this
''run-time error '-2146500594 (800f000e)' Method 'Form' of object '_SubForm' failed"
and this
"The expression on error you entered as the event...
I have form where proprty Data Entry = Yes. So, in theory only what can i do with this form is entry records (no record viewing from table, no edits, no delitions). But how about this?
Firstly, why Sort Ascending/Sort Descending is enabled?
Secondly, if I do Sort Ascending/Sort Descending then...
I have form with Tab Control with 3 pages. All works but in one page I have subtable on datasheet view. When page loads that not in top and cannot see Tab Control. Is any way to control Scroll Bars or load page on top?
I have Datasheet form with aim to only display records list. No additons, no edits, no delitions - thats done! But user still can change columns width, hide columns ... Is any way to dispose it?
On computer I create my Access DB warrnings are unset (but i dont know how). For example, in form I have code where DoCmd.RunSQL deletes some records and without any warnings (but I dont use DoCmd.SetWarnings False).
On other computer on my DB when I run DoCmd.RunSQL "Delete ...." warnings are...
I almost complete to build my DB and its time to give my DB to users to work with it, but I dont know how to do that users can only work with forms (user cant see tables, queries, macros, ... in any views, just forms in view)
Hello all!
I am novice in access and i have problem:
I have main form with many subforms and button "add record".
On button click records adds from main form and all subforms (if those are filled) but i want that records adds from main form and only one subform.
I try out different ways to...