Search results

  1. T

    VBA code to set data in combo boxes using raion buttons

    confused so in do i put the code something like this (the form_current event??????????) Public Function form_current() If Me.Retention = 1 Then Me.CmbReason = Me.CmbReason.ItemData(0) Else Me.CmbReason = Me.CmbReason.ItemData(1) End If End Function just in the gnereal section of the...
  2. T

    more combo box problems

    also the code i have behond the scroll button is as follows maybe i need to add some code to this to make it look at the value stored in the table Private Sub Next_Record_Click() On Error GoTo Err_Next_Record_Click Dim answer As Integer If Nz(Forms![Main Form]![RMD Marks...
  3. T

    more combo box problems

    I have been looking at setting values in combo boxes by clicking the radio buttons. MILe –o-pjhile helped me to get to where I am now and thankyou for that BUT, a small problem has occured Basically I have a set of combo boxes one which is names permanent and the others which are number of...
  4. T

    VBA code to set data in combo boxes using raion buttons

    a new problem added to an old one I have been looking at setting values in combo boxes by clicking the radio buttons. MILe –o-pjhile helped me to get to where I am now and thankyou for that BUT, a small problem has occured Basically I have a set of combo boxes one which is names permanent...
  5. T

    problems with combo boxes

    Hi there I am a bit stuck I have a combo box that is bound to my main box table, which in turn is connect to the main form query. in there I will have a number of barcodes, I would like to be able to get a list of the barcodes on the drop down menu . What I have done so far is that I have...
  6. T

    check boxes

    Thankyou rich much appreciated i had it kind of right but just in the wrong place many thanks
  7. T

    check boxes

    Afternoon all One extra little thing, I have a check box and a text field in my database. The check box is to show whether the document is here or elsewhere. The text box is used for inputting the name of the person who has it. What I would like it to do is when the check box is de-selected so...
  8. T

    VBA code to set data in combo boxes using raion buttons

    an absolute star WOW thankyou so much it worked you are a star would you mind me coming back and asking for more help if i get stuck down the line i am completely in debt many thanks ifi ever meet you i will buy you a beer
  9. T

    VBA code to set data in combo boxes using raion buttons

    yeh thats what i wanted but two things 1) call me nieve but i can't figure out how you did it could you explain i have looked through the properties and can't find anything and there doesnt seem to be any code 2) i have 4 values inthe list permanent is the highest catergogories and there ia...
  10. T

    VBA code to set data in combo boxes using raion buttons

    maybe a work around maybe a workaound would be better for the moment, if i get things working then i can go and sort the normalisation out later you wouldnt be able to help me with my inital question would you?????. i have just tried to zip down the dataase and it is still 7mb so i can...
  11. T

    VBA code to set data in combo boxes using raion buttons

    Table Structures will this relationship screen shot help ????
  12. T

    VBA code to set data in combo boxes using raion buttons

    table structures the database is split in two one database hold all data the one i am working on holds the forms and code. the database is linked together using the link tables manager i believe that the table structure is all tables, i must apoligise i am almost a novice
  13. T

    VBA code to set data in combo boxes using raion buttons

    i am willing to fix this not sure what you mean though woudl you mind explaining more
  14. T

    setting a default date in a field after clicking a command button

    thankyou mile-o-phile many thanks it works you are star thankyou for your time
  15. T

    VBA code to set data in combo boxes using raion buttons

    row sourse both the row sourse and the control source is pointing at the reason table which holds the options for combo
  16. T

    setting a default date in a field after clicking a command button

    I have a new box form, which chooses to add the new box to the main form. When you click the continue button it asks if you would like to save details to the main form you say yes and the main form appears with the information on. What I am trying to do is; On the properties of the exit...
  17. T

    VBA code to set data in combo boxes using raion buttons

    Good morning everyone I am new to VBA, but I have come to a bit of problem. I am using some radio buttons, which hold different lengths of dates one is permanentt and the others are 16yrs 10yrs etc. I have a combobox, which holds options as to whether it is permanent or not. What I would like...
Back
Top Bottom