Search results

Fantastic, works perfect. Very, very thanks

See; http://www.straxx.com/excel/password.html

Hi all; How to zip mdb via vba ?

Hi, thanks for response. Resolved: Range(rCell.Offset(0, 5), rCell).Select

Hi all; I open Book2, I enter the user name and password and must make the copy and paste the whole line and not only found the cell. See attc please

In DTPicker ActiveX control does not work with data = null this is initial doubt man

Hello do not use the Microsoft Date and Time Picker Control 6.0 (SP6), see this example in attc:

Ok; Any idea for this validation?

Thanks for reponse; But I wanted to validate the end of the completed form, a button. Private Sub cmdValidation_Click() Call valNullControl(Me) End Sub

Hi all; How to validation null fields in continuous forms, with this code by tag ??? Public Function valNullControl(frm As Form) Dim ctl As Control Dim minhaArray As String Dim validacaoOk As Byte validacaoOk = 0 For Each ctl In frm.Controls If ctl.Tag <> Null Or ctl.Tag <> "" Then...

See is solves.

I not had remembered this option, thanks

Block access for data entry, but without blocking the query to the data in the backend. I could block the entry forms but many users.

Hi all; How to blocking input data on the front end .md for all users ?

Hi all; Bluetooth integration with Microsoft Access, it is possible ?

Thanks for responding, it works brilliantly.

Hi all; it is possible to close Excel if idle for 10 minutes ? Excel 2003

See also this example that will help

Sorry test please: Dim xlog As Variant If xlog = DLookup("[Password]", "login", "[Password]='" & Me.Password & "' And [username]='" & Me.UserName & "'") Then

Hi: Try; form1 DoCmd.OpenForm "Vendor Details", acNormal, , , , , Nz(Me.ID,0) form2 Private Sub Form_Open(Cancel As Integer) If IsNull(Me.OpenArgs) Or Me.OpenArgs = 0 Then Exit Sub Else Me.Filter = "ID=" & OpenArgs Me.FilterOn = True End If End Sub