Search results

  1. T

    Conditional Formatting

    Tkanks for replay. It is not so simply as I thought. The configuration of windows and office looks the same. In form I have two fields both has the same condition but it one this condition is preceded by other one (let's call it Condition One) When condition One is true the first file is not...
  2. T

    Conditional Formatting

    Hi; I use conditional formating in may form and on one computer (just one) i have a strange behavior. it ignore the first condition. Even if it is 1=1. Thanks in advance
  3. T

    Warning message disable

    I have the references to which the user has no permition I would like to handle this error by myself but befor any code stat runing I get the warning message "Your ..... database or project contains missing or broken reference to the file ....." Is there any way to switch it off Regards; TomBra
  4. T

    Remove duplicates made up from different columns

    I don't know if this is what you expected but try SELECT Min(Tabela2.System_ID1) AS MinimumOfSystem_ID1, Max(Tabela2.System_ID2) AS MaksimumOfSystem_ID2 FROM Tabela2 GROUP BY IIf([System_ID1]>[System_ID2],[System_ID1],[System_ID2]) & IIf([System_ID1]>[System_ID2],[System_ID2],[System_ID1]);
  5. T

    If-Then Loop... Simplified?

    I don't know if I undestand you precisely but maybe sth like that MySqlString="" SqlWhere="Where " SqlAnd=" And " If checkbox1=true then MySqlString = SQLWhere & "Condition1" end if If checkbox2=true then if MySqlString="" then MySqlString = SQLWhere else...
  6. T

    Microsoft Office Document Imaging Viewer Control

    Hi; After instaling Security Update KB973507 the mdivwctl.dll control stop working. the message says that the control is outdated. After uninstal update everything is ok. Thanks for help.
  7. T

    Update table from results of a query

    xx = nz(dsum("[A Outlets]","CityMarket","CityMarket.BranchId)=" & [Forms]![RegBranch]![RegBranch1].[Form].[BranchId]"),0) Sorry there is one extra bracket
  8. T

    Update table from results of a query

    try change this way working without query
  9. T

    VBA to slowly scroll through table to allow visual user inspection

    Hi I don't know if I understood you properly by try: Use timer event and timeinterval property to scroll through the table. Instead of using Msg box put two buttons on form "Table is Ok", "table is not ok" and raise propper event TomBra
  10. T

    AcrobatAccessLib

    Hi; Does anyone have some links to references to Acrobat Access 2.0 object librery. I try to google it but with no results. Thx Tomek
  11. T

    MODI Viewer Control

    it's common MS ActiveX control Microsoft Office Document Imaging Viewer Control
  12. T

    MODI Viewer Control

    So far when there is the request for display particular file I copy it using Scripting.FileSystemObject and then delete after finishing. Otherwise I get Access denied error. Ok it's working but I have to do many unnesesery code checking when the file is not longer nessesery, do anybody else...
  13. T

    MODI Viewer Control

    Thanks a lot. I look through. But for me its only for jpeg files and i have thousends of tif for display.
  14. T

    MODI Viewer Control

    Hello; I have an path to tif file and i would like to display it on the form by Modi Viewer control. Everything looks fine up to moment when this file try to open user with Reradonly permision to it. now I make a copy with full access display it and on close event i delete it, but i,am looking...
Back
Top Bottom