Search results for query: *

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...

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...

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

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]

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.

..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...

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.

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...