DoMenuItem

[KUZZ]

I am trying to use menu item Export... from File menu on a form bar.

docmd.domenuitem acFormbar, acFile, ? ,,acMenuVer70

does any one know what should be in place of the questio mark? Please REGARDS, KUZZ

LIFE IS GREAT WHEN THERE IS SOMEONE TO HELP YOU.
DESIGNING DATABASES SINCE 2002

 

[MazeWorX]

expression.DoMenuItem(MenuBar, MenuName, Command, Subcommand, Version)

Command Required Variant. You can use one of the following intrinsic constants.

Intrinsic constants:
acNew
acSaveForm
acSaveFormAs
acSaveRecord
acUndo
acCut
acCopy
acPaste
acDelete
acSelectRecord
acSelectAllRecords
acObject
acRefresh

For other commands, use the number of the command in the command argument list, as shown in the Macro window in previous versions of Microsoft Access (count down the list, starting from 0).

The following example uses the DoMenuItem method to carry out the Paste command on the Edit menu in Form view in a Microsoft Access 95 database:

DoCmd.DoMenuItem acFormBar, acEditMenu, acPaste, , acMenuVer70

The next example carries out the Tile command on the Window menu in Form view in a Microsoft Access version 2.0 database:

DoCmd.DoMenuItem acFormBar, 4, 0, , acMenuVer20


try the access help file for more info

 

[KUZZ]

Try to fillin the blanc with the count down of the File list starting from 0, and you will be surprized what you will see under # 6


REGARDS, KUZZ

LIFE IS GREAT WHEN THERE IS SOMEONE TO HELP YOU.
DESIGNING DATABASES SINCE 2002

 

[SBendBuckeye]

Kuzz,

Can you post a little more information about what you are trying to do? Are you trying to export a form, report, table, etc to another database? The information you gave is a little bit sketchy.

Good Luck!

 

[KUZZ]

I want to export a continuous form displaying some calculated fields to a table within the same database.

The reason I want to do this is that i want to be able to sort the results which that form is showing, but i can't because they are calculated (formula) fields using for calculations totals from the footer of the form

REGARDS, KUZZ

LIFE IS GREAT WHEN THERE IS SOMEONE TO HELP YOU.
DESIGNING DATABASES SINCE 2002

 

[SBendBuckeye]

I'm wondering if maybe you could do this with a query which contained your calculations. Can you post a little more information showing examples of footers being calculated, etc?

Perhaps the footer portion could be calculated with one query and then linked into another one to get the output you desire.

Good Luck!