Improve company productivity with a Business Account.Sign Up

x
?
Solved

converted Macro to Code, get error

Posted on 2013-12-07
2
Medium Priority
?
618 Views
Last Modified: 2013-12-07
Experts,

I have a form with an Onclick event.
The event is in the form of a macro.
It works fine.  

I converted the macro to code and now get an error on the OnClick event of that same form.  
"TempVars can only Store data.  They can not store objects"
(actually I converted the macro in another db then copied and pasted from that db to the current db as didnt want to convert all macros to code in current db...if that matters)
I didnt do anything else except convert macro to code.

posted pic.

Let me know what you think as to why I get the error.

error,After Converted to code
0
Comment
Question by:pdvsa
2 Comments
 

Author Comment

by:pdvsa
ID: 39703727
here is the macro before converted (collapsed all)

Macro, before converted
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 39703730
this
tempvars.add "CurrentID",ID


should be

tempvars.add "CurrentID", me.ID.value
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question