Search results

  1. T

    Union query missing various column data

    I am running a union query on two queries. Both queries have the exact same columns, both run perfectly well separately, showing all expected data. When running as a union: ELECT qry_POS_X_CurrentPO.* FROM qry_POS_X_CurrentPO UNION ALL SELECT qry_POS_X_E1_OrderQty_X.* FROM...
  2. T

    Import HTTP web text into string

    I am using a wep API to get some weather data. It opens a web page with a text string similar to this...
  3. T

    Using DateAdd with DLookup

    I can't seem to get this syntax correct trying to use DateAdd as criteria with DLookup. Here's what I think it ought to be: DLookUp("SumOfHours","qryDailyTotal","[WorkDate]=#" & DateAdd('d',1,gStartDate) & "#") with gStartDate being a date variable. However I get "Expected: expression" Where...
  4. T

    Trouble with a filter sequence

    I'm trying to get this filter to work with multiple ANDS/ORS and having trouble. The line is: Me.Filter = "([CustID] = 1030 OR [CustID] = 1044 OR [CustID] = 1051 OR [CustID] = 1055 AND [BoLChk] <> 'X' OR [INVChk] <> 'X')" The filters on either side of the AND work independently, but combining...
  5. T

    Requery a subform using a variable

    I'm attempting to requery a subform using a variable and running into "can't find form" errors. Here's code that works fine when run directly: Forms!frmDashboard!frmDwgStatusSub.Form.Requery But when loaded into a variable and trying to run via: Forms(gSendingForm).Requery throws an error...
  6. T

    IIF and wildcards for criteria

    Is it possible to use a wildcard in an IIF statement as criteria for a query? I want to check a field, and if it's null then use a "*" for the search criteria but I can't seem to get it to work. Here's an example of what I've tried: IIf([Forms]![frmDrawingLocator]![txtPN03] Is...
Top Bottom