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