Recent content by Stefan.Kauw

  1. S

    How to display a list based on the result of two searchcriteria

    Hi! I've struggeling a bit for a while now.... We have a big list of activities with different people responsible of executing these activities in a certain week. You'll probably get it already... I'd like to search for the responsible and a certain week to display a list of the tasks meant...
  2. S

    'AOIndex' is not an index in this table

    I've uploaded a screenshot of the error. The direct translation is: "ID Is not a index in this table". Meanwhile i'll search through the links you gave. Thanks a lot :)
  3. S

    'AOIndex' is not an index in this table

    Unfortunately nothing works. I made a back-up already of the faulty file. Anyone interested in trying to fix it? I'm out of ideas.
  4. S

    'AOIndex' is not an index in this table

    The front end won't open correctly. I'll try compacting from BE this afternoon. Thanks for the advice so far. :)
  5. S

    'AOIndex' is not an index in this table

    I'm feeling dumb.... can't seem to achieve that. ACCESS needs me to open the file. I dont see the info tab that the manual is refering to. Using the windows CMD to say /compact to the database doesn't work either. It just tries to open the database.
  6. S

    'AOIndex' is not an index in this table

    I'm sorry, what do you mean by BE and FE? :o
  7. S

    'AOIndex' is not an index in this table

    Hi Guys, Anyone know how to fix the " 'AOIndex' is not an index in this table" error? This stops all the work on the database. Fortunately enough i split the GUI and physical database. The problem is in the GUI. Not sure why it occurs since i was only doing simple vba programming without...
  8. S

    Input not seen as value before pressing enter-key

    I was thinking about that already but why is it that i have to do it this was? There must be an explanation, right?
  9. S

    Input not seen as value before pressing enter-key

    The textbox is not bound to any source or table.
  10. S

    Input not seen as value before pressing enter-key

    When i enter a value in a textbox, this value isn't instantly available in VBA as a value. If i set focus to another textbox by clicking in it and want to msgbox the input of the textbox i get the error "Unvalid use of null". I DO have to press enter to somehow acknowledge the value inside the...
  11. S

    Single column header and footer

    Thank you for your reply. Unfortunately this is usefull but not the solution to my "problem". Please see the attachment. Maybe this clear something up.
  12. S

    Single column header and footer

    Hi all, Can't seem to find the option or a work-around. For our company we need standardized footers and headers which should almost always be the same whatever the editor it is made in (word/excel). Is there any option of getting a single column header and footer? Excel forces me to use three...
  13. S

    Query runs twice while only activating it once

    Any chance of getting a clear description of how this works? Like a example database with explanations? I'm not bad at English but English isn't my primary language which sometimes makes it hard to understand.
  14. S

    Query runs twice while only activating it once

    I'm not really sure but i'll try to explain. I'm filling a couple of boxes using dlookup which didnt work when bounding it. And for some kind of reason i didnt get a new record everytime. Got tired of it and tried to do it like this. Now it works :)
  15. S

    Query runs twice while only activating it once

    Private Sub Knop59_Click() Dim Partijnummer As String Dim Behandeldatum As String Dim Behandelbeurt As Integer Dim Norm As Integer Dim Doseertijd As Integer Dim Doseerhoogte As Integer Dim Plasticsoort As Integer Dim...
Top Bottom