Search results

  1. C

    Add Field Total

    I think you need to be in design view, not layout view to do it.
  2. C

    Counting multiples of hours

    Maybe try Select Case? me.Points= IIF([fieldNumberOfHours] > 15, 5, IIF([fieldNumberOfHours] > 12, 4, IIF([fieldNumberOfHours] > 9, 4, IIF([fieldNumberOfHours] > 6, 3, IIF([fieldNumberOfHours] > 3, 2, 1))))) Select Case [fieldNumberOfHours] Case Is > 15 Me.Points = 5 Case Is >...
  3. C

    Unbound combo box does not display assigned value

    Maybe you need to Requery combo box after you assign new rowsource? Me.cmbMyUnbound.Requery Just a thought.
  4. C

    Opening af file when clicking yes in msgbox

    Get rid of quotes around sFileName and you're good. Shell "excel.exe " & sFileName , vbNormalFocus
  5. C

    Access 'Compact database' = festival of suck

    The_Doc_Man - please read my post again. I also don't store OLE objects, I store links to them only. And I display those linked pics on forms and reports and that's it, they're never stored (at least by me, because Access does as he pleases). Apparently every time a new object is displayed on...
  6. C

    Access 'Compact database' = festival of suck

    Actually I can see it happening in one of my databases too. FE after few days of use grows from around 4MB to 180MB, simple compact and repair doesn't change much (it goes down to around 150MB) but I know why. Access "caches" pictures that I display on forms and reports, pictures that aren't...
  7. C

    ComboBox show text value and query result ?

    It can be, but you need to change row source to something like this (assuming your original source was YourQuery and year field was sYear): SELECT YourQuery.sYear FROM YourQuery UNION SELECT '(All)' FROM YourQuery;
  8. C

    OPening Word doc from button

    It's there:
  9. C

    Email prompt to enter an email address

    Dim strAdditionalEmail As String If Me.cbAdditionalEmail Then 'if your additional email check box is ticked then strAdditionalEmail = InputBox("Please provide email address") 'open input box to provide email End If 'then do something with provided email address
  10. C

    Count Query

    I guess you're trying to mix different things. You are showing me properties of some combo box on form. DCount requires criteria referencing fields in table. Is there a field named [Work Complete] in work_items table? If so - what is its data type?
  11. C

    Count Query

    What type is [Work Complete] field? Is it text or maybe Yes/No field? If Yes/No then try this: DCount("[Department]", "work_items", "[Department] = 'Sales' And [Work Complete]=0")
  12. C

    Count Query

    DCount("[Department]", "work_items", "[Department] = 'Sales' And [Work Complete]='No'")
  13. C

    Count Query

    DCount("[Department]", "work_items", "[Department] = 'Sales'")
  14. C

    Expression problems . . . . .

    iif([AntPerc]="0",....... should be iif([AntPerc]=0,.......
  15. C

    Message Box Problem

    Change it to: If Me.Status = "74" Or Me.Status = "33" Or Me.Status = "8" Or Me.Status = "7" Then Or Select Case Me.Status Case "74", "33", "8", "7" MsgBox "This Case Has Been Closed!", vbOKOnly, "Case Closed Alert" End Select End If
  16. C

    Split Form Attributes

    Ok, I misread your post then, sorry. I think you can change some properties of datasheet part in Form Load event only, like: Me.DatasheetAlternateBackColor = RGB(0, 0, 0)
  17. C

    Split Form Attributes

    First, you need to be in Design mode - RMB on your form in Navigation Panel on the left and choose Design View. In Design View Alt+Enter (or click on "Property Sheet" button on Design tab of ribbon) opens property sheet and that's where you set up objects properties.
  18. C

    Limiting RowSource in ComboBox (Access)

    try: Me.CollName.RowSource = _ MsgBox "SELECT CollPerf.Colleague FROM CollPerf WHERE CollPerf.Colleague LIKE " & Chr(34) & strText & "*" & Chr(34) & ";"
  19. C

    Rounded up

    - Int( - [YourField])
  20. C

    Date Conversion From Yyyy Mm Dd Hh:mm:ss (with Space) To dd/mm/yyyy = Date And hh:mm:

    I'll copy/paste my answer from other forum: I doubt they ever worked, unless ValDate and Seconde were custom functions. First, you shouldn't use reserved words (date, time, name, etc.) as object names in Access. It will work in this case, but may cause trouble later on. Anyway, some mistakes I...
Back
Top Bottom