Search results

I am googling here and there but finding nothing.. here is my problem.. I have a field Book value (cost of asset), then purchased date, then a field count of months from the purchased date, then a field count of year from purchase date. What i want is to see the current depreciated value of...

Could you please elaborate this in detail i shall be thankfull

Regards, I need asset to be depreciate as below; Like i have a field in query which is showing the date of purchase, months of purchase from date of purchase, count of year from purchase date what i want is; suppose if LCD is in category of Electrical Equipment and the depreciaition of...

Absolutely perfect.... Thanks a billion

Could you please give me an example for lookup

Regards, I am having a query which having a category field like Electrical, Sports, House hold etc. What i want that if i select Electrical then it should return 15, if Sports then 10 and so on i think this could be done through this below menitoned VBA but it need change from integar to...

Regards, I have a report having data from query i have taken only 4 fields from query in detail section of report in design view. What i want is that the report to print for single record single page means currently it is printing one more record on one page which i don't want and i want the...

Regards, I am having a query, where a few date records are null because of no entry or record, what a want that the field with no date entry to be come up with zero "0" .. any idea

Regards, I have a query where i want something like this; Field name as Unit_A consume unit 100 Field name as Unit_B consume unit 103 Rate Consumed are in two different numeric field named Rate_A & Rate_b What i want is, like Unit_A consumed less unit then B so the less rate from...

Regards, I have copied a VBA from the net and it is working fine and producing my report on outlook body text but one problem me facing is that it is pasting only first page if the second page is there it is not coming in outlook text body this what i want rest every thing is correct the code...

Anyone could reply please

Regards I am using the below VBA code for the exporting of my report to outlook from access 2007 report, but the problem is the second page is not displaying how this can be handled the code is: Private Sub Command86_Click() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim fs, f...

Regards, I have copied a VBA from the net and it is working fine and producing my report on outlook body text but one problem me facing is that it is pasting only first page if the second page is there it is not coming in outlook text body this what i want rest every thing is correct the code...

Regards, I am looking to sent report from access 2007 to few recipients and i want the report to be inserted with same formating as actual in the text body of outlook 2007 and not as attachment, after this it should ask for TO, CC and BCC any idea please

Thanks for your time.. 1. Table name where i want to add item is "asset management" 2. Field name is "Asset name" 3. field name "Tag"

Yes i am having a form name Asset Form where i am entring info of asset purchasing

Thanks for the reply I have a table asset management where i have a dropdown list and all items are listed there once i select LCD from there means i purchase it and then enter other information same if i purchase new LCD again then the same process again i want to get number for specific item...

Regards, I am having a query where i want to get new number for same item like i am doing it for asset tagging for example; LCD it should be 1 then if repeat LCD then its number should be 2 same as if AC then 1 if repeat then 2 and so on

The horse is drinking water now .... Marvellous ARI the work done

Not finding the soultion yet.. Just guide me like if i want to get result suppose if figure is between 0-33 then result should be C-3 then if 34-40 then result should be C-2 just iif criteria ?? may be in query doesnt work ?