Recent content by Krayna

  1. K

    Integrate Word mail merge in MS Access

    This sounds like an interesting approach. Would you have a sample app where it is integrated in?
  2. K

    Integrate Word mail merge in MS Access

    Thanks @moke123 but that is a little too advanced for my needs. My key problem at the moment is how to successfully link the data to the word document from DB whilst open. Every option I try throws all kinds of errors. I tried OLEDB and DDE but it will not work. I have read through all...
  3. K

    Integrate Word mail merge in MS Access

    Hi there, Further to my post above, I have been able to start coding based on some snippets I have found but my code keeps throwing errors particularly 4198. I have enclosed a sample. Bear in mind that my DB is split with BE being another Access DB (hence the connection string). I've never...
  4. K

    Integrate Word mail merge in MS Access

    Hi I'm looking to integrate a mail merge facility into an MS Access DB. I know there are solutions to this out there but couldn't quite find what I'm after. I would like as little user input as possible. So the user can select a letter template they wish to merge with a particular data source...
  5. K

    Solved Split form not filtering to 0 with drop-down filters

    So it seems to work when I convert all values between 0.01 and -0.01 to 0 so all the tiny values are filtered out.
  6. K

    Solved Split form not filtering to 0 with drop-down filters

    This is the SQL SELECT tblTenancy.TYNAME, tblTenancy.TYADD1, tblTenancy.TYADD2, tblTenancy.TYADD3, tblTenancy.TYADD4, tblComments.*, tblInvoice.ItemDate, tblInvoice.ItemDesc, [ItemAmount]+[ItemAmVAT] AS cfInvTotal, [OutStand]+[OutStVAT] AS cfOutStand, [received]+[recvat] AS cfReceived...
  7. K

    Solved Conditional Formatting Expression Data Format Error

    Wow that sorted it! Thanks
  8. K

    Solved Split form not filtering to 0 with drop-down filters

    Difficult as it is sql server
  9. K

    Solved Split form not filtering to 0 with drop-down filters

    I am having trouble with a split form. When filtering one field to 0 it will not display all the records. It will work when I use a number filter 'equals 0' though. I have checked if there are any underlying filters on the form and also if it works to do in the underlying query but not managed...
  10. K

    Solved Conditional Formatting Expression Data Format Error

    Tried but getting invalid syntax. Expression is: [TotalDue]<0.01
  11. K

    Solved Conditional Formatting Expression Data Format Error

    Hi I have just encountered an issue that have not found previously. When designing conditional formatting rules for date fields it would change the expression to date format even though I input as regular integer. I tried a couple of times and this was result. See attached screenshot.
  12. K

    Solved View not displaying all data correctly

    Your a legend! Thanks
  13. K

    Solved View not displaying all data correctly

    I will attach some screenshots to demonstrate. Here is the view open in SSMS correctly: This is view in MS Access - some data displaying repeatedly:
  14. K

    Solved View not displaying all data correctly

    I have a view which is showing all data perfectly in SSMS but not in MS Access. I have tried refreshing link and deleting and re-linking but no success. Anything else I can try?
  15. K

    Solved Write conflict error

    Found the issue here: https://stackoverflow.com/questions/13993301/editing-record-issues-in-access-sql-write-conflict It required a timestamp column!
Top Bottom