convert macro into module nd it will not run

A

Aleux

I converted the following code from a macro, when I click
the run icon on the tool bar it ask for the macro name
and will not run. What do I have to do to get a converted
macro to run???

'---------------------------------------------------------
---
' macImportText
'
'---------------------------------------------------------
---
Function macImportText()

DoCmd.TransferText
acImportDelim, "specCAL", "CAL", "d:\KL
Tracking\CAL.txt", False, ""

End Function

Private Sub form_load()

DoCmd.OpenTable "CAL", acViewNormal, acEdit
DoCmd.FindRecord "COUNTRY ACTIVITY LOG", acEntire,
False, , False, acCurrent, True
DoCmd.FindRecord "AOCDX", acEntire, False, , False,
acCurrent, True

End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro saved as vba not working 0
combobox and textbox synchronization 1
Multiple queries, reports - pause between 10
Macro Pause to Select range then Subtotal 0
it works, it doesn work, its works....and so on. 6
Delete a record using macros. 1
suppress macro messages 1
OnTime Change_Event macro AND copy to sheet2 macro trouble 7

Top