Search results

  1. B

    Unticked VB References?

    Originally posted this in the Queries thread which was probably a mistake: http://www.access-programmers.co.uk/forums/showthread.php?t=104133
  2. B

    This will stump you

    The spaces are copy & paste errors. The query runs fine & does not take too long (less than 1000 records being interrogated). The problem is when I try to save any changes to this query, windows shuts down access. I'm able to save changes to other queries, just not this one. I've tried starting...
  3. B

    This will stump you

    Yup, tried all that. It does seem that I need to split the query down into more managebale chunks which is a pain cause all that time coming up with a once working expression is wasted.
  4. B

    Change Colour of Navigation Buttons and Command buttons?

    For the command buttons goto properties>format & change transparent to yes. Not sure what to do about the navigation buttons
  5. B

    This will stump you

    This will confuse: I have an expression... IIf(IsDate([dbo_ContactExtraVw]![X501_Date__c]) And [dbo_ContactExtraVw]![X501_Workshop__c]="Scheduled" Or IsDate([dbo_ContactExtraVw]![X501_Date__c]) And [dbo_ContactExtraVw]![X501_Workshop__c]="Invited",IIf(CDate([dbo_ContactExtraVw]![X501_Date__c])...
  6. B

    Conditionally suppress on a form

    Thanks Scott - appreciate your assistance
  7. B

    Conditionally suppress on a form

    Hi all Long time searcher, first time poster! I have a subform which has loads of check boxes for each record but i want to suppress certain boxes depending on criteria in each record. I think i need to do a For..Each statement but, as my user name suggests, I'm buggered!.
Back
Top Bottom