Search results

  1. arnelgp

    Help make commands to adjust texts in forms and reports

    You might be interested on making the 2-Column contract in MS Word. then use Mailmerge to put the Info to the word docs. Or add Bookmark to word doc and fill it up from Ms Access.
  2. arnelgp

    Microsoft’s “Premier” Mix-Up: A Tale of Access and Amnesia

    expect volumes of refugees flocking in..
  3. arnelgp

    Solved IsNull not working in query

    How about (Query1): SELECT [Master Data].* FROM [Master Data] WHERE (NOT ([MATERIAL SUPPLY DATE] IS NULL)) AND ([TPA DATE] IS NULL) AND ([DD_RECEIPTNO] IS NULL);
  4. arnelgp

    Sum Query and text box

    i somewhat modified some codes.
  5. arnelgp

    Help make commands to adjust texts in forms and reports

    you can easily create the report in MS Acess with two textboxes. The English contract will be left justified while the text in Arabic, right-justtified.
  6. arnelgp

    Solved Read Outlook pst file without desktop Outlook installed

    there is also (i did not test it) an open source on Github: https://github.com/Dijji/XstReader
  7. arnelgp

    Sum Query and text box

    see your database and the formula on the 2 Unbound textbox.
  8. arnelgp

    Sum Query and text box

    if you want to show the 2 Sum values in your form, add 2 Unbound textbox. for the Total Payment, put this as Controlsource: =DSum("PaymentAmount","PaymentTable", "PaymentDate >=#" & Format$(Nz([txtFrom],1),"m/d/yyyy") & "# And PaymentDate <= #" & Format$(Nz([txtTo],2958465),"m/d/yyyy") & "#")...
  9. arnelgp

    Logos

    I did not add another field. I added another Image control and using VBA and set the ControlSource to: =GetLogo() see the GetLogo() function on the report's VBA code.
  10. arnelgp

    UtterAccess

    what happened then?:unsure:
  11. arnelgp

    Solved Sum of 3 columns sort by 3 diff. dates

    you can try this SQL (somebody might have a better sql) Replace "YourTableName" with the name of your table. SELECT TOP 1 fnFinancialYearStart(1) & " - " & Date() AS Period, (SELECT SUM(FarmerShareAmount) FROM YourTableName WHERE FarmerShareRcvdDate BETWEEN fnFinancialYearStart(1) AND DATE())...
  12. arnelgp

    Program1 works fine, program2 doesn't, due to a date problem, but code inside are the same

    Can't you just Format it without passing it to dataSQL() function: Me.Filte = "REGISTRATION_DATE >= #" & Format$(DateAdd("m", -1, Now), "mm/dd/yyyy") & "#"
  13. arnelgp

    Solved Sum of 3 columns sort by 3 diff. dates

    you can only Aggregate each amount fields from Starting fiscal year up to Ending fiscal year.
  14. arnelgp

    syntax error with null values

    IMO, you don't need to define the PARAMETERS. If you pass a wrong parameter type it will be ignored (Null value will be saved).
  15. arnelgp

    Solved Method of selecting specific records

    same demo as in post #18 also the db on post #6 of this thread, you can click on the Record-selector to select the record. https://www.access-programmers.co.uk/forums/threads/unbound-check-box-on-continuous-subform-for-selecting-records.309846/#post-1867836
  16. arnelgp

    syntax error with null values

    fnAnySQL uses Querydefs() so you can use the form's value directly and it will handle the Nulls. so there is no special need to convert them to string or delimited string.
  17. arnelgp

    syntax error with null values

    i created a UDF here called fnAnySQL() https://www.access-programmers.co.uk/forums/threads/fnanysql-parameter-query.297170/ if you use the function, you modify your SQL to: AID = Me.Parent.fAccountID '0 NID = Me.Parent.cboFullName.Value '1 CDt = Me.Parent.CkDate...
  18. arnelgp

    My loop sometimes starts at 2 or 3

    it is a minor issue, imo. actually the records are complete, you just need to Add sort Order to your form/subform. Sort it by RepNo ASC.
Back
Top Bottom