Recent content by kedarj

I tried with the wizard. But what the wizard does is in the detail, it shows all the records. But in the footer for brand, or country, it does calculate the totals of all value type. What I need is a summary total at Brand, and also a summary total at country. Any clue how this can be managed?

Hi, I have a table which has a country, division, category, product, Valuetype, value data looks like this: Country division, category, product, Valuetype, value --------------------------------------------------------------------- UK Division1 Food Pizza Volume 10000 UK Division1 Food...

Hi All, I have a table with following structure: Product ID Pricing Type Price There are three types of Pricing types. The records look like this: Product ID Pricing Type Price 1001 Consumer Price 23.32 1001 Manufacturing Price 18.90 1001...

Hi all, I have a edit form, where au ser can edit a record. I want to add a copy button, which would result in creating a duplicate record in the database. Can anyone suggets how this could be done? Regards K

Can I add a Copy Button on the form and put the code on the ON-CLICK event? thanks KJ

Hi, I have a Edit Form, where users edit the customer information. I want to add a Button which creates another copy of the same record in the table. How Can I achieve that? any suggestions? Regards -KJ

Hi, I have following tables: Employee Master : Employee_ID, Employee_Name Employee Specialization: Employee_ID, Employee_Specialization User selects Employee_Name from Employee Master. User then has to select Employee_Specialization from a combo Box (This should contain all Distinct...

It Worked! Thanks a lot guys!

I want to change the Caption of a textfield depending upon a value selected from a combo box. i.e. If the user selects 'Scientist' from combo box, then the caption to enter name should be 'Scientist Name' if the user selects 'Engineer' then caption should be 'Engineer Name'. Can anyone guide me...

Your sample program is great. But I am having problems with subforms. your advice will be apprecieted

This works great! Only problem I have is that it prints all the records. How can this be avoided and only the current record printed? Thanks K

I have a Report which is called from a Macro. The Macro prompts for the ID (record number) which needs to be printed. It works fine. Now, I want to call this Macro from the Form on On Close Event. How can this be done? Regards K

I want to send an email from a form depending upon the status selected in the combobox. Where and how cna I do it? Help appreciated. Thanks K

What are the steps I should follow? I want to have the following: Administrator - Who can change forms and do everything Editors Group - Can change some forms Reviews Group - Can only see the Reports section Can you help me understand, how I can do this? Thanks K

I want to have the value calculated by a formulae with an option to edit it/overwrite it.