Search results

  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...
  16. L

    Notes Form

    Use an appropriate event to open the desired form with a subroutine. A button on the subform is probably appropriate because merely selecting a note is probably not what you want.
  17. L

    Question remove owner name in title

    I think that this is controlled by Microsoft Access and the "ownership" of Access software being executed, not the front end.
  18. L

    update backend split table

    Open the backend database and import the Excel sheet (menu External Data>Excel). Verify the name of the table and datatype of the the new table's columns. If the new table does not have a primaryt key, add one. In the fronend, import the new table (menu External Data>Access). If you have...
  19. L

    Access Printing options

    A receipt is merely a report in Access. Your "receipt printer" is selected usin the orint option and the report is the correct paper size.
  20. L

    Form option group - single click selects 3 options

    You option group is not correctly bouind to your form.
Top Bottom