Search results

  1. wiklendt

    Formula Error - Constants

    can't tell how to help you from that description. if it is a bug in excel, have you tried searching for a hotfix form microsoft? is your excel program up-to-date with service packs and updates? if not a bug, what is your formula? what do you expect to happen when you copy it (write out the...
  2. wiklendt

    Combo box does not update on a split form

    i think i also have to mention, because it might not be obvious - avtuvy, if you are building this database for others to use (network, commercial, other) you have to be aware of what will and won't work in previous versions. split forms, like missinglinq says, was something introduced in...
  3. wiklendt

    Formula Error - Constants

    when you copy a formula to a different cell, the formula updates any references to the changed location. e.g., in cell A1 you create a formula which look like: =A2*10 if you then paste the cell A1 to B1, the formula will automatically update to: =B2*10. is this what you mean?
  4. wiklendt

    Combo box does not update on a split form

    value lists are problematic and limited. i would urge you to make this 'value list' a separate table called tlkpYourValueListName (including primary key ID and values) and then use a query of that table as the control source. you will then be able to manipulate, update, change, select to your...
  5. wiklendt

    Cascading Combo Boxes with Satellite Data

    what you want is certainly possible. if you followed the tutorials but it still doesn't work, then we'll need more of a description of your actual scenario - or better yet, your db posted here (with some advice on which form and combo is the troublesome one).
  6. wiklendt

    Can't create a one to many relation

    just a tip - your PK and FK should have the same name in all tables they appear in i.e., HuisgenotenID (PK) = HuisgenotenID (FK) NOT HuisgenotenID (PK) = HuisgID (FK) based on PERSONAL EXPERIENCE, naming your PK/FK the same will save you MUCH FRUSTRATION as your db project grows and expands.
  7. wiklendt

    Can't create a one to many relation

    could you please translate the two words? access might not let you create the relationship you intend because perhaps i can't be done that way. e.g., tblMuseums and tblMaterpieces - you can have one museum with many masterpieces, but not one masterpiece in many museums (discounting replicas...
  8. wiklendt

    Count null record

    why don't you count a field that isn't null from that query? it will still group by ID...
  9. wiklendt

    Need help creating/generating 5-page report

    can't really determine that from your description. my gut feeling tells me you probably haven't normalised your data properly. are you able to post a (sanitised) version of your database here? (with a brief description of which report it is that you're having trouble with - some people post...
  10. wiklendt

    Update multiple text boxes in a report from a single table field

    people's inspection dates actually have nothing to do with the people themselves. normally, all you'd expect in a people table is stuff like primary key, first name, surname, eye colour, phone number, address... etc. then you ought to have an inspections table, with primary key, foreign key...
  11. wiklendt

    Need help creating/generating 5-page report

    i have generated reports that are hundreds of pages long. the first thing you need is to base your report of a query, which is made from good, normalised tables. the second things you MAY need, is to use SUBreports. that is, make a query based on your cities. then make a report based off that...
  12. wiklendt

    Need help creating/generating 5-page report

    yes, there is an easy way to do it in 'one' report. any other questions?
  13. wiklendt

    Select Combo Box Item by index

    OMG - ALL that code in a "not in list" event and Mage-7 thought it had nothing to do with the problem??? LOL it's going to take a little while to go through all that....
  14. wiklendt

    Tranfertext Error

    ah great - glad you fixed it. i didn't even notice it! good work. :)
  15. wiklendt

    Select Combo Box Item by index

    that's a neat trick boB!
  16. wiklendt

    Select Combo Box Item by index

    is that czeski?
  17. wiklendt

    Select Combo Box Item by index

    could you please re-post your code using the code wrap? i can't read it like that.
  18. wiklendt

    Tranfertext Error

    have you tried throwing in a message box with the path displayed, to see if it comes up fine? it's a trick i use when i'm attempting to pass compound variables...
  19. wiklendt

    Manage Multiple Small Lists

    you seem to have used a codec that is proprietry (g2m3) for the video. i've tried installing the codec from here, but i cannot get any video feed, only audio...
  20. wiklendt

    Question Access 2002 Export Problem

    are you sure it's not just dbase IV that is limited to 5 decimal points? just an idea...
Back
Top Bottom