Search results

  1. E

    Counting records

    Can anyone see where I'm going wrong? I'm trying to click on a button, which goes to a form called 'RelatedMaterials', this works fine. I want this form to have the check boxes on which are ticked according to the Query. This was working fine, exect ot gets to the end and produces an error...
  2. E

    Counting records to do a loop?

    I've got a form with several checkboxes on, ticked according to whether th evalue is tru or not. -Well sort of. The code I have so far: Private Sub Form_Current() If Material <> "" Then Do If Material = "composites" Then ChkComposites = True End If If Material =...
  3. E

    Removing/Adding records according to checkboxes

    OK, I've got a good 'un here... In a form called RelatedMaterials, I have several checkboxes, either ticked or not according to the appropriate ID. (still not working properly yet, but anyway..) I want to be able to add or delete records from these boxes. SO.... Ticking 'ceramics'...
  4. E

    Looping

    I can get my looping to work!! What I want is to be able to load a form up with several checkboxes. According to the ID that has been chosen, the appropriate check boxes should either be selected or deselected. I'm pretty sure a loop is needed, I've got it working soi that the first record is...
  5. E

    Checkboxes, and displaying records

    I have a form which I want to show checkboxes that are checked according to the results from a query. If got the code under Form_load, this works that for the 1st record the box is checked, but goin to the other records there is no change. I'd like the results not to be displayed by individual...
  6. E

    Filter and list box trouble

    I have a form which is filtered to display the records according to what button is pressed. I need to show all Age Ranges for example, for a given ID if the Age Range button is clicked. I've got a query which has combined the Contributer ID with the appropriate age range, but I can't seem to...
  7. E

    Combo Box, fixed/from table?

    I'm an Access newbie, not sure what I'm doing and would appreciate any (simple) help. I've got a combo box, which I want to keep the value read from a table. It shows the status of records, so each record you go to,the status is shown in a combo box i.e active, inactive etc. I want to be able...
Top Bottom