Trying to add VBA code to Access Database

[farmerscott]

Hi Everyone,

I have just upgraded to Access as part of Office 365 (Windows 10 Pro).

Am trying to write a small piece of VBA code to update a calculated field (before I move to the next record).

1. I keep getting the following error- "Microsoft Visual Basic for Applications- File not found". Upon clicking the help button it takes me to File not found (Error 53).

2. Also where does the code go? In a module?

What am i missing?

thx.

 

[farmerscott]

Thanks Adam.

I think I am making progress based on your above suggestions.

Just as small side bar to what I am trying to achieve........ can I get a calculation to happen via a macro or data macro (before I move off a record)? Can I do it another way and not use VBA?

thx

Farmerscott

 

[ajetrumpet]

can I get a calculation to happen via a macro or data macro (before I move off a record)? Can I do it another way and not use VBA

YES. a lot of people put functions in the property of textboxes called *control source*. if you do something like that, you'll see the calculations happen automatically, in real time. an example of a function in this property would be:

=dcount("myfield", "mytable", "myNewField = 5")

 

[farmerscott]

Hi Adam,

your suggestion to import all the tables, queries and forms into another database, worked.

I tried to delete the (phantom) form but it never gave me the option in the VBA editor. Never had this happen before.

Getting VBA back has been fantastic. Macros I could not really get my head around. It seemed to have very little functionality that I needed.

Appreciate your help.

thx

FarmerScott