Search results

Hello, Code beneath worked perfectly with Access 2003. Now we switched to Access 2010 and it generates a table where data isn't put into my 77 fields like before, but seperated into 1 field, separated by some ;;;. I am not good with programming. So can someone trow an eye on this? Dim...

this works: DoCmd.SendObject acReport, "RPT_RADI1", "SnapshotFormat(*.snp)", "USFME", "VHERO", "", pbsuject3 & "- RADI tot EVVD", strcontents, True when I add this piece of code: DoCmd.SendObject acSpreadsheetTypeExcel9, "j:\john\radi\test", "acFormatXLS(.xls)", ulle@sky.com, "", "", pbsuject3...

Hello I have allready this code which sends a snapshot report to some people. Depending on the condition the right person receives t he right stuff. Set rs1 = db1.OpenRecordset(sqlstr) Pbname = rs1.Fields("PB") pbsuject1 = rs1.Fields("TypeOfClient") pbsuject2 = rs1.Fields("Client")...