Recent content by Chintsapete

Now you are saying this, I was thinking about it for a bit. Possibly because of the error opening the form caused by SetProperty I noticed that 'Month' was used and changed it to MonthSel without changing the Sql statement in the macro. However I think that the SetProperty line is a potential...

Hi CJ I just realized that in the OpenForm macro the set property is not needed, after I deleted that line in the macro it works perfect again. Thanks again Pete

Hi CJ thank you for the quick reply, I didn't spot the macro error and the combo box works again after I changed it. However the annoying error on open persists for some odd reason I can't figure out. However I can live with it for now. I'm aware of the reserved words, unfortunately I still...

This used to work on Office 2007 no problem, I upgraded recently to office 2016 and since then it gives me an error on open: The control name is misspelled or refers to a control that doesn’t exist. Said control does exist and the macro seems to work as far as the goto control. I have a form...

Thanks Galaxiom and Cronk and everyone else for the help. That works sweet, I had to make a slight change to your line of code so it refers to EndDate. It gave me "error 94 invalid use of null" where date of termination was blank. Working function below for anybody else. Public Function...

I see now why you suggest days, I haven't considered that one, makes sense now. Thanks for the math refresher, forgot about the integer. I'll give your suggestion a go tomorrow when I'm fresh again. Thank you so much for your help.

Hi Plog thanks for the quick response. On the month would be accurate enough, but if I do something like below do I not get a funny output 0.25? I would need O or 1 or 2 etc My problem is it's live database and I'm a bit under time pressure to correct it. It's not quite so easy to test...

Hi all I used below function for a couple of year and I thought it was working. Now I noticed that it's not working to my requirements. The problem is that if an employee starts working in November it's year 0 until January and then it becomes year 1, instead of becoming year 1 in November...

The purpose of the combo is to select between fortnightly and monthly. Half the staff are fortnightly and the other monthly. When the fortnightly wages are due then it would hide all the guys are on monthly wages, eliminates errors for people don't do it all the time and when the monthly are...

Hi RanMan thanks for the quick response. I have the cboBox set as you describe above. I put the IIF statement in because of the table where I filter from the PayPeriod is either 1, 2, 3 or 4. But every second week I do basically the monthly and fortnightly wages together, so I would like to...

Hi all I have a problem with query criteria which really doesn't make sense. I have table with column PayPeriodId, 1-4, column PayPeriod 1= Daily, 2= Weekly, 3= Forthnightly, 4= Monthly On a popup form I have ComboBox where I look up this values. I want to use this ComboBox values in query as...

Thanks Stopher, so close and yet so far, I keep mixing the stuff up with SQL and VBA. I don't do much VBA and never find the time to learn more. Story of my life. It works perfect, I appreciate your time to help. Take care

I'm not quite sure why below doesn't work. I have a form where the [DateOfTermination] is blank until the guys leave the company. Then I'll input the date. Once the date is in it should use [DateOfTermination] as EndDate to determent how many years they worked for us when they quit, else it...

Thanks Accessing the problem with that is, I have to many fields and it gives me the error accordingly. That is where the whole trouble started. Anyway, I know it's not a nice solution, but I wont have thousands of records. It's something to be avoided if one does have infinite records, but for...

My dearest advisers I do apologies for the long delay getting back to you. Doc Man, against your advise I did use DLookup as you can see below. To be honest, I tried for a day to make sense with your logic, but it was just way over my head. I ended up copy and paste the Dlookup formula 100 times...