Slettet bruger
04. september 2007 - 10:53
Der 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.
Koden der virker ser således ud:
DoCmd.OutputTo acReport, "" & ReportNavn & "", "" & ReportFormat & "", "" & ReportSti & ReportNavn & "" & FilExtension & "" & "", False, "", 0
Problemet ligger i at jeg i stedet for acReport også gerne vil bruge acQuery, men når jeg ændrer koden til at imødekomme dette går det galt:
DoCmd.OutputTo ReportType, "" & ReportNavn & "", "" & ReportFormat & "", "" & ReportSti & ReportNavn & "" & FilExtension & "" & "", False, "", 0
Den kan sagtens genkende ReportType, men når man holder musen over det ser det sådan ud: "acReport" og dette giver en Type mismatch i VB.
Er der en vej udenom dette? Håber i forstår hvad jeg mener.
På forhånd Tak
04. september 2007 - 12:13
#1
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
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?
04. september 2007 - 13:04
#3
thanks
When you are entering code you can see the values in a list but this is just the constants (acQuery ....)
You can then find the actual value in the Object Browser (if you cant get it to work in debug window).
Slettet bruger
04. september 2007 - 13:18
#4
Doh, of course Terry, I'm so clueless sometimes :-)
Thanks a mil
