Search results

Thankyou - Very much Last night I started working from scratch and =IF(D6<=0, F6*-1, IF(E6+F6<=0,0,MIN(D6:E6)-F6)) but still the result werent so accurate Thanks a million.

Hi D col represent customer actual balance E col represent 60/90/120 days/ageing col balance F col represent carried forward provision Result col is new value of provision required If D col balance is 50 and E col balance is 75 provision amt is 100 - so you need provision thats equal to 75 or...

Dear All, I need help to compare three col and show the value in column Result Result Col contains formula as: IF(E92>=F92, IF(D92<0,0,IF(D92>E92,E92-F92,D92-F92)),IF(D92<0,F92*-1,IF(E92<0, F92*-1,E92-F92))) -------D------E------F---Result--Balance...

Dear Friends I have an excel file consisting of 27 sheets. Each sheet has specific information about the supplier and there Invoices. the Summary is linked again to one Main sheet. Question Is it possible to view two or more sheets using split options or any other ideas/recommendation...

Thanks it works I was using the Menu Item and was inserting the Picture which use to print in multiple logo depending on the lines items of the Invoices Thanks alot - keep the good support going

requesting expertize guidance in here again Please........

There are two methods to go about it..... and I am using the second method and is working marvelous well first method Draft the entire letter in word and use the mail merge option using the query from the MS Access. second method Its pretty complicated and requires few lines of code including...

Hi all, I want to be print background image (Company LOGO) as a watermark for Access Reports, specially on Invoices when they are printed. Right now I am using preprinted stationery. Can I set it up a watermark logo in the center of the page irrespective of line items of the Invoices. If yes...

Dear friends I created the planner for salesmen using activex control (mscalender) on the excel sheet. I am able to work and click and everything is OK. Now when I emailed the same file to my assistant to fillup the details on the Planner he is unable to click on dates on the calender. The...

Dear friends I request your comments please... I have a form with bound and unbound fields and have linked the [Event Procedure] on these fields base on there respective action. Now when I open or click a particular field with the event procedure, the procedure is names are like - Private...

Dear Friends, I have stumble on a very vague situation over here - never happened with me before. Its like I have the copy of .mdb with tables, queries, report, macros, modules etc. This copy of .mdb works fine with all the object except reports on my desktop, while the same copy works fine...

THANKS - I GOT IT FIGURED OUT I was declaring it as the main form in the dim statement which is now dim subfrm as subform works well - thanks alot

I want to refer them based on the users selections on the main form refering means i want to change the background colors and i want to block some controls which i am able to do in the main form - but i cannot refer to the subform. Function PutValInMem() Dim dbs As Database, rst As...

It doesnt help as the loop code section only list the controls in the main form and not the subforms controls I am looking for a way to locate the controls on multiple subforms - Thanks

Dear Friends How do I list al the controls on an open form including mutiple subforms Please advice

I have a unbound Form for Data entry and wish to save the few fields data for immediate call back at a press of a key in next posting - The are many ways I can do it in Access - but which would be the best/Idealistic way to deal this action. I can create and use temp table I can create and use...

Yes its possible, provided that specific form has to be active/open before referencing

Thanks Ghudson I have tried importing the table linking the tables to new .mdb file - but doesnt work. The moment it opens it gives me the same message. I have the backup copy but the few days work will be a lost - but still to work around for future mishape - what would you recommend?

Dear Friends I need to insert a tick box on each row starting from A7:A6201 - can it be done in excel? - please advice. Thanks Idris

Dear friends Please help I have an Financial application - with lots of transactions approx 92000 records linked in then 37 tables - yesterday while opening the file I get this message (attached) and am unable to reopen the file. Please advice ASAP. Thanking you in anticipation for the...