Search results

  1. C

    DCount criteria issue

    agh, no I hate those multiple "'s, so confusing in a single glance as to whats going on, esp near the ends of strings. I use the ' or chr(34) method.
  2. C

    for beginners: cascading Combo boxes

    ah of course, damn mornings:) That method you mentioned is the one I tend to use anyways, as it's obvious if the data and tables are right.
  3. C

    Use VBA to CREATE a report

    You can change the reports recordsource in the code behind the report, if that's what your after? But creating the whole report, not easy...maybe you could create a set of reports and then code could pick the one most suitable to the query you create.
  4. C

    for beginners: cascading Combo boxes

    The first example is a bit daft, but they do get it right in the 2nd example don't they?
  5. C

    DCount criteria issue

    best way to start is to setup a variable to hold the string. so in your example: Dim sTemp as String sTemp="strSupLast Is Null Or strSupLast<>" & "'" & DOSETTE & "'" varLabCount = DCount("lngPtId", "qryDispLab", sTemp) You could then pause on the last line and do a ? sTemp in the debug window...
  6. C

    Self-building database

    query's and tables you can 'create' from a suitable script, I've done this before. forms, reports and modules I don't think so, so you would have to create an 'update' db that contains the new objects, and then a script could import these across accordingly. It would be a lot of coding and...
  7. C

    Unbound status bar

    use the optional keyword. ie myfunct(param1 as string, optional param2 as variant) they have to be variants, and the last paramaters in the definition. You can then use IsMissing(paramname) to check if it was passed or not.
  8. C

    Run Time Error 13 - Type mismatch, Something to with Date??

    probly the #'s, the parse finds those and gives them to whatever actually does the between...although it can't be parseing 'between' based on the full word can it, maybe it only looks for part?
  9. C

    Trying to update the records in a continuous form

    I'd guess its the recordset clone thats changed behaviour, but I can't say more than that. I'd rewrite it as long as you have an field which you can order by (which I guess you must have) then the SQL idea will work, now and forever:)
  10. C

    DCount criteria issue

    Is DOSSETTE a variable or not? If it is and its a string then you've got the critera right, if its not then use uncle-lai's 2nd example.
  11. C

    Trying to update the records in a continuous form

    use sql? SQL would look like: UPDATE Table SET Field=NewValue; Then you could refresh/requery the form. mmm, you might need a WHERE IDField>CurrentID on the end of the sql to make sure it only applies to later records. If these records don't exist and you want the defualt for new records to...
  12. C

    remove application scrollbar

    couldn't you override the resize event of the form, forcing it to remaximize? however I would advise against this, people expect certain behavioural traits from windows programs, I would make sure your program/UI still works in what ever situation the app could be in, rather than to force an...
  13. C

    Checklist How-to

    arse, attachement fails...damn unintelligent security software.] I'll have to upload the example from home tonight. Try This
  14. C

    Checklist How-to

    Hopefully the attachement works! Just run form1 pick one and press the button. If not then: You need the reference to MS Common Controls (I used 6) and obviously a ListView with the checkboxes property set, and using report view (this is to make sure you can resize the columns so that the text...
  15. C

    Checklist How-to

    I think this is gonna work...bit hard to write the code though as intellisense is dead for the listview.
  16. C

    Checklist How-to

    I did think of doing that...but as you say it seems inefficent. I'm looking at using the listview control which can have checkboxes. The idea being: 1) Fill the listbox from the tblChecklist 2) User ticks whatever boxes they want 3) Save the ticked items into the tblJobTasks (but you don't need...
  17. C

    Checklist How-to

    How-to: Checklist display/storage I have a fixed checklist of steps, I want to store which of these steps have been completed. However on the form view I need to see all of the checklist steps. I'll have my tblCheckListSteps and a link table with id's for the main id and which checklist items...
  18. C

    Select first item in combo via code.

    being a bit braindead, I can't remember how to select the first item in a combo box on an access form...I keep going back to normal vb which don't work:(
    • cable
    • Thread
    • Replies: 1
    • Forum: Forms
  19. C

    How can i do this?

    This will not be easy, as there is not a simple search all function. So you'd have to build up the results of many searches, ie you search one table, save the results, search the next etc. however these might be useful: http://www.mvps.org/access/modules/mdl0056.htm...
  20. C

    Subreport Issue

    I've got a simple report listing hours worked, and a sub report listing non chargeable hours. (The reason for the split is because the report should only total the chargeable hours, and the NC stuff has to be obviously seperate) The problem is that if the main report is empty, Access doesn't...
Back
Top Bottom