Recent content by Osix

  1. O

    Question run-time error '-2146500594 (800f000e)'

    1) Version 11, I use Full Microsoft Access 2)Yes dll file, but with it all is alright. Interesting that my DB work on other computer!
  2. O

    Question run-time error '-2146500594 (800f000e)'

    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...
  3. O

    Print Preview Button on Form

    I wan't to create button on form which displays PrintPreview. Can this be possible?
  4. O

    Form with data entry only

    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...
  5. O

    Scroll Bars

    Yes, subform on the tab but problem is not there. All works, I just want that page loads on top of screen.
  6. O

    Scroll Bars

    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?
  7. O

    Lock datasheet form

    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
  8. O

    Lock datasheet form

    I got it Me.OrderBy = "Inventars DESC"
  9. O

    Lock datasheet form

    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...
  10. O

    Lock datasheet form

    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?
  11. O

    Question Unset Warnings

    Thanks for answer!
  12. O

    Question Unset Warnings

    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...
  13. O

    When close form record saves

    Thanks for answers!
  14. O

    Access DB for end users

    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)
  15. O

    When close form record saves

    If a have filled form and I want just close form record saves in table, why? How can to dispose it? I just want that form closes and record removes.
Back
Top Bottom