Search results

Hi rich thanks for the advice but im a bit confused. I have put the code on the subform, however the subform i am intending to have most of the text boxes init are disabled. they only become enabled once the buyername (textbox) is changed. this is on the main form if i put the code on the...

Hi i am doing a form which also contains a sumform. I dont want users to go striaght to the sub-form and then click on the main form as this causes problem. What i am trying to do is a enabling function where once the user selects the textbox on the main form the sub-form will be enabled...

Hi Rich I have attached a screen shot of the two tables i am hoping to use for this report The date does not have a null value

thank you works perfectly

Hi this may be very simple but does anyone know if you can get rid of the append query warning. I know how to change it using the tools, then option. But i was hoping there was a way where you could elimate it all togeather. many thanks

Hi Does anyone what the best way to do a report for all items of an order that is outstanding I am trying to do a report where I simply type in the project name and then a report would show all items that are undelivered. many thanks

cheers Mile-O-Phile worked just like i wanted, kabir

Hi i have tried to set the default value on the property sheet to 0, zero etc but it does not work the text box is one i have created on the form purely for calcuations purposes. it does not belong to a table. How it works is when users update an order sheet they text box calculates how many...

Hi i tried your code and it doesnt seem to work for some reason. the text box i am trying to make a defualt value if null is in the subform here is the code i am using nevertheless Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(Text22) Or Text22 = "" Then Text22 = 0...

Hi this is very easy i guess but i am no good at VB codes i am trying to make a text box contain a default value using VB. If the text box contains no data i want the default value to be 0 any ideas many thanks advance

Hi many thanks for your help. before trying the marathorn editing all the forms/report/etc i decided to try and import all the tables/queries etc into a empty database, to my amazement it worked and all i am now doing is re doing the corrupted reports. once again many thanks.

Hi i need urgent help as i have the following error everytime i try to open up a form. what could be wrong, i have attached a screen shot of the error message. I can not open any form from one button or another

no need to apoligie mate you were trying to help-thank you

I have tried using access with other databases i have and i still can not use the the command button to create buttons. does anyont know what i could be doing wrong

Command button not working-urgent help needed Hi i tried to use my command button to create a button and for some strange reason it does not seem to work. All that happens is the button appears with command button XX (xx being the number of the button)-what could be wrong can anyone help as...

cheers done it now thanks a bunch

I think i know what you mean, from my experiences if you have a table in a form, when you open the form if there is no data in the table. by default the cursor will be on the first field on the table. so you can type data into it but if you dont want that to happen and you just want to view...

i can understand you being confused, My changeform keep a record of all changes made as it has it own PK and everytime a change is made it is recorded on the table. i really need help on when changes are made on the change form that they update on the main table(tenderlink). however the...

Im a bit confused at to what you mean. y You want users to not add data unless they press the add data button-correct

Hi thanks for your post but i am a bit confused, here is what i am trying to do. I have a form called tenderlink. This form is like an order form. Users place orders using this form. However if an order has to be changed it is done via a change form. This change form is linked back to...