Importing formulas from excel to ms access

[wannabepro]

Since, I wasn't sure in what catagory this post will fall into, I am posting it here. Hopefully, you guys will u/s my query. What I am trying to is I have one financial statment that I have created in excel. However, I am not a pro in excel, and even creating a template is not serving my purpose. I need to create form (like ms access), so the users can create records and it will be save in tables, and they would be able to print out the reports based on diff catagory. But the only problem is, I am unable to generate excel formulas in ms access and I can't create forms in excel. I know I can't even import them either. So, what should be the solution to it.

e.g. PMT is payment formula in excel, but what can be the subsitute of that in ms access?

I hope I did make sense, and since you guys are pro, you might be able to help me out.

 

[Uncle Gizmo]

I can't create forms in excel.

I understand it is possible to create "user forms" in excel. I would suggest you have a look at this option first.

 

[Uncle Gizmo]

I am unable to generate excel formulas in ms access

Your other option would be to link MS Access to excel so that you can use the XL formulas in access.

 

[Mile-O]

PMT is payment formula in excel, but what can be the subsitute of that in ms access?

You obviously haven't bothered to find out. Amazingly, it's PMT.

 

[wannabepro]

You obviously haven't bothered to find out. Amazingly, it's PMT.

huh! I did try to look for it, but couldn't find it. Anyways thanx for ur reply.

Uncle gizmo, I did try creating user form, but I kind of got lost in prog part, I guess I need to find a book on it so I could follow it step by step, I am working on it after 9 yrs, thats why i really rusty on it. But, I really appreciate your help.

 

[The_Doc_Man]

There is an assumption being made by some answerers but it might not be valid for wannabepro.

Before you go bonkers wondering where they are pointing you, wannabe, do the following:

Open your DB. Open a module. Doesn't matter if there is no code in it, you just want a code page up. Create a new one if you have to. A class module on a form would also work if you had one.

In the Menu Bar, follow Tools >> References, you can get to a complex dialog box with a scrollable list and some fields that are not obviously fields. Plus a couple of action buttons. You care most about the list. This list is the software/subroutine libraries you have advised Access that you want to use. It is called the "References" list and is machine specific, stored in your registry. (I.e. if you migrate this application to another machine, the references profile on that machine can be different!) Some number of boxes are checked in the list, but depending on what has been installed on your machine, that list could be short, medium, long, or totally titanic.

What you want to do is see if the MS Excel libraries are checked in this list. If they are not, check them. Then click OK or CLOSE as needed to get back to the regular Access window. You do not need to save any code in the module if you didn't enter any. The only reason you went through the code window is 'cause that's the only way to get to the subroutine references list.

OK, at this point, ANY FUNCTION IN EXCEL is available to Access, even in queries if desired. This is true 'cause the function is in the Excel reference library module and you just told Access to use that library.

Same concept applies for Word, Power Point, etc. Anything that is in your references list represents an application that Access could use for some purpose, or a library of code that Access could use if it needed to. It is just a matter of learning how to call it correctly.

So... if you want to use Excel functions in Access, you CAN. Just follow the instructions above and you are there!

 

[wannabepro]

Thanx Doc man, I really appreciate your help. Really you have made this thing really easy for me. I am so dumb, couldn't even figure it out


SJ I just found that sorry, it was my own fault, I didn't look through it carefully.