Search results

Hi; Try DoCmd.OpenForm "frmCustRecord", acNormal, "qryFindRecord", , acFormReadOnly, , acNormal

Sorry, resolved with the DSUM function in form. Thanks for replay

Unfortunately in Novell have tests to do. Novell is more than out of date the Windows Server system is so good, that makes no sense to seek alternatives Novell or Lotus may be that someone has to run Novell environment, which can help it. Sorry

Thank you for replay.

Hi All; How to make a query that returns different criteria. My table “tblRelease” Fields: Account - text data OpeningBalance- Currency Type - Combo box – Value list = credit / debit Status - Combo box – Value list = Pg / Pg no I would get the momentary balance, ie credits and debits paid...

try a new module; Option Compare Database Option Explicit 'declare NetWare APIs Private Declare Function WNetAddConnection Lib "mpr.dll" Alias "WNetAddConnectionA" _ (ByVal lpszNetPath As String, _ ByVal lpszPassword As String, _ ByVal lpszLocalName...

Or: Property in form Tab Data Set Data Entry = No

See; http://support.microsoft.com/kb/128195/en-us

Hi Sammy, see in attch please;

Try; Public Sub UpdateForms() On Error Resume Next Dim obj As AccessObject, dbs As Object Set dbs = Application.CurrentProject 'Search for open AccessObject objects in AllForms collection. For Each obj In dbs.AllForms DoCmd.OpenForm obj.Name, acDesign If Forms(obj.Name).AllowDesignChanges =...

thank you for replay.

Use: Private Sub YoucomboBox_AfterUpdate() Me.Requery End Sub Or: Private Sub YoucomboBox_AfterUpdate() Forms!YouForm!YouSubform.Form.Requery End Sub

Thanks for responding, you can serve others with the same doubts.

Sorry did not see who was the form, but it will be difficult.

Hi; Do not use conditional formatting to it, use: Private Sub Form_Current() If IsNull(Me.YouTextbox) Or Me.YouTextbox = "" Then Me.YouTextbox.BackColor = RGB(255, 0, 0) Else Me.YouTextbox.BackColor = RGB(255, 255, 255) End If If Me.NewRecord Then Me.YouTextbox.BackColor = RGB(255, 255, 255)...

Hi; Use Conditional Formatting in txtNotes you Enabled or no. See attch

try; If Me.password.Value = DLookup("Password", "login", "[username]='" & Me.username.Value & "'") And _ Me.username.Value = DLookup("username", "login", "[username]='" & Me.username.Value & "'") Then

try; SELECT YouTable.Field1, YouTable.Field2 FROM YouTable WHERE (((Format([FieldDate],"yyyy"))=[Forms]![YouForm]![ComboboxName])) GROUP BY YouTable.Field1, YouTable.Field2; Please note that the word Year' and a reserved word in Access.

try; Me!FieldName1 = "" Me!FieldName2 = ""

Simple my invention. See the att