Excel functions

  • Thread starter Continental Translations
  • Start date
C

Continental Translations

Is there anyway I can get Access to use Excel functions? I am presuming I
can as they are kinda linked.

What I want is for in my Switchboard list, I'd like to be able to select
something called 'Get a Quote.' Now, I have a form and a table with a list
of contact, with their source language, their target language and their
prices per 1000 words for general and specialist texts (these prices are
sometimes different.) Now, when i click on 'Get a Quote' i'd like a little
pop-up box to open asking me to fill in the following:-

- Source Language (using a dropdown menu created from entries in my
'Language' table')
- Target Language (using a dropdown menu created from entries in my
'Language' table')
- Number of words (free text)
- Specialist Text? (yes or no tick box)

Once I've filled all these in, i'd like to click on 'go' and then it to
search my database for the people who meet the criteria I have entered. I'd
then like it to then divide their price per 1000 word entry (or specialist
price per 1000 words if 'Specialist Text' box was ticked) and then multiply
this by the number of words. I would then like it to multiply this by 30%.

Thanks all
 
A

Arvin Meyer

Sure. Just set a reference to Excel and you can wrap up a function into an
Access function. Here's and example of how I wrapped the Excel Floor
function so that I could use it in an Access query:

Function XLFloor(dbl1 As Double, dbl2 As Double) As Double
Dim objXL As New Excel.Application
XLFloor = objXL.WorksheetFunction.Floor(dbl1, dbl2)
End Function

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
L

Larry Daugherty

Yes, you can use Excel functions if Excel is present on the machine running
the Access application. But, why bother. There is nothing in the implied
design that requires math functions any more complex than the basic four.
Stay in Access. Write function procedures for the complex bits that would
be too cumbersome in straight line code.


HTH
 
Top