Search results

Hi All, I'm having a wee problem with a form containing a DTPicker Control. It should display the date for a given record, as defined by the control source, however instead it seems to always displays the default date instead. Does anyone know why this might be happening? I have tried...

Hi all, I have a database from which I build a query to populate a table with data, and one of the fields is a user selected date from a calender control. The query looks something like this: SELECT SampleSite.SiteID, Format(#06-09-2006 11:42:19#,"dd/mm/yyyy") AS D_Date, "" AS UserID...

Hi there, I am trying to perform an INSERT into a linked Oracle Table, using the following code: INSERT INTO JTCS_OWNER_VISITS SELECT * FROM Visits; Seems simple enough, there are 10,000 records in the visits table, but when i try to run this query i get an error message that simply says...

Hi all, Quick question, and one that i think should have a simple answer. I want to run a SQL string within my VBA and analyse the resulting recordset, but I'm having problems. I can access the recordset in the following way: intCounter = CurrentDb.OpenRecordSet(strSQL).RecordCount...