Search results

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

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

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

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

In my Textbox Control source I have given a formula =[Product Price]+[Delivery Costs]. I would like to provide an option to ther user to overwrite this Textbox (Should able to input a value). When I try to edit the calculated value on the form, I get a message "Control cannot be edited, bound to...

Hi, I am trying to use Audit Trail in Access2000. I tried to look at this snippet from Microsoft. But I am getting an error when I save the record. Actually I have a form with 8 tab pages. It tracks that the change is made, even though it gives error message, but does not track which field was...

Hi All, i need some more help. I have an access application which has 6 different forms. The application will be accessed by 10-12 people. some can have an access to to all the forms and some may have an access to a few of them. How can I set up the password security for the users at application...

Hi All, I need some help. I want to disable the Escape key when users are entering data on a form. How can I do that? Help apprecieted Regards K

I have a report which has got the pageheight of 55 cm. I want to increase the pageheight of the report, basically add more pages, as my report is about 3-4 pages. How can I do this? regards K

I have a combobox with product description in it. If by mistake, I select a wrong value, then the other values are not refreshed. I have to close the form again and then reopen and reselect the values. What could be the problem? Any help?

I have a table in which I have about 245 fields (I know they are too much, but cant change the structure). There are about 4 numeric fields, which have field type as Long Integer. I want to change them to Field type Single. When I try to change them, I get a message too many fields defined. What...

I have a table in which I have about 245 fields (I know they are too much, but cant change the structure). There are about 4 numeric fields, which have field type as Long Integer. I want to change them to Field type Single. When I try to change them, I get a message too many fields defined. What...

Hi guys, I need urgent help on a simple question. I hope you will be able to help me. I have a table CustomerMaster which stores customer number and name. (Customermaster) I have another table which stores the product details for customer. (customerProduct) I have another table which shall store...

Hi guys, I need urgent help on a simple question. I hope you will be able to help me. I have a table CustomerMaster which stores customer number and name. (Customermaster) I have another table which stores the product details for customer. (customerProduct) I have another table which shall store...