Search results

Can anyone help?

This cod does not work to open .accdr Sub OpenDB() Dim MinhaPassword As Variant MinhaPassword = "xpto" strDbName = "c:\SeuBanco.accdr" Set objaccess = New Access.Application Set db = objaccess.DBEngine.OpenDatabase(strDbName, False, False, ";PWD=" & MinhaPassword) objaccess.OpenCurrentDatabase...

Hi all; vba code, accdb how to open another database .accdr with password ?

Thanks to all the opinions. For Access 2000, Microsoft released a list, I just want to know if there was also for 2007. http://support.microsoft.com/kb/208283

Hi Boyd; I need a list of all ActiveX controls related with Access 2007.

Thanks for the help Bob, I do not know that was word reserved Local.

Because I was using in code Dim local As String and gave error. But I found ... local object A table, query, form, report, macro or module that remains in the replica when it is created. Neither the object nor the changes to the object are distributed to other members in the replica set...

Hi all; Where can I find a lists of ActiveX controls for Access 2007

Hi all; Why is the word "Local" is reserved for Ms Access ?

Thanks you all; Resolved: In module; Public Const columnConselho = 7 'By JPaulo Janeiro 2010 Public Function getColNumber(ByVal strCell As String) As String Dim charC As Integer charC = InStrRev(strCell, "C") getColNumber = Mid$(strCell, charC + 1) End Function Public Function...

Thanks for replay. There is nothing special, see the structure. Please, delete the report and module that do not belong to this example, sorry.

Hi all; I have BookGeral and 4 more books, BookA, BookB, BookC and BookD If I digit in BookGeral cell A1 = "A" automatic insert data in livroA If I digit in BookGeral cell A1 = "B", automatic insert data in livroBAll books are in the same folder C: \ Test Help me please

See in attc;

See in attc;

Sorry Brian and calm; I thought that the data came from individual fields, was I wrong to read.

Or; MyDate: CDate(Mid([YouField];2;2) & "/" & Mid([YouField];4;2) & "/" & Right([YouField];2))

Hi friend; See sample in attc;

Two equal posts http://www.access-programmers.co.uk/forums/showthread.php?t=185977 I think that is resolved

Hi Mr.Access See this example in the form menu;

Hi all; New BackEnd is on the network folder. How to update 8 frontend`s ?