Search results

  1. R

    Using a combo box to change a field in a table

    I will try and be as brief but as descriptive as possible. I am writing a DB for my friends and I to use for our fantasy hockey league. All the tables and calculations are done. I am not designing forms, but this is where I get stuck. I get daily stats which I format in excel and import to...
  2. R

    ctl array and left() function

    I have a form with mostly combo and tect boxes. Most texboxes sahre a common naming convention for example PREVGP1, PREVGP2....... I wrote a for next loop that will look for textboxes that begin with PREVGP for exmaple so here's what I have, what I believe to be write but obviously is not...
  3. R

    IIf vs Switch

    I am writing a query in my DB. First I take two values from a table and divide them by each other. Based on the sum a certain value will be added to another column depending on the value range this new value falls between. Here's where it gets tricky for me. If both of the original 2...
  4. R

    Code for checking table fields

    Been a while since I coded. Can someone help me with: I am coding a button to check a particular field on a table. I have my connection and recordset in place. sp is the variable for my recordset for my table. The field on the table is Sales Person. I am starting from the first recod...
  5. R

    Macro cannot run more than 20 times

    I have seen other people out there with this issue and the answer generally is why do you even need that many macros. I think my situation is different so allow me to explain: I am in the IT dept for a car manufacturer. We have 65 dealers associated with us. Each week I pull an excel...
Back
Top Bottom