Search results

  1. T

    Create Query in ADO

    Solved:Create Query in ADO I am trying to create an ADO create query since I don't have access to DAO anymore due to an system upgrade at work. Access is telling I don't have ADODB loaded into my system to run the create query. Any suggestions on what reference I might need? I have loaded...
  2. T

    Small Macro problem

    Thanks so much! That did it.
  3. T

    Small Macro problem

    Really could use the last bit of help here. I cannot seem to figure out what is giving that Expected 1 error. The error only seem to happen with the export module added, but I cannot see what is causing. I am re-posting the test access database with the export module added.
  4. T

    Small Macro problem

    A. I don't need to disable it, it goes though even without it disabled, but when it is disabled I don't get any error. B. Yes C. Yes D.No Public Function SendTQ2ExcelNameNewSheet(strTQName As String, strSheetName As String, strWorkbookPathAndName As String) ' strTQName is the name of the table...
  5. T

    Small Macro problem

    Well i added in my function, changed the info in your table. I get an error Too few parameters. Expected 1
  6. T

    Small Macro problem

    One last thing to fix. I have the same text area in my Call line, VBA keeps thinking it is something other than text. How do I fix it?
  7. T

    Small Macro problem

    Thanks that worked.
  8. T

    Small Macro problem

    The Sale_Area is a text field
  9. T

    Small Macro problem

    SOLVED:Small Macro problem I am running trying to run this vba , but it errors @ the red print in the code and gives the following error: Runtime error '3075': Synteax error(missing operator) in query expression 'Sale_Area = WARM MIDDLE'. Warm middle is a name of area in my query. VBA...
  10. T

    Update Query problem

    You know I did not think of that. Daily Change only has 10000 records in it currently, so it would max out at daily changes record limit. I could do it that way. Well it should only end up being about 6 - 7k coming back realisticly.
  11. T

    Update Query problem

    No, it will surpass the 2GB limit of Access. Over 7 million record there.
  12. T

    Update Query problem

    I guess you are right, but why does it work locally without any PK or indexing? Permission problems or ODBC problem? Never mind. You have done what you could me. I guess it just will not happen until my company changes its database policies and does them the right way.
  13. T

    Update Query problem

    No, DW_PRICE is non-index with no primary keys. Sorry about the ODBC thing. I assume since that I said that is was AS400 table, people would think ODBC. I guess not.
  14. T

    Update Query problem

    Looks like the UPDATE query works fine if it a local table, but no when it is the AS400 table (DW_PRICE is an ODBC connected table on the primary database).
  15. T

    Update Query problem

    OK, I attached a sample database. I hope it works like it does here.
  16. T

    Update Query problem

    I would but I don't think my company would be very happy if i did that. Plus I would need to strip down a 1.5gb database and you would need to simulate a a/s400 database connection that would be not so easy to do. It is the AS400 part that is giving me the problem.
  17. T

    Update Query problem

    I can update the field in the select, but I need to "clear" the fields first then I can manually update them. If I rerun the query, after I manually update the field, I cannot change the field again, until I do a "sort select to cleared" on the Added field, and then I can update the field...
  18. T

    Update Query problem

    Would the fact that I cannot update DW_Price (no permissions - A/S400) have anything to with that I cannot update an unrelated table(Daily Change - local table)?
  19. T

    Update Query problem

    If I add those joins field to the select statement then I am sure about what is going to updated. Yes, if I go by a count of the amount of records to updated then yes, it does display what I think is the correct amount.
  20. T

    Update Query problem

    I forgot to mention that Added is currently null
Back
Top Bottom