Recent content by cwilson30341

  1. C

    Update Dates from Form

    I really appreciate your trying to help. I thought this would be pretty simple and was just something that I was overlooking. Chris
  2. C

    Update Dates from Form

    Unfortunately, the final table must have Date as the field name as that is how the Ab Initio Developers want to see it when it is loaded. The query above is a (i think) Cartesian join. It takes the COF data and adds a date to each record. then it kind of loops and does it for each date. The...
  3. C

    Update Dates from Form

    Basically, the COF_TABLE_BASE data will not change, has 44,506 records, and has the following fields: Product Min Rate Max Rate Avg Rate Min Term Max Term Avg Term COF Base RateLock Prepayment Using the base table and the date table, I create a COF_TABLE with: INSERT INTO COF_Table ( Product...
  4. C

    Update Dates from Form

    The dates are used in a query to add dates to a standard set of criteria (in another table). If there is a better way to do this, I have no issues changing it.
  5. C

    Update Dates from Form

    Hi all, I have a table that contains seven dates that are used to update another table (didn't know how else to to it). On my form, I would like to have the user enter a begin_date, click a button, and update the table with the begin_date and the next six days. I have tried to do this with a...
  6. C

    What is causing this error?

    Thanks! That showed me what was wrong. Missing data in the table. Chris
  7. C

    What is causing this error?

    Hi all, MS Access 2003. I got this from a consultant a few months ago and it isn't working correctly. Unfortunately, he is no longer with the company and he was the brains. Sub FTP_Calculator() ' Declarations Dim iMonth As Long, iInterpMonth1 As Long, iInterpMonth2 As Long...
  8. C

    Update From One Table To Another

    Hello all - I am reletively new to Access and this one has me stumped. I am trying to update records in one table with info from another table and it is not working. A few folks that I have shown this to say it should be working fine. Here is SQL: VBA: UPDATE [RO Data] LEFT JOIN...
See more
Back
Top Bottom