Search results

  1. R

    Crosstab or transpose query with multiple fields

    I have been trying to figure out how to transpose a query per a customer request (they want to read the information horizontally instead of vertically). But I am struggling with the Crosstab query in access. Is there a way to transform the below data: Week Order Calendar Week LDOW Previous...
  2. R

    Data type mismatch in criteria expression for opening a recordset

    I'm trying to fix a code that was working the last couple weeks but suddenly stopped working. I have a form with a cells that fire actions when the user double clicks. So, out of no where, I am getting this error message regarding the below line of VBA: Set rs =...
  3. R

    Sorting in access queries

    I have a query that only has 4 fields: SalesOrder, SalesOrderID, FabSO, and PODate. When it is sorted by PODate it sorts as shown below: qryUniqueSOFromtblTempFabReq SalesOrderSalesOrderIDFabSOPODate SDR0493443FAB0225/13/2025 SDR0503444FAB0225/13/2025 SDR0513447FAB0225/15/2025...
  4. R

    2424 or 2450 error

    I have the below code in a subform. The code works when I open the subform directly by itself. But it gives me a 2424 or 2450 error when I open the parent form. I've tried a bunch of different ways of referencing the control (cboFinishID) but I keep getting the error message that Access...
Back
Top Bottom