Recent content by sebble1984

obviously not :) ;) :p :cool: :)

Hi, I updated the SQL. Thanks for your advice: - strSQL = " SELECT tblProjects.ProjectDateModfied, tblProjects.ProjectNumber, tblWorks.WorkNumber, tblOrders.OrderNumber, autotblProjectStatus.ProjectStatus, " & vbCrLf strSQL = strSQL & "tblWorks.WorkAddressNameNumber & ' ' &...

How do i go about using the CHR(value + 64) or chr(value + 96) through the whole record set please? Thanks

Sorry, Whats makes you think the best way would be to re-design the database, from one piece of code?

I am exporting to excel and currently have numbers in PreSiteSurveyStopTheClockReason column, which mean something. But when i export them to Excel i would like the numbers to change to text, 1 = weather 2 = customer 3 = new 4 = old etc. I am not sure if it is best to cast to strings from...

Hi Guys, I have a report exporting to excel using late binding techniques. When exported into excel i have numbers for 1,2,3,4 tblPreSiteSurveys.PreSiteSurveyStopTheClockReason entitie and I am trying to either change the numbers here casting from int to string 1 = a 2 = b looping through the...

Thanks. I changed some code to this: - Dim oApp As Object Dim oBook As Object Set oApp = CreateObject("excel.Application") oApp.Workbooks.Open ("U:\xReports\OrdersReceived.xlsm") oApp.Visible = True Set oBook = oApp.ActiveWorkbook Set oSheet =...

Thanks for the reply, yes you can. Microsoft Excel 15.0 Object Library, but I dont want to include that reference as users have different versions on Excel and the database is run in a runtime environment The database crashes in the runtime environment when the "Microsoft Excel 15.0 Object...

Hi Guys, I have wrote some code to export to excel, which work in access 2013 full version, but testing the system out in a runtime environment the system crashes because I am referencing the excel library in the VBA references. I have now removed the reference and I am looking to change my...