Search results

  1. B

    Make folders from query

    Ok Thanks The big one was to create the folders which you have helped me do....... I don't know enough too figure the sub folders out..... One other thing I looked at using code tags example. how do you put the extras on the bar. I don't have the #, indents and a bunch of others that were in...
  2. B

    Make folders from query

    Thanks I took out the folder created and now works good they all populated.... I tried to put the code in for the sub folders and I get an error path not found and the FileSystem.MkDir (strFolder) is yellow highlighted Thanks Bryan
  3. B

    Make folders from query

    Thanks NamLiam for your help, I put this code in I think it is stuck in a loop. The "folder created" msgbox comes up but you have to click it until the entire query list is done. I had to click it 133 times.... Also If I want to add a sub folder using the next column in my query [Month] I...
  4. B

    Make folders from query

    Hi, Can some one help me or direct me to an example. I am trying to make some folders from a Query list to my C drive. I found this code for making folders. I have a button on a form with this code. It works with making a folder but only gives me the first item in the query out of many rows. It...
  5. B

    first date and last date of that 2 week pay period

    Thanks for your Help And everyone else. I appreciate it. I think my database is not quite set up properly. I going to think about re-designing my database. The one thing I got out of this help is that - I need to know exactly what i want need to be able to describe it. I may ask for some...
  6. B

    first date and last date of that 2 week pay period

    NamLiam, Thanks. "When ever the start date of a project, my two week period always starts on the saturday before" is NOT true. Because ever client has a different way they do there time and pay. It could be Sat,sun or mon. I will only know what their period are in the contract when I start a new...
  7. B

    first date and last date of that 2 week pay period

    Sorry I was too busy yesterday to look at this. I thought I resent the database yesterday too. Try again to send Namliam, I have the date and jobs in the same database. Are you saying make another tbl and relate it to the date tbl. It is a little over my head what to do. Thanks BBryan
  8. B

    first date and last date of that 2 week pay period

    sorry It didn't load I will have to make it file smaller. But can't at moment. BBryan
  9. B

    first date and last date of that 2 week pay period

    Sorry, In the big picture the database is the time sheet, of hours, per day.Yes there is different jobs with different start dates and different Payperiods. I need to know what pay period each day belongs to to make out the time sheets. In the query I want to be able to populate this...
  10. B

    first date and last date of that 2 week pay period

    Hi Namliam, You still could be right but but I don't want to have to go into the query and change it everytime unless there is another way. Thanks BBryan
  11. B

    first date and last date of that 2 week pay period

    Hi JDraw, After looking at you code. Is not quite what I was looking for. I think I might not be clear in what I was trying to say. In your first post you have a code to get the WeekdayName and date for every 2 week beginning 28 Dec 2013. This is kind of what I was looking for but for every day...
  12. B

    first date and last date of that 2 week pay period

    Thanks for your help. I will try this out tomorrow. I'm going to a meeting for the rest of the afternoon I will let you know how I made out with this. Thanks BBryan
  13. B

    first date and last date of that 2 week pay period

    I need to calculate the 2 week payperiod start and end date for each Day in my lookup table. And I would know when the job starts the first day of that payperiod which could be a fri,sat or sun. So if I started on Wed Oct-01-2014, the 2 week period would be start on Sat Sept 27 2014. For that...
  14. B

    first date and last date of that 2 week pay period

    I don't have a function because I don't know how to make it. All I have with the help from this site is that query I just posted. I wanted a function instead of a query. I have that function I use for a 1 week period (In the first posting) but don't have one for a 2 week period. I thought there...
  15. B

    first date and last date of that 2 week pay period

    I don't know the dates it is for future. I have this for payperiods on different jobs. Some have the week ending on a Fri, sat or sun. I am using this Query/function in a lookup table so I figure out the Payperiod dates. With a query I have to manual go in and change the start date. That is why...
  16. B

    first date and last date of that 2 week pay period

    I may be wrong but I think it is easier because I sometimes have different scenarios of the start date. BBryan
  17. B

    first date and last date of that 2 week pay period

    Thanks ALL for your help I couldn't do this on my own. What I ended up doing was in a Query. 2WeekNumber: Int(([MyDate]-#2013-12-28#)/14) FirstDayIn2Weeks: DateAdd("d",[2WeekNumber]*14,"28/12/2013") LastDayIn2Weeks: DateAdd("d",[2WeekNumber]*14+13,"28/12/2013") I would have liked this in a...
  18. B

    first date and last date of that 2 week pay period

    Hi Gemma the husky. Thanks also. Still a little stuck Is that a function I would put that into I am not sure how to put this into a query BBryan
  19. B

    first date and last date of that 2 week pay period

    Thanks JDraw Is there a way to call this from a query I see it can be used from a button. BBryan
  20. B

    first date and last date of that 2 week pay period

    I was trying to use this in a query. I would like to make a function and call it from my query. Manually if I was to do this I would take My Dates for the whole year starting on Dec 28 2013 and make groups of 2 week payperiods. I then would know what first date and last day of this payperiod...
Back
Top Bottom