Search results

  1. A

    Return all records if IIF statement is False

    Following modifications. The field text105 was necessary to return query 4,4,5 & 6.
  2. A

    Return all records if IIF statement is False

    What are the expected results for the query, for the following values ​​text103? 1? 4? null? 10? Looking forward
  3. A

    Return all records if IIF statement is False

    Hi try HAVING (((tbl_P2E_Priorities.Priority=[Forms]![frmTRinput]![Text103]) OR ([Forms]![frmTRinput]![Text103] is null)) AND (tbl_P2E_Priorities.[Resource Name]="frank clarke")) Or HAVING (((tbl_P2E_Priorities.Priority=[Forms]![frmTRinput]![Text103]) OR ((tbl_P2E_Priorities.Priority)...
  4. A

    Calculate remaining balance on continious subform

    Hi Better you create the calculated field in the query, source subform .. Balance: 50 - DLookup("[Balance]";"qryMembPayBalance";"[mpClientID]=" & [mpClientID])
  5. A

    How to handle Dlookup returning no value

    Hi try Me.txtTotalPaid = Nz(DLookup("Total", "qryMembSumPayments", "mpClientID=" & me!mpClientID), 0) If mpClientID originates in the main form, use the parent. Me.txtTotalPaid = Nz(DLookup("Total", "qryMembSumPayments", "mpClientID=" & parent!mpClientID), 0)
  6. A

    Dlookup fails in Calculated field

    Hi Try this: Test: IIf(IsNull([NatSubsBranch]),"",IIf([NatSubsBranch]=1,"Standing Order",IIf([NatSubsBranch]=_ [BranchID],"",DLookUp("Branch_Name","tblBranch","BranchID=" & [NatSubsBranch]))))
  7. A

    Video Tutorials

    Hi 5 Videos - How to create custom Ribbons http://www.ribbons-access.com/articles.asp ...
  8. A

    Send multiple attachments using outlook

    Hi SendEmails(strTo, strSubject, strMessage, nz(Me.txtAttach1,""),nz(Me.txtAttach2,""),nz(Me.txtAttach3,"")) Success!
  9. A

    Send multiple attachments using outlook

    Hi Ronaldo See if the changes will assist you. Public Function SendEmails(strTo As String, _ strSubject As String, _ strMessage As String, _ Optional strAttachment1 As String, _ Optional strAttachment2 As...
  10. A

    How to subtract times in a query when they cross over 24 hours

    Hi Try the function below: Public Function fncInterval (StartTime As Date, EndTime As Date) As Date fncInterval = CDate (IIf (EndTime <StartTime, EndTime + 1, EndTime)-StartTime) end Function Take a test, in the immediate window of VBA: ? fncInterval(#11:50:00PM#,#1:15:00AM#) 01:25:00
  11. A

    delay in FormCurrent() event - Access 2007

    Hi Your Office 2007 is updated with the package Sp3? Use the breakpoint in the code to know if the event is running. Analyze the value of Me.[Part Number].Value Open the VBA> Debug menu, click Compile. If you find any errors, fix. You are using the application with the extension ACCDE...
  12. A

    Question Hide/show Ribbon Tabs/Areas

    Hi Macro does not work with procedure (sub). Only with function. Change to: Public Function ExportToExcel() On Error Resume Next If Len(Reports(0).Name & "") > 0 Then If Err Then Err.Clear Else DoCmd.RunCommand acCmdExportExcel End If End If End Function
  13. A

    Question Hide/show Ribbon Tabs/Areas

    Hi Jalex Use the macro Autokeys, to trigger the F5 key {f5} | [CurrentProject].[AllReports](Reports (0).[Name]).[IsLoaded] | RunCommand: ExportExcel You may need to add the treatment of error, if you have not loaded a report.
  14. A

    Question Hide/show Ribbon Tabs/Areas

    Hi An alternative would be to use the F5 shortcut key to invoke the export form. Use the keyDown event : example: Private Sub Report_KeyDown (KeyCode As Integer, Shift As Integer) If KeyCode = 116 Then DoCmd.RunCommand acCmdExportExcel end Sub
  15. A

    Table already exists, and maketable query will not overwrite

    Hi Use the command to delete the table before running the query. On Error Resume Next 'Delete table DoCmd.DeleteObject acTable, nameTable If Err Then Err.Clear: On Error GoTo if_erro 'Shoot the action query to create the table Application.CurrentDb.Execute strSQL sair: Exit Function...
  16. A

    Password Protect a Back-End Database

    Hi Access 2010 has a bug in relinking tables. In its FE: 1) Delete all linkages and after use the Compact and Repair 2) Re-link the tables again and use the Compact and Repair. If not resolve, create a new BD. Export all objects except the linked tables. Bind the tables in the new database...
  17. A

    Subform Foot Sum Resulting in #Error

    The Sum() function only works with fields that originate in the table or query. The SIZE field of your form does not originate in the table.
  18. A

    Subform Foot Sum Resulting in #Error

    Hi The problem in this field SIZE, which is also calculated. The output will create the SIZE field in the query, which is the origin of the form. Follows the modified example.
  19. A

    How to apply customized ribbons on a form in Access 2010

    Hi Want to learn and quick to customize your ribbons? This site has an application made ​​in Access. The most important are the videos, you will receive with the application. Excellent! The videos are available on the site. http://www.ribbons-access.com In this article, has a function...
  20. A

    Non SendKeys way to minimize A2007 Ribbon?

    Hi For the 2007 version does not have a direct command to minimize the ribbon. In Access 2010 the command already exists. See Question 10 http://www.ribbon01.com/tutoriais/faq.asp
Back
Top Bottom