Search results for query: *

Hi When i select a particular item, from my combo box (supplierid) if there is no record on the subform against that supplierid then subform shows the pervious record. I want to show some message if there is no record on the subform against a combo selection. Thanks

HI I want to select supplier id from combo and an invoice number against that supplier id. and I want to add all the product related to that invoice number on a subform. HOW CAN I LINK THE SUPPLIER COMBO WITH INVOICE COMBO AND INVOICE WITH SUBFORM. I have already create a master child...

Hi to all I want to select an item from combo box (on a sub form) and put the coressponding value on on the bounded text box on the same subform (child form) against a given condition. on my sub form i have three objects: 1-combo 2-two bounded text boxes if i select one value from combo the...

Hi to all I have created a database just almost similler to northwind. every thing seems to be working fine. But at the end i could not reprint the invoice. Actually what i done is that i have created another table (tblhistory) and i append all the record which are moved from inventory ( i mean...

Hi to all I want to make a some button disable on openform event and when during the entry process a user enter a date in date field after checking with the current date(less tahn current date) the disabled button suould be enabled. Any suggestion. I am trying onchage event: Private Sub...

Hi to all I am getting something wrong calculation, When i add the three calculated values the answer is always one cent less. I do not know what is wrong. Waiting for detailed help. Thanks

Hi to all I have situation here I need help, if i add a recored in a (history table) sub form (master detail) that record should be deleted from the other table(inventory), and if i delete a record from subform (history)that should be added to other table (inventory). Any sugguestion?

Hi To all I am working on this from last two week but no sucess, is any body help me out? tblSupplier supplierid(pk) name address --- --- tblinvoice invoiceid (pk) purchasedate supplierid tblproduct productid (pk) name --- ---- tblinv-prod inv-id (fk) prod_id (fk) What i want to do is that...

Hi To all I am working on this from last two week but no sucess, is any body help me out? tblSupplier supplierid(pk) name address --- --- tblinvoice invoiceid (pk) purchasedate supplierid tblproduct productid (pk) name --- ---- tblinv-prod inv-id (fk) prod_id (fk) What i want to do is that...

Hi to all I want to store many records against one invoice number. I want a user enter only once a invoice number then add many record against that invoice number and that invoice should be repeate automatically. Like Invoice date productID SupplierID 100 x x x...

Hi to all I am using one main form (frm supplier) when i select a supplier using combo box i get the information. now i want to add record in subform against the invoice number. Mean after selecting the supplier i just want to enter the invoice number only once and all the records related to...

Hi WHen i click on combo box to view the subform, a error message of type mismatch (error 13) comes up. Contract_afterupdate() if contract.column(0) then me.subform.visible=true elseif contract.column(1) then me.subform1.visible=true else me.subform2.visible=true endif I am getting error...

Hi I am using one combobox(unbound) on my main form. I want to hide and unhide the subform according to my selection on combo box. I am trying like this: afterupdate() if combo83.column(0) then me.subform1.visible=true else if combo83.cloumn(1) then me.subform2.visible=true end if end if i...

Hi to all I want to display data on subform from selecting a record from combo box in main form. I want to select the Plane(one year, two , or three year) from the combo box and display the price of palne on subform (text field) depending on the model number of cell phone. Thanks