Search results

  1. E

    Textbox Control Source IIF statement

    Thank you Mark. Yes, the room number is coming from the same table as the StartDate and EndDate and StartDateTime.
  2. E

    Textbox Control Source IIF statement

    Hope I did this correctly and that all the info you need is there.
  3. E

    Textbox Control Source IIF statement

    Comes back #Name? Maybe I have to format the dates?
  4. E

    Textbox Control Source IIF statement

    Thank you. it must have something to do with that because when I use just the time criteria (as you just gave to me) it works.
  5. E

    Textbox Control Source IIF statement

    Thank you pbaldy. It now shows#Name?. StartDateTime is Date/Time and I'm trying to select 8:00 AM.
  6. E

    Textbox Control Source IIF statement

    I'm trying to set the control source of a textbox on a form with the following: =IIf(DLookUp("[Room]","tblTEMPEventRooms","WHERE #" & Me.DateOccupied & "# BETWEEN [StartDate] and [EndDate]) AND [StartDateTime] =8")=122,1,0) But it gives #Error. Is it the quotation marks? [DateOccupied} is a...
  7. E

    IIf Statement in query

    Thank you so much arnelgp!
  8. E

    IIf Statement in query

    I was hoping to get the following (as examples): 1. If there are tables to be set up - 5 tables 2. If there are chairs to be set up - 50 chairs, theater style or 50 chairs, classroom style 3. If there are tables AND chairs - 5 tables, 50 chairs, theater style 4. If no tables or chairs - blank...
  9. E

    IIf Statement in query

    I have four fields in my table: [Tables] (integer), [Chairs] (integer], [TheatreStyle] (yes/no), [ClassroomStyle] (yes/no) and some may be null. Is it possible to nest these together using IIf in my query to display as follows: [Tables] Tables, [Chairs] Chairs, ([TheatreStyle] or...
  10. E

    Open form with where clause

    Think I figured it out...using DLookup instead of an SQL. Thank you
  11. E

    Open form with where clause

    If I'm using a SQL statement and saving the results into a string variable: DIM param as string DIM mySQL as string Dim stdocname as string stdocname = "frmReservations" mySQL = "SELECT....." param = Val(mySQL) DoCmd.openform stdocname, , ,"[RNOS] = " & param Get a 0 value for param. How do...
  12. E

    Open form with where clause

    Thank you so much!
  13. E

    Open form with where clause

    I'm getting a type mismatch error when trying to open a form: Dim stDocName As String stDocName = "frmReservations" DoCmd.OpenForm stDocName, acNormal, , , "[RNOS] = " & 4730 The field [RNOS] is a long integer. What am I doing wrong? Thank you
  14. E

    label caption

    Got it. Thanks!
  15. E

    label caption

    StartDate is a field in the record source of the report. I created a textbox and set the control source to =Weekday([StartDate],[vbSunday]) but it displays empty. What am I doing wrong?
  16. E

    label caption

    Can I display the weekday in a label on a report? If so, how? The record source for the report has a variable "StartDate" and I want to show the day of the week (Monday, Tuesday, etc) of this date in a label. Thanks much
  17. E

    Open report

    Yep, but it only gets it down to about 5.8
  18. E

    Open report

    I can't get the file down to the 2 mb limit for attaching.
  19. E

    Open report

    There is a filter because it opens the report will the filtered list. I'm trying to add something to the filter when I open the report and I think that's what's causing the problem. :banghead:
  20. E

    Open report

    I'm trying to add onto the open report command but having problems. I'm using the filter on a form to populate labels DoCmd.OpenReport "Labels_Contacts", acViewPreview, , Me.Filter & "and [Mail] = 'Yes'" and Access doesn't like this. I'm getting a 3075 error "Syntax error (missing operator)...
Back
Top Bottom