Recent content by llkhoutx

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

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

Change/reset the control background color as approporiate.

No there isn't.

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

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

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.

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.

Take a look at:

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

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

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

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.

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

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