Search results

Say I have an ADODB recordset with two fields in it called 'FirstName' and 'LastName'. I want to return the values into variables which is normally done as... strValue1 = rst![FirstName] strValue2 = rst![LastName] However, what I want to do is assign the field to retrieve to a variable also...

I'm in the UK. I have a linked table to a csv file, in the file I have a date in the format dd/mm/yyyy. When I view the date in the database window the format is displayed as mm/dd/yyyy. How can I view the date (via the database table view ) as dd/mm/yyyy. thanks, Matt.

using the below: SQL = "SELECT * FROM Criteria_Scheme CS WHERE CS.Value<>0 And CS.Position<>0" .ActiveConnection = p_CurrDBConn .CursorType = adOpenKeyset .Open SQL, p_CurrDBConn getting Method 'Open' of object '_recordset' failed. However if I paste the sql into a query and run it returns...

I've a listbox control on a form which has a sql query as the row source. The query returns 3 columns, ID, Name and value from TableA. A user multi-selects items from the listbox and can then click to save their selections; this inserts the selected information into another table - TableB...

Hi, I was wondering if there's any way of poulating a table in one shot, without looping, with the results of an ADO recordset? Something akin to the copyfromrecordset method for excel. ta, Matt.

Age old problem... Refreshing a sub form. I have a form in which a 'read-only' sub form is placed. The sub form is based on a query. I have a button on the main form which opens another form with check boxes which allows updates the to table. I want the readonly subform to refresh/requery...