Crummy Access 10 macro interface

[Callahan]

Is there any way to change the Access 10 interface for macros to that of Office 03?

[boblarson]

No, there is no way to go backwards sorry. It may take a bit to get used to, but believe it or not (I know, you don't believe it) but the newer macro writer is actually much more powerful and user-friendly than the old style. It has intellisense and it has error handling and will actually help make the transition to VBA a fairly easy one. It also allows you to nest actions and perform loops which was almost impossible to do in the older interface.

So, anyway, sorry that I can't give you news that you would obviously like to hear but I hope it won't take you too long before you get used to the new interface.

[Callahan]

Thanks for the information Bob.

Guess I better learn to like it.

[boblarson]

Thanks for the information Bob.

Guess I better learn to like it.

I'm liking it to the extent that I might even go with some macros myself if, and when, we make the move to Office 2010 (not likely going to be soon though as our company seems to move very, very slowly - we're still on DOS 6.22 and OS/2 - oh, okay just kidding ).

[Callahan]

Hello again boblarson,

Do you know of any free documentation for the 2010 stuff?

I have a visual basic function that is trying to use

DoCmd.OutputTo acForm, My.[ReportName], "MicrosoftExcelBiff8(*.xls)", xlsname, False, "", 0

to create a spreadsheet that will be attached to an email.

Used to work in Access 03, sends an empty spreadsheet in Access 10.

I'm suspecting the MicrosoftExcelBiff8 thing may not be available in Access 10, but have no way of finding out (the crummy macro interface).

Thanks a million in advance.

Callahan

[boblarson]

There's not any overall documentation except for the help files (it works best if you uncheck the Use Online help and just use the internal help).

Change the "MicrosoftExcelBiff8(*.xls)", code to

acFormatXLSX

(without quotes) instead.

[Callahan]

Thanks for the replies boblarson, I appreciate it. I tried the acFormatXLSX , but have the same result, so now I'll be looking elsewhere in the function process.

Can't find any place that will let me turn off on-line help.

Thanks again.

[boblarson]

Can't find any place that will let me turn off on-line help.

It's kind of in an out of the way place and I can't tell you right now because I don't have it with me at work.