|
View Full Version : roundup function in Excel not Access sestrade 12-07-2001, 08:18 AM This issue has been posted before, but I cannot find out why the roundup function works in Excel and not Access. msowcf.dll is installed. Forum responses have been "work arounds". Does anyone know how to make roundup work? Jack Cowley 12-07-2001, 10:54 AM Roundup is not an Access function. You will have to use a 'work around'. kwartin 08-06-2002, 01:04 AM Alex Have you found the ansewr for your question? I have the same problem, I'm trying to roundup in Report Kwartin Originally posted by sestrade This issue has been posted before, but I cannot find out why the roundup function works in Excel and not Access. msowcf.dll is installed. Forum responses have been "work arounds". Does anyone know how to make roundup work? roundup Fornatian 08-06-2002, 03:00 AM You can include the Excel library reference into your database then use the WorksheetFunction.RoundUp() function in Access. kwartin 08-07-2002, 01:54 AM How can I do this? Kwartin:( kwartin 08-07-2002, 02:01 AM how can I include the Excel library reference into my Access database ? Kwartin :( Fornatian 08-07-2002, 12:08 PM In your module choose tools-references, scroll down the list and you'll see one for Microsoft Excel 8.0 library(I think), I am a luddite so it may have increased a notch or two. Anyways, with this ticked you can access the Excel functions via VBA only, they DO NOT appear in the expression builder. Jon K 08-08-2002, 11:39 AM After making a reference to the Excel library, we can create a public function to access the Excel Worksheetfunction.Roundup() indirectly. The public function is available in queries, forms, reports as well as in the expression builder. Fornatian 08-09-2002, 03:36 AM Nice one jon, should of added that myself - ah well, we can't be brilliant all the time. |