General

[Varne]

Hi!

I am new to Access but I know something in VB for Excel.

I want to use Access for storing data only. Not for capturing (Forms) nor
for Querying (Reports). Once I used VB for Excel to get into VB for Word to
perform actions and returned. Is a similar thing possible in Access? Is there
a facility to record actions in Access like we have in Excel? I just could
not see the codes of an export Macro I created in Access 2007 on Vista!

Could someone provide some introduction to me.

Thanks.

 

[Allen Browne]

No. Access does not provide a way to generate VBA code by recording user
actions, in the way that Excel and Word do.

 

[Douglas J. Steele]

Sadly, there's no facility to record in Access.

To export, you can either create a macro that uses the TransferSpreadsheet
or TransferText actions, or you can use those methods in VBA. (Unlike Word
or Excel, macros in Access are not VBA)

 

[Varne]

Hi!

I am sure I saw some codes in the backyard after creating a transfer to
spreadsheet macro in Access windows 2003. Where are they in Access 2007? Has
MS withdrawn that facility?

Thanks.

 

[Allen Browne]

I am sure I saw some codes in the backyard after creating a transfer to
spreadsheet macro in Access windows 2003. Where are they in Access 2007?
Has MS withdrawn that facility?

Still there in A2007 macros.

Make sure you depress the Show All button on the ribbon (in macro design.)

 

[Varne]

Hi!

Depress!

One click it goes light. Another click it becomes bolder. Is that you refer
to?

Then I depressed it.

When we create a Macro in Excel VBA aotomatically inserts a module and
record codes in it. If we get into VBE we see them. But how to go to VBE -not
VB-in Access 2007? In Access 2003 I was able to reach it.

 

[Allen Browne]

Access 2007 supports embedded macros, and VBA code.
You asked about macros.

If you want VBA code instead, set the On Click property of your button (or
whatever event) to:
[Event Procedure]
Then click the Build button (...) beside the property.
Access opens the VBA window.

Some alternative approaches:

a) Alt+G opens the Immediate Window.

b) Drop down the arrow below the Macro button on the Other chunk of the
Create ribbon, and choose Module.

c) With a form open in design view, click the View Code button on the Tools
chunk of the Design ribbon.

d) If there are any stand-alone modules, right-click one in the NavPane.