Search results for query: *

thanks

thanks, I will provide a better response next time. Thank you again for your help. Any news on WHY this was happening? Toby

DONE IT!!!!!!!!!!! thanks I altered the Insert into to get rid of the error and I now get the correct date at the other end. Thank you for your patinece I do not understand really what is going on, why it changes, from 01/11/2009 to 11/01/2009, but tthankk you Toby

sorry! Thank you fopr your patience. I have put it into the sql, I now get a Syntax error in INSERT INTO statement, (sql below) I do not see where else it should be put, ''''' ...PricesEHT.TestedAt, #" & Format(datDate, "yyyy-mm-dd") & "#, AS datdat" ''''''''''' the result sql is ''''''''''...

I have put it in the SQL EHT_AutolabWork.[WSL COST], PricesEHT.TestedAt, #" & datDate & "# AS datdat" But get 11/01/2009 if i put it in the GetMonthTDL function it errors as it is a string? is this problem to do with American and UK dates?

I have tried putting '#' at each end. i.e ...[WSL COST], PricesEHT.TestedAt, #" & datDate & "# AS datdat" this returns 11/01/2009 if i take the # out I get 13/12/1899!!

This gets the date from a table record '''''''''''''''''''''''''' Function GetMonthTDL() Dim db As Database Dim rstPathTDL As DAO.Recordset Set db = CurrentDb Dim PathTDLDate As Date On Error GoTo err_norec Set rstPathTDL = db.OpenRecordset("Pathdata_TDL", dbOpenSnapshot) 'query with records...

Thanks, can you help a little more... There must be a simple way to do this but I can't find it. The date is being passed and inserted into the sql statement, how can I format it to #2009-11-01# without changing it into a string? Any help much appreciated Toby

Hi PHV, sorry for the delay I have been away. Thank you for your help I am still getting an issue with the date turning up at the other database in american format month date year rather than english format date month year. The datDate used in the sql is got from a date field of a table. it...

sorry about my dimness, i see what you are saying. the data is collected via a date field from a table, eg 19/11/2009 I am trying to get this to change to first daay of month, eg 01/11/2009, in doing sso I messup up and passed text!! I will look for a function to change the date to the First...

Hi Thanks for the response I must be a little dumb, can you explain with more detail? I have tried the following formating datDate = Format(datDate, "yyyy-mm-dd") as Skip said, but it still comes out as 11/01/2009 (11th Jan 09)

within your code, get it to check if there is data in the two date fields, if not get it to return null

Tried that(Format(datDate, "d/mmm/yyyy")), but got 30/12/1899!!!!!!!!!!!

I am runnning an INSERT SQL with IN into another database I am having trouble with date format The date the sql is getting is 01/11/09 (1st Nov 09) (this shows correct in the Immediate panel) when the data gets to the other database in comes in as 11/01/09 (11th Jan 09) how can i get this...

sorted the SYntax get 'can't find tbl_TurnAround1 (this is the table i am trying to put data in INSERT INTO tbl_TurnAround1 ( TestCode, CodeDesc, CntCode, SellPrice, who, [where], ReqEntRsltAvgTA, ReqEntRsltMaxTA, ReqEntRsltMinTA, RsltEntAuthAvgTA, RsltEntAuthMaxTA, RsltEntAuthTA...

i get an Sytax Error in the INSERT INTO statement, can anyone help? INSERT INTO tbl_TurnAround1 ( TestCode, CodeDesc, CntCode, SellPrice, who, [where], ReqEntRsltAvgTA, ReqEntRsltMaxTA, ReqEntRsltMinTA, RsltEntAuthAvgTA, RsltEntAuthMaxTA, RsltEntAuthTA, ReqEntAuthAvgTA, ReqEntAuthMaxTA...

got it, link table in B to A, use append query in A to fill the linked table in B Thanks

I mean EXPORT not Axport :-(

Hi Is it possible to export a query result to another Access database or pull an Access query result into a Access database? any help much aprreciated Toby7

Hi I am trying to change the primary keys on a table I have two fileds set as primary Keys, I want to drop thease keys (keep the fields) and set a new single primary Key (auto Increment) I have looked on the web but without any success, this must have been done by someone somewhere, any help...