Search results

  1. C

    validating text

    In subroutine1, I call on subroutine2. how can i exit subroutine 1 from a code in subroutine 2?
  2. C

    Login From Security Access

    Hi I have created a login form for users. I was wondering whether it was possible to change the following properties whether the user is an admin or not? enable design view enable layout view display navigation pane This is on MS Access 2007 Thanks
  3. C

    Filter a Subform

    I am getting a run-time error "438" when using that code "Object does not support this property or method" ??
  4. C

    Filter a Subform

    On a form I want to filter a subform according to the value chosen on a combo box. My subform is made from a query and in this query I have the below criteria for one of the fields. Like [forms]![Results_Form].[combo49] & "*" I also have the following code, so it requeries: Private Sub...
  5. C

    Count Problem

    Ok...Picture this A table with 10 different sports Another table with 6 people each choosing 3 different sports. I want to count how many times a sport is chosen. Hope this helps. I cant use excel, must use access to calculate or show results.
  6. C

    Count Problem

    tell me about it ...problems. Dont know how to sort it whatsoever!
  7. C

    Count Problem

    Hi I have a table with 10 different options. I also have a table which contains multiple records for users with SIX option columns. These option columns will each have one of the 10 different options selected by a user. How can I count the number of times an option has been chosen? Is there a...
  8. C

    Looping Through Combobox

    aha - you are onto me! LOL That code loops through everything. Not sure how to just loop through combo boxes 4-6?
  9. C

    acSavePrompt

    Hi The form closes fine but I do not get a prompt for saving changes. Please help! Also is there a way of tailoring the prompt message that is displayed? Private Sub Quit_Click() DoCmd.Close acForm, "main_form", acSavePrompt End Sub I would actually like to quit the entire access...
  10. C

    Looping Through Combobox

    Hi I have a validation i would like to use on several combo boxes. I was going to put this validation in a seperate sub routine Is there a way of looping through comboboxes 3 - 6 in a code.
  11. C

    add blank value to a combo box

    Wooooaaah this is quite complicated for me. Can you help me write the code. My row source type is a table/query and my row source code is: SELECT ..............ORDER BY [Points].Option; Can you tell me what I need to add to this code so I have a blank option available in my list? Look...
  12. C

    add blank value to a combo box

    how do i do this union query?
  13. C

    add blank value to a combo box

    Hi I have several combo boxes that uses a table as its values. My last 2 combo boxes however need a blank value, which would be valid in this case. Can I easily insert a blank value to these combo boxes? Thanks
  14. C

    validation

    Hi Can anyone tell me how i can validate two combo boxes, so that a message appears if the values are the same? Both combo boxes contain text.
  15. C

    linking combo box problem

    Have now got this code for after update and oncurrent, however still not working for my comboboxes on page 2 of my tab control. hmmm frustrating. Any ideas?
  16. C

    linking combo box problem

    How do I do this?
  17. C

    Refer to Control within a Tab Control in VBA

    hmmmm....very strange :(
  18. C

    linking combo box problem

    JPaulo - The database is not quite what i want because i need that in page 2 of a tab control. Can you do this and send to me? Also please send so that I can see the coding. Cheers
  19. C

    linking combo box problem

    The code used to requery the event. Private Sub combobox1_AfterUpdate() Me.combobox2 = Null Me.combobox2.Requery Me.combobox2 = Me.combobox2.ItemData(0) End Sub In the row source of properties of combobo2 I have the below criteria in my query: [forms]![option selector]![combobox1] My code...
  20. C

    combo box

    row source - 10;20 row source type - value list bound column - 1 column count - 1
Back
Top Bottom