Posts by Newt

    Hi Guys,
    I need help fixing a code on an excel spreedsheet that when inputed calculates the right taxes.
    The current forumla looks like this:


    and I need to add:


    but my addition does not work with the previous formula.
    It seems to have a problem with my brackets. I deleted them all and re-entered them but it still does not work.
    Thanks for any help.

    Re: Date Calculator For Weekends & Holidays

    Here I tried to change a few things to make it access97 friendly. It works but only for Jan 1 2006. all the other days don't work and I'm sure I am missing a piece of code...please someone help.

    Re: Date Calculator For Weekends & Holidays

    I copied and pasted your code into a new database to make sure it worked.
    I set up a table called tbl_holidays and a column called Description and the other called HolDate.
    My form is called Travel Data. When it gives me the error message saying that the variable is undefined it highlights "CurrentProject"
    I'm not sure how to fix it.

    Re: Date Calculator For Weekends & Holidays

    I hate to be a pain but I have access 97 only.
    If you could copy and paste the code here for me that would be wicked.
    I tried opening the file but it doens't recognize the newer version of access.

    I found a shareware program that calculates Dates based on criteria you set up.
    I need to find out the code for that program to use myself in access. I have made a table with all my holidays in it.
    Now I need to create a code that will check to see if the day is 1. a weekend 2. a holiday or 3. a holiday that falls on a weekend that becomes a holiday on Monday. Then it needs to skip those days when calculating the due date.
    I have attached a copy of the Date Calculator program that does exactly what I need an access code to do.
    Please help I have tried so many different codes and nothing works.

    Re: The "like" Criteria To Find Records

    Haha ya I guess I shouldn't of wrote "this should work" when I have no idea what I am doing...haha
    Thanks for the help...I figured it would be something dumb on my part.
    It works great thanks very very much!

    I am having some troubles making the "Like" criteria in access work properly for me. I am trying to use a form for the user to put in search criteria to find records.
    For example find all records with the name "Danielle". I know this would be easy to just go into the query and put

    Like "*Danielle*"

    and it would find all variations of it but the people that are using my database will not know how to do that.
    So I created a query that finds records based on criteria entered by the user on a separate form. I then put in the criteria:

    Like"*([Forms]![Search]![Find Employee Name])*"

    which should work but it does not.
    Does anyone have any ideas???

    Re: Code to add 10 days not including weekends

    Can someone help me to modify this code to skip Dates that are holidays?
    I have made a table called holidays and included all the holidays that need to be skipped.

    help the holidays part never works...I cannot seem to find a solution anywhere.
    Thanks for any help!

    Re: Updating Table with a Calculated field

    Sorry Never mind my last response. I think that my initial database just has a glitch of somesort....some deleted piece floating around messing things up.
    When I tried what you told me to do on the "sample" database I attached it worked just fine.
    Thanks for all your help everything is now working great.
    This site honestly rocks! I rely on the multitude of information floating around here and the fact that help is always available.

    Re: Updating Table with a Calculated field that does not work either. I even tried it in the form field and it didn't even work there. The old function works fine on the form but not on the query....
    I don't get it...

    Re: Updating Table with a Calculated field

    I tried that and it still did not just said
    "Undefined function <DateAddW> in expression. (Error 3085)
    You entered an SQL expression that includes a Function procedure name that can't be recognized. Make sure the function exists, that it can be used in SQL expressions, or check the expression to make sure you entered the name correctly."

    I am attaching a small sample of my in progress...

    Hey guys,
    I am having a dilema.
    I have a field in my access form that calculates the "Due Date". It Calculates the due date using a module I added. When I used the forumla from my module on the form it works and gives me the right day.
    However, when I use the same formula in the query to try to update the actual table it says it does not recognize the function.
    Any ideas???

    Here is the Function:

    and here is what the field looks like:

    =DateAddW([Return Date],10)