newbie question.

[vicsaccess]

i'm trying to work on a vacation scheduler for employees to input vacation dates. I have a table for dates and a table for holidays and am trying to use the module from https://msdn.microsoft.com/en-us/lib...ffice.12).aspx. I've copied the code from the calculating working days and am getting an error undefined function 'workdays' in expression. i'm sorry but i'm just starting with modules and i'm lost. any help would be appreciated.

[pbaldy]

You would have needed to copy that function into a standard module (not behind a form/report), and make sure the module doesn't have the same name.

[vicsaccess]

it names itself? here's my expression in the query that is getting the error. Expr1: Sum(workdays([startdate],[enddate])). this is a common module so i'm sure it works, I've just never done one before and i'm sure i'm missing something. I copied the code into a blank module and saved it. then tried using it in a query. no luck. please help me understand.

[pbaldy]

What did you name the module when you saved it?

[vicsaccess]

I saved it as workdays

[pbaldy]

Did you miss

and make sure the module doesn't have the same name.

[vicsaccess]

not sure where you are getting that, I did exactly like the page said.To create the user-defined functions

1. Click the Microsoft Office Button, click Open, and then open the database where you want to insert the functions.
   
2. On the Microsoft Office Fluent Ribbon, click Database Tools.
   
3. On the Macro tab, click Visual Basic.
   
4. On the Insert menu, click Module.
   
5. At the top of the module, type the following two lines, if they are not already there.
   Option Compare Database
   Option Explicit
   
6. Type the Workdays and Weekdays functions exactly as you see them in the previous code example. Or, if you downloaded the sample database, copy and paste the functions from the Business Date Calculations module.
   
7. On the File menu, click Save.
   
8. Type a module name, such as Working Days, and then press ENTER.
   
9. On the Debug menu, click Compile.
   
10. On the File menu, click Close and Return to Microsoft Office Access.

After you place the functions in your database, you can use them in Access objects such as queries, forms, and reports.

[ItsMe]

..........

I saved it as workdays

1. Type a module name, such as Working Days, and then press ENTER.

[pbaldy]

Don't know how else to say it. The module can not have the same name as the function.

[vicsaccess]

I've tried multiple names. I give up

[pbaldy]

You can post the db here if you want.

[vicsaccess]

Vacation1.ziphere's the DB. the module is workingdays and i'm trying to use it in query TimeQ. I really want to learn more but i'm getting frustrated. any help helping me get this working and learning my errors would greatly be appreciated.

[vicsaccess]

sorry, when I was trying to get the personal information and extra tables deleted to make the file size small enough it looks like I deleted my holiday table. i'm trying to use the module to take the employee from the employeeT and the vacation entries from TimeT and get working days minus holidays that are listed in the tblholidays. I know this is not that hard but its my first attempt and i'm failing. someone please tell me what i'm doing wrong.

Vacation2.zip

[pbaldy]

The second sample is still missing a query, but the primary problem is the same. You've named the module "WorkingDays", and you've named the function "WorkingDays". THEY CAN'T BE THE SAME. Change the name of the function to "WorkDays" and try again.

[vicsaccess]

Thank you all