Search results

In my VBA application access 2007 I used to work with SQL-DMO. This no longer supported by Microsoft so I have rewrite everything to SMO. If I try to add the microsoft.sglserver.smo.dll from the sqlserver 110 sdk assemblies dir in the reference I get an error: can't add a reference to the...

Thanks you very much Gemma and Moniker. You both forced me to think and pushed me the right way. With regards, Lodewijk

Gemma your tip set me on the right track. I found on the safari.oreilly.com that to use cdec the var has to be a variant instead of a double I used.

I forgot the result strsqlcuttime="20080226083030" cbltimestamp=2,0080226083030E+15 And I want 2008022608303000

Thanks for your reply. This timestamp is already created by a foxpro database. I only query the table with the timestamp. The timestamp is already there. I tried to create the same timestamp. How do I change it into decimal. This is the code I created dim varcuttime variant dim cbltimestamp as...

access 2003 sp3 os xp I want to query a table which as timestamp with 16 digit. With serial I made a timestamp but it looks like 2,0080221194445E+15. I declared timestamp as double with long I get a overflow. If I use this in my query in vba it doesn't except a comma. If I use the same number...

Access2003 sp3 OS XP I would like to make a csv file using ADO. I can do it with DAO but is it also possible with ADO. DAO solution Dim rs_rel As DAO.Recordset Dim qdf As DAO.QueryDef Dim db As DAO.Database Dim tblrel As String Set db = CurrentDb() Set qdf = db.CreateQueryDef(name:="abc") Set...