Search results

Hi Gemma, Thanks for the response. The DTPicker control is bound to a field called d_date in the table in question, but upon further investigation it seems to be an anomaly of the control. I found that once I move to the next record the date updates to that of the record, and even when i now...

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

Thanks, did figure it out in the end, it was just a crappy data problem!

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

Thanks guys, seems the problem i had before is that i simply couldn't find the references menu item! All working great now. One last question though, if you use currentdb.openrecordset without assigning it to a recorset variable, does it drop the recordset directly after it is used?

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