Recent content by paulscherm

Did you link the subform to the main form?;)

I am assuming your sub form is embedded in the parent form and not a pop-up window. If so, I always include a control on my underlying table called "LinkID". Then I create a macro so when I click on a certain control on a certain record, it fills the LinkID with the ID control you are using for...

Set the control as a hyperlink. Use the table design.:o

HIDE RIBBON AND NAVIGATION PANE Access 2010+ - Hide Ribbon and Navigation Pane Function HideShowRibbon() SendKeys "^{F1}", True Docmd.ShowToolBar "Ribbon",acToolBarNo DoCmd.NavigateTo "acNavigationCategoryObjectType" DoCmd.RunCommand acCmdWindowHide End Function SECURITY...

I found this awhile back. Hope it will help. It does fine on a couple applications I developed... :banghead: MINIMIZE RIBBON IN ACCESS USING VBA CODE: Public Function MinimizeRibbon(Optional MakeMin = True) ' This function minimizes or maximizes the ribbon, depending upon the value ' of...

Distributing file as a .mde file and want to be sure users can't access certain toolbars. Thanks again.;)

Thanks, I believe this will work. What I wanted to do was "uncheck" the "AllowFullMenus" checkbox when the file opens. I think I can change the property in the mdb to that and it should work - right? :cool:

Did that, and it directs me to "CreateProperty" which I don't know how to do in vba. :(

I would like to set the properties (options) in the Startup Form on the Tools menu in vba such as (allowfullmenus - true or false). I have Access 2003. Can anyone get me started? :banghead:

Thanks, that works...:cool:

I have a database designed in Access 2003. I plan to distribute it to others with Access 2010 or 2007. Want to run code to hide navigation pane and ribbon (have that already). What I need is vba code that can determine what version when database is opened so I can run the hide ribbon and nav...

I use queries using the control name as the criteria. Then I open the report using the query name as the filter.

Looking for VBA code to automatically shutdown my access database after it's been idle for certain period of time. Thanks, Paul:banghead:

I have a subform linked to a dashboard and would like to filter records based on a control within the subform and without using a shortcut menu. The subform (continuous) contains a list of contacts and the control I want to filter is the contact type. Need vb code for this. Thanks and Happy...

Thanks for the reply. You said you needed to "refresh" the calendar to the Now() date. Am I suppose to create a text box and link it to the calendar?