Search results

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!

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 wan't to create button on form which displays PrintPreview. Can this be possible?

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

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

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

I got it Me.OrderBy = "Inventars DESC"

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?

Thanks for answer!

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

Thanks for answers!

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)

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.

Relationship Type: One To One

In main form I have Combo Box with values Printer, Monitor, Notebook, ... , Other. In start all subrorms are unvisible. If choose Monitor from Combo Box, then subform Monitors is visible. If choose Printer from Combo Box, then subform Printer is visible. ... All works if user fill only one...

In main form I have Combo Box with values Printer, Monitor, Notebook, ... , Other. In start all subrorms are unvisible. If choose Monitor from Combo Box, then subform Monitors is visible. If choose Printer from Combo Box, then subform Printer is visible. ... All works if user fill only one...

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