Search results

Thanks. These two dates are appearing in my query as Qtr 1-2015. These should be Qtr 2-2015. This is the result when I ran the function (made slight changes to the function). ?QFix(#29/09/2014#) Qtr 1-2015 Something is not right if you are getting it as quarter 2.

Thanks and I apologise for incorrect quarters in July. I was trying to mock up using fill down. I have now used the revised code. But I still have an issues. I have attached a copy of the dates and the quarters being assigned using the code. I have highlighted where adjustment will be...

Thank you Namaliam and Plog. The function is great and that needs to be adjusted a little. Plog, I may have mixed up a few things. In nutshell, last sunday in each quarter is the end of the quarter. The following Monday is the start of new quarter. Most of the time, we have an issue in...

I am using the following formula to list quarters. Qtr: Format$(DateAdd("q",2,[Finish]),"\Qq yyyy",0,0) This really works on the premise of month end. However, as we follow an accounting quarter (using July-Jun financial year) which always starts from a Monday and ends on Sunday, I need to...

Re: Sending Google Mail (Gmail) from MS Access, VBA, Excel, Word... How do I deal with fire wall. I think because of this I have an error cropping up. I have attached the error. May be you could figure out the reason.

Could someone hnelp with this?

I have a back end 2002 DB. I would like to disallow access to this through odbc connection. Is there some way this can be achieved? Thie directory where it is located is unfortnately cannot be restricted as the front end mde also resides there. Thx

Thanks a lot.

Thanks. Could I create a public function along these lines where I can keep changing the cost instead of having to amend eacg field formula.

Thanks. it is a simple one to many situation where I have a store and on the many side there a are a number of works to be done which are highlighted by true/false. Table 1 - store Store name Table 2 - works work1 work2 and so on. I would like a function that evaluates the true/false in each...

I have a query which basically lists stores and various works to be done in each of them which is indicated by true/false. I have about 8 things to be done to each store. Is there an option to create a function which holds the amount of money needed for each work to be done cand instead of...

Thanks. By changing all condition for a similar test actually worked and it works fine. I really would like to thank you for the guidance. Cheers

Thanks. Tried the following but then I lost all the formatting. I did leave two other conditions as 'fieldvalueIs' and a simple 'equal to' and the new value.

I have a DB that that is being successfully used but I am ware that the sheer number of fields and the nature of info contained therein, my table needs normalising. I read on normalisation and tried to relate as much as I could but in some cases, you are simply lost because you don't want to...

Would you be kind enough to explain how to use two criteria as expression? So in my example I wish to test two fields to paint the field.

Thanks a lot.

I have run out of choices for conditional formatting. There is a limit, hence the request.

I used conditional formatting in my continuous form which really works great. So if the field says red, I can paint it red. I initially started writing code to achieve this but does not look like it works well in a continuous form. Anyway, I have a little issue. In terms of field that is...

Thanks a lot. Cheers

I have a DB that I wrote in Access 2002 version. I was previously using Office 2002 so there was no issue but lately as we moved to Office 2007, each time I created a mde file of this DB while within Office 2007, I got an error 'the expression on click you entered ... right in the begining when...