Search results

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...

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...

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...

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...

Dear Friends I have develope an Memo field where the users types in the Letters / Statement of Account with general comments on dates and text etc. Additionally I have created unique FieldsNames based on the table. This FieldName can also be inserted/placed in the Memo Field anywhere.(Simple as...

I want to export a report to MS Word or Publish to MS Word - but at the same time I have a small codes which is also a part of the report required to exported to MS Word along with the Report to a Document. Anyone in here can help me resolve the issue

I am looking for a VB Code that would list down all the User define function and procedure. Like I know how to list the names of modules but now I want to list each and every function in each modules. Can anyone in here explain me how to achieve this list? Thanks

Dear Friends, I have Customer Data with Names and Tel/fax No and am using WinFax prof to send faxes via modem to my customers. I have to select the Fax Driver from Print panel and that automatically brings up the win fax prof wizard for sending faxes, requesting the recipient fax No, cover page...

Dear friends I have a data entry forms unbound fields and are added to the table when a users clicks a save button - all the fields are having validation code and are checked on exit the current status of the value entered by the users is correct or not and subsequently and makes a...

Dear friends Its a new idea and I havent seriously worked or thought about it and neither I have a clue whats it going to be like? Idea is - I have a .html scripts with graphics mouse pointer with time/date and currency rates. Is it possible to activate and hide the page over the network in...

Dear Friends I have a .mdb password protected with all types of objects (tables, queries, forms, reports, codes, functions, modules, etc) they too are password protected in VB, the .mdb works fine but when I tried to repair and compact the database from the menu tools option, very recently it...

Dear Friends I have a .mdb password protected with all types of objects (tables, queries, forms, reports, codes, functions, modules, etc) they too are password protected in VB, the .mdb works fine but when I tried to repair and compact the database from the menu tools option, very recently it...

Dear All I have a form with memo field as [acLetter]. Now whenever I open the form the text in the memo forms are all selected/highlighted in all the records. Is there any settings required to disable this feature or have I missed out something, so that the text should not be selected at the...

Dear Friends Something thats very important has just put me on halt i mean a mail merge feature that I want to use from MS Word into MS Access. I have an application for School on MS Access - all the Class teachers have the access to their class student and subsiqently they login and feed in...