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?
Intresting, but boblarsons code sometimes work and sometimes not!?!
With CodeContextObject
Screen.ActiveControl.ColumnHidden = False
End With
I try to hide column more than one time and sometimes column hides.
Obscurity
Thanks!
This:
Forms![frmYourFormName]![YourFieldName].ColumnWidth = 100
and this:
With CodeContextObject
Screen.ActiveControl.ColumnHidden = False
End With
works. But I cant realize simly thing. I want that form On Load event sort one column to descending. How?
I tried but not work...
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)