Search results

  1. C

    Build a recordset with no underlying table

    Splitting the database isn't an option due to deployment issues for the client. If they have their own copy on their own computer and can move it to the gods know where then releasing a new version becomes a problem. All the users are accessing the same file. I think the best solution so far...
  2. C

    Programatic parameter query based on parameter queries

    How lame. Yeah I noticed lots of nice things ADO can't do that DAO can, such as querydefs and parameters are much easier in DAO. Oh well, I got it working in ADO, I'm not going to go break it now.
  3. C

    Programatic parameter query based on parameter queries

    I got it working. Storted parameterized queries in ADO are a bitch.
  4. C

    ADO, VBA, and ms access 2003

    <connection>.Execute is only for action queries. Such as Insert, update, delete. Not select. you need:rst1.Open "qrySortTimes", cnt and you may need to specify some of the additional optional arguments to the .Open method.
  5. C

    Build a recordset with no underlying table

    Here are the tables: Source table: Field1, field2, ...., Field6 new recordset: Date, Field1, Field2, ... Field6 Where Date is generated in the program (in a For loop) and appended to each row from the source table into the floating (no underlying table/query) recordset I can't figure out how...
  6. C

    Build a recordset with no underlying table

    I want to open a new (blank) ADO recordset and put data into it from another recordset and a field whose data will be generated programatically. I don't want to build the data into an actual table as this creates exclusive locks on the table (one user only). Is there any way to do this? The...
  7. C

    Programatic parameter query based on parameter queries

    I'm doing this programatically. The query works as a saved query, that's not the issue. I think I got it working using ADO command objects (long, involved and messy seeming), but I'm not sure yet.
  8. C

    Concatenating fields from multiple rows

    As near as I can tell this is a row level manipulation and will require VBA unless you just want a report. Queries operate on Fields/Columns, if you need to do stuff based on records you need VBA/stored procedures. BTW a report would look something like this: footlocker...
  9. C

    DIM dbs as database (missing reference?)

    My guess is you've got ADO listed as a reference above DAO. So when you declare your recordset it's making an ADO recordset and you're trying to shove a DAO recordset into it..which won't work. Be careful, if you have both ADO and DAO listed in your references the one listed first takes...
  10. C

    Maximum by date

    SELECT ID, Format(MonthByNumber,"m") AS Month, Max (HighestValue) AS Maximum FROM myTable GROUP BY ID, Format(MonthByNumber,"m"); I think this only works in access (not portable to other DBMSes) due to the Format() function. This will also run slower than a query without the Format() function.
  11. C

    Programatic parameter query based on parameter queries

    I have a join query I need to run that takes in two parameters (startDate and endDate of Type Date) and it pulls two of its fields from two other parameter queries that use the same parameters. If I execute this as a saved query from the database window it works flawlessly. I'm assuming it...
Back
Top Bottom