04. september 2007 - 10:53Der er
4 kommentarer og 1 løsning
Problem med DoCmd.OutputTo
Hej alle
Jeg har lavet et stykke kode som udfra en tabel eksporterer en del forskellige rapporter ud i .snp format. Det har indtil nu virket ganske fint, men efter jeg er begyndt at blande formater sammen (altså rapporter både i .xls og .snp, virker det ikke længere.
Not quite sure what you mean but if ReportType is a variable which is currently a string so that ypu can either use acReport or acQuery then you want to change ot to an integer.
acReport and acQuery are constants (not strings) which have a pre-defined value.
In debug window (CTRL+G) write the following follwoed by return
acQuery?
acQuery has the pre-defined value of 1 and acReport has the pre-defined value of 3
So you need to yuse these values
Synes godt om
Slettet bruger
04. september 2007 - 12:49#2
Terry that's just want I needed, thanks.
I couldn't however get the Immediate window to work properly, gives me a Compile error. Is there any way to see the values of the different object type choices?
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.
