Search results

How can I set up a multilingual report? I need to set this up in 4 languages. I need a table with translations, that's clear, but how do I best link the fields in the report with the translations?

I've build a small database, to store VBA code snippets, nice way to practice the combobox. Form the combo I can start the frmCodeBasAdd, with Private Sub cboAccesCodeBas_NotInList(NewData As String, Response As Integer) DoCmd.OpenForm "frmCodeBasAdd", acNormal, , , acFormAdd, acDialog...

Hi That's made a lot clear, meaning I can now get the requered data from the field. I've just to find out how to get the entered data in the combobox after requery without having to type that again. Further more I need to get the subForm requery after the update form the Contact person. This...

Hi, that might be true but I want to get the basics of it what to do where and why. So far with reading all posts and literature it still is not clear to me. I'm working on a large project, but this is applicable to many situations. I'll set up a small database for the looks of it.

Hi , Not quit clear, I run the not in list from B, not from A? After returning from X I need to requery B. I presume X runs acDialog to prevent other things happening? After getting back from form X, I try to requery B. This gives me an error 2218 save field value??

I've just been looking over several fora to find my basic bearings on the Not in List event and the way to make it work. To be homest I have an issue, and I can't find the solution. Just the basics: I have a form with two comboBox's, 1st for Company, 2nd for Client name. I want to filter the...

Happy New Year to you too!!

I's changed the wrong query. I had to change the query of the SubReport, not the Report

Hi, This worked perfectly!! thanks.

And that my friend were the magic words! I'd completly overlooked the ! Thanks very much

Hi, I'd put in <DMax([tblInvoice]![InvoiceID];[InvoiceID]) in the query criteria field for the InvoiceID, but that's generating an error the database can't find the table of -query 1 all up to -query8 Their are 8 fields in the query...

Hi, That's correct, I need all invoiced but the last as that one is set in the module calling the report!

Sorry, the elseif is not relevant for now, just in the future. Testing the principle now aren't we?

How do I upload the database??

Hi pitty, It's a pretty extensive database with a lot of tables. The requisation uses many of them. I've read the guidlines, but that would mean a lot of work.

No, Think it's correct, copiedit in and forgot to change the layout. Thanks

Hi, the filter did not work, I'd put this in the subReport, but this prohibited the report to populate the fields.

I'm trying to update a table with a for next loop. I've found I can read datga from the table, but can't write data to it. With rst1 .AddNew For x = 1 To Teller1 - 1 If x = DateNo Then !Fields(x).Value = Now() elsif Else...

Hi, I'm speechless......... Thanks very much for the work, it's well appreciated!!!

Hi, I knew that one, but that filter has to go on the Sub report, embedded in the report. How can I write the filter on that one? Kind regards,