Search results

  1. S

    Argh! Disabled all menus in startup

    Thanks! :D
  2. S

    Argh! Disabled all menus in startup

    Argh! I disabled all the menues in the startup....how do I reverse this? :D
  3. S

    Open Reports with multiple Where Clause

    Excellent, works like a charm! You are the man, Bob! Thanks a lot! Doc, too, of course :)
  4. S

    Open Reports with multiple Where Clause

    And how do I build the statement? DoCmd.OpenReport "rpSystem", acPreview, , ??
  5. S

    Open Reports with multiple Where Clause

    I thought about the string thing, but I am not sure how to do it. When i build that string, how do I structure the where clause? Because I don't have a field then, if you know what I mean. And I just tested using a clause like "[clientname] ='" & Me.cboGAclientnames.Value & "'" and I get no...
  6. S

    Open Reports with multiple Where Clause

    Hi again! :) I can't figure this out myself.....so if anyone likes to help, I would be really glad! Ok, here is the problem: I got a form with 7 listboxes and a Command Button. Box1 chooses the report box2 the clientname box3 to 7 choose different variables depending on the choosen report...
  7. S

    seperating data by pages in reports

    I got the same problem but don't understand your answer :(
  8. S

    No Data Cancel Event

    I am sorry, but I don't get what you are saying... i am a novice to access :(
  9. S

    No Data Cancel Event

    Hi again :) I am stuck again..... I have a form where I can generate different reports with different variables. What will be quite common is that the there will be no report with the given variables. I did the "on no data" event with a msgbox and "docmd.cancelevent". It works fine but access...
  10. S

    Create Report from one column in different tables

    Now I get run-time error 2491 saying, that the action or method is invalid because the form or report is not bound to a table or a query :( I feel dumb :(
  11. S

    Create Report from one column in different tables

    Where do I put the WHERE clause? :(
  12. S

    Create Report from one column in different tables

    Ah, forget that, it updated to 2003 and now i can install the missing wizard. Could not do this last week with the older access.... I will try it out now, thanks :)
  13. S

    Create Report from one column in different tables

    No, when it looks like in your screenshot, i get a message saying: "Microsoft Access can't start this wizard right now. currently not installed..." I can use the report design wizard for example, but not this one.
  14. S

    Create Report from one column in different tables

    Argh! I don't have the wizard installed here and can't install it....that's bad :(
  15. S

    Create Report from one column in different tables

    Well, I understand this ID and name thing, but i have never worked with Access before so I am doing a lot of things wrong or bad, that's for sure ;) But i try to fix this one. But I have never done a subreport...how do i do this? Sorry for being so noobish :(
  16. S

    Create Report from one column in different tables

    Hi guys! Here is the scenario: I have several tables which all have a common column (client_name) and I want to do a report, which gives me all entries from all the tables which have a specific client name. I have, for example, a report with client details, a report with client activities, but...
  17. S

    Audit Trail

    Thanks for this wonderful utility! I really appreciate your work! But i have a 2 questions about it because i miss something: I am using unbound txtboxes and SQL Script to update my tables thru forms. This gives me 2 problems: The Audittrail record is always in the first row of the table and...
  18. S

    Access Crashes on Record Source

    It seems that the decompile thing worked! Thank you so much!
  19. S

    Access Crashes on Record Source

    Hi! I got a very ugly problem and can't seem to figure it out... I got a form with some underlying code and everything works fine. When I try to put in the Audit Trail and therefore want to use Record Source for the Form property and map a txtbox to the Audittrail field in the corresponding...
  20. S

    Hide/Unhide Form in a Form depending on Combo Box Selection

    No, i didn't :) Found the mistake...the " were missing...silly me ;) Thanks for your help Col!
Back
Top Bottom