Search results for query: *

Is it possible to have more than three sorting criteria in a mail merge document in Word XP? I'm creating a company listing that needs to be sorted by company. Under the company the people who work for that company will be listed in alphabetical order by their last name. The thing is that...

I created a mail merge document using Word 2000 and (Excel 2000 as the data source). When I use Office 2000 to execute the merge, everything works fine. When I tried to open the document in Word XP and execute the merge, blank lines are showing up in the address for those entries that do not...

I have an Access database that creates Excel spreadsheets using VBA code. The spreadsheets are sent out to various people who add/update the data in the spreadsheet. The spreadsheets are then uploaded into the database using VBA code within Access. A new requirement has come up where when a...

I have a report that allows the user to select certain criteria for the report. In the report's Open event, I open the criteria form in Dialog mode, so that the user has to make the selection. Here is the code: Private Sub Report_Open(Cancel As Integer) 'Open the form for date input...

I have an Access database that contains code to generate Excel Workbooks/Sheets using information contained in the database. The generated spreadsheets have various formatting and protection features enabled. But what I can't figure out is how to freeze the panes in Excel from within the...

How do you check the number of items in an array? More specifically, how can you check to see if an array has nothing in it? I have a function that returns an array of ID's for a particular table based on certain criteria. It is valid for no rows to be returned. If rows are returned, then I...