Recent content by MaximusArcher

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.

Never mind - have found it out. Was using SQL-92 reserved word in sql string. compiling the sql as... SQL = "SELECT * FROM Criteria_Scheme CS WHERE CS.[Value]<>0 And CS.[Position]<>0" ...works just fine.

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

Yes it's possible and there are endless ways of doing what you describe. One solution would be to have a users table containing name and surname and any other relevant information, in your case, the name of a form. Create a login form to query the user details when they enter them, if they...

Problem solved. I added an extra column in TableB to hold the relative position in the listbox.

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.

The functionality you describe is better suited to a class module. Put all general functionality into a class, then set the indivdiual properties within the class. For example you could have a property that could be set to reference the form in question.

Use validatino to check the record fulfils certain criteria i.e. a value exists. If the validation falis end/skip/goto error handler.

I dont understand why that would of helped? There is no code being executed on the main form once the second form is opened.

av u tried a seperate query based on the forms current record then hang the merge off this query?

I had a problem similar to this - have you tried re-setting the recordsource prooperty then requerying?

Thanks guys. Coded up the a close button in the end. Bit wierd that the close event on the form wont mimic the same behaviour. Didn't go with the close main form, open new form because the main form is based on a recordset - too much messing round with remebmering recs etc. Cheers though...

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