Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Zequel

    Memofield in SQL Server causes ODBC error

    Though I haven't seen your specific problem, I have had problems with Memo/Text and BLOBs fields. Sometimes BLOB fields create a problem with the field delimiters databases use to return results at some level (I haven't seen the raw data, only the problematic results). There are two workarounds...
  2. Zequel

    Dynamic Queries

    After years of dealing with Access queries, I've found, sometimes, the best way to set query criteria is with a custom function. Let's say we have a query that needs a beginning date that's stored in a table that's called tblReportCriteria. All I want is that one date (the table is a single-row...
  3. Zequel

    RE-POST, Please help if you can.

    Or you could change the form's recordsource to nothing. Then change it each time criteria is determined using formname.RecordSource = "SQLStatement".
  4. Zequel

    Multiple record Insert from 1 table to another

    At first glance, this doesn't appear to be a correct join. I would change your statement to: Update Vehicles INNER JOIN RegiAirCare ON [Aircare_2001_Matched].[LPRPlate] = [Vehicles].[LPRPlate] SET [Vehicles].RegiAirCare2001 =[Aircare_2001_Matched].[Registration]
  5. Zequel

    access data in subform according to its place

    Have you used recordsets? I'd recommend opening a recordset in either DAO or ADO, make the changes you want and then refresh (.requery) the subform so it shows your changes.
  6. Zequel

    ORDER BY error?

    ..am using an Order by with the update becuase the page that gets updated has fields that can be ordered by. I don't want the order to change when the page gets updated. WHAT? I recommend any good book on SQL before you go any further. Stored orders of records in a database are not...
  7. Zequel

    getting text files from Access

    You can't access object/OLE fields the same way as normal db fields, they are what we call BLOBs, and use the rst.GetChunks() method. A search at msdn.microsoft.com may prove helpful.
  8. Zequel

    Stored procedure fast on backend, but slow to display on web page.

    The problem is concatention, this is why MS created a new class called StringBuilder in .net. Unlike a integer value whereas when you change it you merely change the value of the memory address where it is stored, a string is an object and is IMMUTABLE. If you change the object's value by...

Part and Inventory Search

Back
Top