How to create a file name that includes the date. Q: Steve Mason is trying to export data from a query to an Excel worksheet, and save each exported file with today’s date in the file name, for example qrytest.01/01/2004.xls. How can this be done? A: Slashes in the date won’t work — they are […]
How to successfully merge data from Access to Word. Q: Bruce Michael writes: “I have been attempting to do a merge in Word 2003 using an Access 2003 query. When I look in the query, the data is correct, but when I actually merge using the data, for one column in the database, the values […]
How to get group headings to repeat for groups that extend over several pages. Q: Saul writes that he is having problems with getting headers to repeat on each page in a report. A: To get group headings to repeat for groups that extend over several pages, set the Repeat Section property to Yes for […]
How to print larger Memo fields without truncation. Q: Tara Santmire wants to know how to print Memo fields with more than 255 characters on an Access report, without truncation. A: All you need to do is set the CanGrow property of the text box bound to the Memo field to Yes.Make sure that there […]
Follow up on the recently reported NT error message. A follow-up on the weird NT error message reported in the WAW 2.06: “The control registers for COM2 overlaps with the COM2 control registers.” followed two lines later by “While validating that COM2 was really a serial port, the contents of the divisor latch register was […]
