Search results

Your office 2007 is updated with the SP2 package?

Hi everyone The macro options are changed by the Windows registry HKEY_CURRENT_USER \ Software \ Microsoft \ Office \ 12.0 \ Access \ Security \ VBAWarnings Manually change the options of the macro is back to the Windows registry to see the value of VBAWarnings Now just use a script to...

In the event "to close" will not work because if the password is wrong the event does not have the cancel mechanism. Use the event "unload" Private Sub Form_Unload (Cancel As Integer) Dim pwd pwd = InputBox ( "Enter Password", "password") If pwd = "xyz" Then Else Cancel = True End If End Sub

Hi When you have a form open and maximized with the property pop-up active, the behavior of the ALT + F4 is closing the form. This is correct. has two alternatives: 1) Use the event to "unload" -create a variable in the form module: public booExit as Boolean - In the event "unload"...

Hi The VBA editor is a separate application. When you open the editor, all modules are open and overlapped. This is normal behavior. successs

Hi Nigel Load the ribbon in the cache does not make sense for the case. By chance he is requesting amendment of the controls at runtime? I think he has to walk a little more to start using the get (getLabel, getVisible, ..) I agree that we can use functions without problems but the vbaInet...

hi have to enable the reference: MICROSOFT 12.0 OBJECT LIBRARY (14.0 to Access 2010) If you read my articles and watch my videos, you'll learn fast. Success

hi mcclunyboy See this example http://www.access-programmers.co.uk/forums/showthread.php?t=190194

Hi I would like to make a invite: Visit my recent http://www.ribbon01.com site and watch my video-free classes on ribbons. In the second instructional video explains in detail about your question To learn more about custom ribbons, visit the article below and download the sample. Although...

Hi Buratti Download the sample 1) Run the file barlink.accdb 2) The tables are automatically linked, as the image below. 3) Now remove the back-end (barlink_be.accdb) to another folder. 4) Run the file barlink.accdb 5) It will open a screen informing the failure of communication with...

Very good Pyro I usually use the tag to other situations. Using the tag greatly reduces the programming for this case. And when you have to open a report, query, calculator or a site? How is the code to open different objects? believe that the solution may be in the proper use of the tag.

VbaInet sorry, had not seen your response.

I believe it is not possible. A configuration option to disable the navigation pane and changing the extension of the database to ACCDR.

Download the sample

sorry, forgot to mention that you have to activate the reference in VBA: Microsoft Office 12.0 Object Library

Hi three thing you need to understand: 1) The ID attribute identifies a control exclusively, correct? Will be used in VBA code to identify the control clicked. 2) OnAction attribute is used to trigger the procedure in VBA 3) copy the function to a global module. Public Sub...

The errors uncovered indicate the absence of SP2 SysCmd (715) is the command to know the version of Access by VBA 4017 Access 2007 (Beta-1) 4518 Access 2007 6211 Access 2007 SP1 6423 Access 2007 SP2

hi, install Service Pack 2 for Office 2007

Hi The office 2007 was upgraded to Service Pack 2 ?

Your answer may be on this page from microsoft http://msdn.microsoft.com/en-us/library/aa338202.aspx