Search results

Hi, You can use a MDB file in the task scheduler. Download the sample file to test. Open the module mod_backup and change the password in the following line: objws.SendKeys "a1234", True 'password WARNING: Make a backup before testing your database Good study!

Hi Show your code the batch file. What version of Access used? Depending on the version you can enable the compact and repair the "Access Options". Just then open and close the file. As this data is always good to include in routine security backup before you run compact and repair. Through...

Hi In 2007 and 2010 versions just use the field of type attachment. The image is stored in the table and displayed directly in the report. The field report should be linked to the source field. To extract images from attachment field, search on "SaveToFile". See article below to help...

I also use this tool MontaRibbons. The videos offered are worth gold to anyone who really wants to learn. Today I am able to mount ribbons without any tools. The guy was very attentive to me when I needed to take my doubts.

See a tool designed entirely in Access. http://www.ribbons-access.com The site has great videos that explain very well. Well, I learned a lot from the videos presented. You can download and test the application for some time. The most interesting is that the tool is not held hostage. You'll...

Hi To hide the standard tabs use the default attribute startFromScratch="true". Example of clean ribbon for Access 2007: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <commands> <command idMso="ApplicationOptionsDialog" enabled = "false"/> <command idMso="FileExit"...

Hi Artemis Use the ribbons to gain a lot in quality. And the program is very easy. Here are some pictures in this thread: It's in Portuguese but you can be to have a good idea of the designer. http://comunidade.itlab.com.br/eve/forums/a/tpc/f/273606921/m/4457082633 Two site to learn you all...

Hi If you do not work for the startup form, try the macro AutoExec

Hello SmallTime See the VBA help on the method COMAddIn application.COMAddIns.item("NameAddin").Connect = false It also has how to disable the "Access Options" in "Trust Center Settings ..." Another option is to disable all add-ins for the Windows registry. The key is: disableAllAddins...

Hi Jota You can use the command: DoCmd.ShowToolbar "ribbon", acToolbarNo If you want to learn customizing ribbons, you can watch videos on this site: ribbon01.com/articles.asp or accessribbon.de/en

Hi DropDown: Sub OnActionDropDown(control As IRibbonControl, selectedId As String, selectedIndex As Integer) Select Case control.ID Case "ddc1" DoCmd.OpenForm "frmdatabasewindow" [Forms]![frmdatabasewindow]![frmDatabaseWindowSub].[Form].Filter = "[group2]='" & strText & "'"...

This line uses the schema version 2010, which is incompatible with the 2007 version <customUI ...microsoft.com/office/2009/07/customui" onLoad="OnRibbonLoad" loadImage="LoadImages"> use the scheme of the 2007 version that caters for you to use with Access 2010 <customUI...

Adding a bit more secure.

SmallTime, See the example

See also this example.

Hi Smalltime If you can not progress to the project, will mount a practical example. I like the site below, which has a cool videos ribbon01.com/articles.asp

Hi Note how you can disable the content of the backstage area. ... <!-- *** TAG COMMANDS ***--> <commands> <command idMso="Help" enabled = "false"/> </commands> <ribbon startFromScratch="true"> ... .... </ribbon> <!-- *** BACKSTAGE ***--> <backstage> <button idMso="FileSave"...

VbaInet, follows the file in 2007, to help our friend. Why did not serve my example? What's different from what you want? You added the attribute getVisible the buttons on the ribbon? example: <button id="TS71" label="Test1" onAction="RibbonEnabled" getVisible="fncGetVisible"/> This using...

Hi To change the ribbon at runtime should make use of attributes getVisible, getEnabled, getLabel, .... The following changes