Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Kennelbloke

  1. Kennelbloke

    Excel Unique-Filter issue

    I believe that this maybe something to do with Column G. On the Colours sheet, this value is numeric (right alignment of cell) and on the array returned it looks to text even though the column is formatted as a number. If that is the case then how would I fix this? UPDATE!! In case anyone...
  2. Kennelbloke

    Excel Unique-Filter issue

    Hi Folks. Just trying to get a bit Excel happening, not my forte, but can't work out why I'm having this issue So 3 sheets. Entries/Breeds/Colours I'm using the Unqiue/Filter combination to get the base of the data I want. With the Finction below in F1, I get the following What I'm trying...
  3. Kennelbloke

    Split Function not working

    Thanks Software RT, that was it. It seems strange that code pause on the error and debug returned the correct value, which to me says that the object was there. Wierd... Oh well on to finishing this up. Thanks for the responses guys and have a great day.
  4. Kennelbloke

    Split Function not working

    I have used this process many times before but I'm can't get this to work main form: (button click event) ... strSexVal = 2 DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenForm "frmPetDetails2", acNormal, , , acFormAdd, , Me!PetID & "|" & strSexVal frmPetDetails2 form: Private Sub...
  5. Kennelbloke

    Subform not updating in parent form

    YES!!!! That was it Duane. Thank you so much. Removed the Link Master/Child fields for the subform. One headache out of the way :)
  6. Kennelbloke

    Subform not updating in parent form

    Ok I'm back. Reading through the much appreciated replies the following applies. Affectively the prefixes on the left are just the filter for the subform. Every time a prefix is clicked on, the subform is requeried (i.e. Me!sfrmBreedersCats.requery) I have removed the BreederID from the query...
  7. Kennelbloke

    Subform not updating in parent form

    Sorry guys, have to do other things for the next few days will check your responses later and get back to you thanks so far
  8. Kennelbloke

    Subform not updating in parent form

    The user doesn't enter or edit data on this form. The form opens with the BreedersID from their details form. All I want them to do is select a prefix on the side to see which cats belong to that prefix. They can double click on the cat to open that record if they want. It works for one...
  9. Kennelbloke

    Subform not updating in parent form

    I have a form that has a subform attached that has some weird behavioural problem basically when I click on a Prefix field and using onclick and a requery it should update the subform. This works in one instance but not for others. When I open the subform on it's own it shows the correct data...
  10. Kennelbloke

    Access VBA Syntax Error

    Can you share the SQL behind the report?
  11. Kennelbloke

    Refer to Navigation Control Subform Record

    Thanks Duane. You got me thinking that I was heading in the wrong direction
  12. Kennelbloke

    Refer to Navigation Control Subform Record

    YES! got it to work. Not sure how elegant it is but it works for me. So... first off I created a public variable called TransID (integer) On the income field in the Balance form on any field I put this This takes me to correct form. On that form in the On Current Event I put the following...
  13. Kennelbloke

    Refer to Navigation Control Subform Record

    Ahhh... it seems you refer to them as tabs (with the tab property) anyway. I will keep playing
  14. Kennelbloke

    Refer to Navigation Control Subform Record

    It called a Navigation Control. Different from a tab control
  15. Kennelbloke

    Refer to Navigation Control Subform Record

    Looks like the video didn't go through
See more

Part and Inventory Search

Back
Top