Search results

Hi Can access 2007 database be used on a multi system. Like in a small manufacturing unit with varios departments If the database is on a single system, can users on different system on the same network have access to read,modify or enter data Please help me on this Thanks in advance

yes its exactly the same

hi I have really gone beyond in getting this work i have a checkbox which should get checked if values in two textboxes are equal i have coded on form current() If Me.QTY.Value = Me.TQA.Value Then Me.POSUBMATLSTATUS.Value = True Else Me.POSUBMATLSTATUS.Value = False End If QTY gets its value...

thank you everybody for all those ideas and time. it worked thanks again

hi i checked the requery..it dint work.it still shows all the items

thanks for the reply basically i want to see that the same item is not billed twice, hence if the billed item is removed from the combo then double billing can be avoided

Hi everybody I have a combobox which shows a list of items that need billing i want the item to be removed off the combobox once it is billed. any help thanks in advance krishnanhemanth

thanks for the reply i solved it by using the dlookup function

Hi In my database, there are "PURCHASE ORDER" form -------"PURCHASE ORDER" table--"PONO"--PK "MATERIAL RECEIPT" form------"MATERIAL RECEIPT" TABLE-"PONO"--FK the material recieved is entered in the "MATERIAL RECEIPT"form wrt the "PONO" I DONTWANT THE USER TO USE THE DELETE BUTTON AVAILABLE ON...

thanks for the reply I solved it myself the problem is that the FIELD type has to be "NUMBER" type MY filed type was in "TEXT" Now its working fine

Hi everybody Iam trying to use a custom auto number as a primary key in tables i used the below code on the form current() event. Me!VMRCOUNT.DefaultValue = Nz(DMax("[VMRCOUNT]", "VENDORMATERIALRECIEPTSUB"), 0) + 1 the problem is that it dosent generate number after 10 to put it more...

hi ceh Thanks for the suggestion. i enterd the code in ---afterupdate event of the textbox and oncurrent event of the form nothing happened i then modified the code to .enabled here what happens is ---the checkbox is greyed out irresepective of the value any help

thank you ceh Iam a newbee in vb where should i code it.i mean should i code it in the afterupdate event of the "payment balance" could u help me on the format thank again

hi GEMMA Thanks for your suggestion and time I cannot change the control source since the checkbox is bound to a table

hi everybody i have a field in my table called "PAY STATUS"----a YES/NO TYPE FIELD on the form i have 3 calculated textboxes 1st Textbox is --- "PAYMENTS RECIEVED" 2nd Textbox is --- "PAYMENTS PENDING" 3rd Textbox is ---- "payments balance" ( "PAYMENTS PENDING - "PAYMENTS RECIEVED") wHAT I...