Search results

I have some records in a report with the sum of one field in the foottext. I like to place some comments below, if there is enough space available. If not, a new page should be performed. My question is: is it possible to use an conditional page break in case there is not enough space availabe...

Hi Leif Owner protected databases are new fo me. Tell me where I find more about this subject? Kind regards Jan

1) You need still the TableExist function, see below. 2) And if the both databases are in the same directory, you can replace LFileName = FileNameSecondDatabase LFileName = CurrentDbDir & FileNameSecondDatabase 3) if both databases has the same password you can use the function GetPassword...

Dear Leif, If your are logged in the first database, you can copy a table in the second, protected, database using the subroutine below. Kind regards Jan Lichtenbelt ------------------- Sub CopyTableInExternalDatabase(FileNameSecondDatabase, TableNameIn, TableNameOut, Password) ' March 8...

Hi Guus, That is what I did: 1)docmd.Transferdatabase acImport ..... (copy table from db2 -> db1) 2)rename the table (all in db1) 3)docmd.Transferdatabase acExport ..... (copy table from db1 -> db2) 4) delete temporary table (in db1)...

I have two access databases, both password protected. Now I want in database1 copy a table in database2, using VBA. Up to now I found an indirect solution which imports and exports a table. This imports the table from database2 to database1, renames the table and exports the renamed table from...

Dear David, Thanks for your reply. I tried your demo a second time. What I see, is what I like. But it is completely unclear/not possible to find out who you managed this. And I like to learn something, not just seeing a demo. Or did I mis by some reasons the solution? Jan Lichtenbelt

Dear Paul, thanks for the programming inpromevents. Dear Missinglinq, that makes for me clear why the whole columns getting coloured instead of special cells. Dear David, the demo looks nice, but I can not make more out of it than it is a commercial to contact your company. This kind of...

I have a form showing a table with 11 fields en 10 records. I want backcolors for special records in special fields. I have in pricipal more than 3 conditions (not all conditions are shown here), thus I want to write the conditions myself. The first field name is: "Counter" with values 1 to 10...