Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Sanasta
  • Content: Threads
  • Order by date
  1. Sanasta

    Retrieve value based on multiple criteria

    I have 2 tables: "Letter_to_Insurer" and "Policy_OP" and query based on the "Letter_to_Insurer". I need to have one field in this query, which to find the policy number of concrete truck in the concrete time interval. I tried DLookup (in query and in the form...
  2. Sanasta

    How to export MS Access report as .pdf file

    I am working with MS Access 2003 and would like to export my report as Acrobat .pdf file. I have tried different ways but without any success. I think whether with MS Access 2007 this is possible or not.
  3. Sanasta

    Date in the current record not to be less than date in previous record

    Hi, I have form based on table. There is a field Inv_Date which value must be greater than or equal to the previous record value (not less). How to prevent entering (or in case of copy-paste) earlier date for the next invoice? May be this is easy but I can't do it. Shall appreciate any help...
  4. Sanasta

    Database Window disapear

    My Database window disappear and do not appear even when I push button Database Window on the toolbar? I don't know what's happen. Please help with advice! Sanasta
  5. Sanasta

    Start data to be equal to End data of previous record?

    Hi, I have a problem. I would like data in a field KmEnd to be equal to KmStart in a previous record for the Same RegNo. (RegNo is not a primary key). I have no idea how to do this. Kindly please help me. Sanasta
  6. Sanasta

    Distribute cell content among several cells

    I have a long string in a cell and I want to distribute its content among several cells but not with left, mid or similar functions. For example I want to distribute charaters before word "from" in one cell and charaters after word "from" in other cell, etc. but I don't know how to solve this...
  7. Sanasta

    Subreport's sums problems

    I have a report with 5 subreports. Each subreport's footer contains sum of spesific expenses. In main report I have summed these sums. In case any subrepost is missing (e.g. we have not DKV expenses), my total (final) sum is error. I have tried with NZ, IsError, Is Null, IsEmpty functions, but...
  8. Sanasta

    Total sum from subreports

    I have a report with 5 subreports. Each subreport has in its footer sum of spesific expenses. In main report I have summed these sums. In case any subrepost is missing, my final sum is error. I have tried with NZ, IsError, Is Null, IsEmpty functions, but result is the same. Kindly please help...

Part and Inventory Search

Back
Top