Recent content by llkhoutx

  1. L

    FE/BE Installation

    Please recommend a solution or commerical software for installing a FE/BE Access program to a network drive for the BE and one or more local PCs for the FE. Of course, BE tables will have to be linked to the FE. Detailed instructions for same are quite tedius and requires a comprehensive...
  2. L


    Use the NZ function to conver Nulls to 0. if any.
  3. L

    Keep field in main form highlighted after focus is lost

    Change/reset the control background color as approporiate.
  4. L

    Office 2007 & 2010

    No there isn't.
  5. L

    Bound form not saving data to table

    Forms bound to queries can be problematic. Queries can be and are often non-updatable record sets.
  6. L

    Conditional page break question

    Instead of using "Me," use Reports!YourReportname!YourControlName.
  7. L

    Finding Records with increased values

    Queries can't compare values of adjacent rows. Cycle through the table or query, row by row, with DAO or ADO code, comparing the current row against the previous row.
  8. L

    Criteria Problem?

    The criteria must be concantenanted by a ", #, or nothing at all, depending on the datatype of the "cbo_cat." If cbo_cat is bound column of the combobox, i.e. column(0), Select the correct column, not just co_cat.
  9. L

    ODBC connection problems to SQL Server

    Take a look at:
  10. L

    Scrolling with Mouse Scroll Wheel

    Click on the form, not a control on the form to scroll.
  11. L

    Cannot work out how to extend the layout to a new section

    Subreports are quite common. If they are not properly linked to the main report, no data will be displayed.
  12. L

    Distribution of the amount

    I would never open a posted database unless I knew the posted. Anyone that opens it is taking a significant risk.
  13. L

    Help with an expression

    I think that any null value will kill your calculation. To debug the calculation, put each iif component is a separate column in your (select) query and check for valid results. Each iif might have to be enclosed in an IsError function.
  14. L

    Something Im Making to make it easier to copy different excel sheets to MS acces

    It's not clear whether this code is in Excel or Access or exactly want you want to do. I would use the Access command "TranmsferSpreadsheet" to import Excel data. It does all the work for you. This may or may not be trivial. It will be trivia if you know the data. If not, import to a temporary...
  15. L

    Export table data using FreeFile

    Add a datestamp field to each table so a to be able to determine when a table has been updated. You may also want another datestamp field of when existing rows are updated. Cycle through the tables container and query each table for rows which have been created, or updated, as the case may be...
Top Bottom