Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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.
  5. 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...
  6. K

    Solved Conditional Formatting Expression Data Format Error

    Wow that sorted it! Thanks
  7. K

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

    Difficult as it is sql server
  8. 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...
  9. K

    Solved Conditional Formatting Expression Data Format Error

    Tried but getting invalid syntax. Expression is: [TotalDue]<0.01
  10. 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.
  11. K

    Solved View not displaying all data correctly

    Your a legend! Thanks
  12. 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:
  13. 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?
  14. 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!
  15. K

    Solved Write conflict error

    Hi before we address issue of form, can we work out why the table itself is not allowing edits in MS Access but works find in SSMS. It happens every time - even if I don't open any forms. It does allow adding records though. I have attached some screenshots Really puzzling as I've never come...
  16. K

    Solved Write conflict error

    I am having trouble updating any data in one table in MS Access which is linked to SQL server. This happens on form, view or basic table. It works fine to update on SQL Server direct. I have tried closing all open forms/tables and SSMS but still getting this error message. Don't know what else...
  17. K

    Solved Stats increasing rapidly

    @arnelgp is it possible to speed up the numbers - stats I'm talking about are at least 100k...
  18. K

    Solved Stats increasing rapidly

    Thanks @arnelgp This is what they are after! Lets see how quickly they lose interest...
  19. K

    Solved Stats increasing rapidly

    I know how to calculate it! I am just looking if it is possible to show the user the numbers increasing very rapidly until the current figure when they log in to the home screen?
  20. K

    Solved Stats increasing rapidly

    To clarify the counts are actually of how many clients the business has and how many jobs done. This is simple data which will increase with each job entered on the DB. I am after the method that increments the numbers from 1 to the current figure very quickly. Obviously this will be on the...
Top Bottom