Recent content by Kayleigh

  1. Kayleigh

    Not printing unbound boxes in subform footer

    The recordsource is currently a query - but its a crosstab so its all dynamically assigned on load. I will try the totals option though. Maybe I can dynamically assign the query total to those textboxes.
  2. Kayleigh

    Avast blocking auto-update macro

    I would like to try that. But I'm not sure how to?
  3. Kayleigh

    Not printing unbound boxes in subform footer

    Hi I am attempting to print a form which contains several subforms. The data in the subform header and detail sections displays fine. However the figures in the unbound textboxes located in the footer are not displaying - only blank boxes are visible. My print code is (although as a side...
  4. Kayleigh

    Error re SQL server statement Foreign key conflict

    Thanks for your suggestions @Pat Hartman The tables are in SQL Server so how would I check it is Null not 0 in SSMS ? Note - these are tables we have been using for many years without an issue!
  5. Kayleigh

    Avast blocking auto-update macro

    Just checking back in to see if anyone has any ideas on how to resolve the Avast blocking issue. Any insights or suggestions would be much appreciated. Thanks!
  6. Kayleigh

    Error re SQL server statement Foreign key conflict

    Hi there, I am managing a MS Access DB coupled with SQL Server backend. Occasionally users report that records go missing and I it may have to do with the following error although I am not clear on what it means and what to do about it. If anyone can enlighten me I would appreciate!
  7. Kayleigh

    Avast blocking auto-update macro

    I'm encountering an issue with Avast antivirus blocking a macro that's intended to automatically update Microsoft Access to the master version. Despite adjusting settings, I haven't been successful in resolving this problem. Below is the code to run: Option Compare Database ' global variable...
  8. Kayleigh

    Solved Fill in 0 in crosstab query

    My solution was: £#,##0.00;(£#,##0.00);\0;"£0.00" FYI this was very useful in explaining https://documentation.help/MS-Access-Visual-Basic/acproFormatNumber.htm
  9. Kayleigh

    Solved Fill in 0 in crosstab query

    How could I do the same for a currency field?
  10. Kayleigh

    Solved Fill in 0 in crosstab query

    That's so cool:)
  11. Kayleigh

    Solved Fill in 0 in crosstab query

    This is the CT query: TRANSFORM Sum(qryDailyLeadsShort.CountOffldOrderID) AS SumOfCountOffldOrderID SELECT lkptblDays.fldDay AS [Day], Format([cfdate],"dd-mmm") AS [Date] FROM (lkptblSupplyFit INNER JOIN qryDailyLeadsShort ON lkptblSupplyFit.fldSupplyFitID = qryDailyLeadsShort.fldOSupplyFitID)...
  12. Kayleigh

    Solved Fill in 0 in crosstab query

    I don't have table of all dates - dates shown are generated from date sale is created. Yes I do have table of sales types - SupplyFit
  13. Kayleigh

    Solved Fill in 0 in crosstab query

    Hi I have the following crosstab query which summarises the sale figures for each day. However I would like to have 0s in place of blanks. When I try Nz() or IIF(null()) it doesn't work - probably because there are no rows to summarise for those days. Any ideas how I can do this?
  14. Kayleigh

    Hide extra data in continuous form rows

    Yes - so each day appears once only.
  15. Kayleigh

    Hide extra data in continuous form rows

    I'm also thinking there can be a logic to get this working. For example if I number each row and hide any numbered above 1. I'm sure it would be possible somehow.
Top Bottom