Replies

A little more research tells me it cannot be done. It seems the recommendation is typically to include a yes/no field for the user to check. And use the checked field to select multiple records. Thanks folks, for any head scratching you did on my behalf.
Sanora

An option box in the subform header got the response I needed.
Thank you all for your help. It is so very GOOD to know I have access to such a resource!
Sanora

Yes, it does, but only from within the subform. I was trying to effect the change from the main form using Forms!mainform!subform.filter and that does not seem to work. I can muddle on, but it is less elegant than I had hoped. Thanks for the response.

Thank you – that fixes 1/2 the problem. .docx files now open with Word 2010, but .doc files still trigger Word 2007. I chose the same program for both. The path for my system is C:Program Files (x86)Microsoft Office Office 2010 Office 14Winword.exe
Is it significant that a system search finds only one Winword, the one for Office 2010?

I’d bet your printer guess is right. In this case, the client does not have the knowledge nor inclination to fiddle with or fix anything. Only standard fonts have been used. However, client printer(s) and printer here in the office are not the same. Thank you for taking the time to experiment for me and I shall quit worrying about it.
Sanora

The steps taken were to 1. copy the file from a thumb drive to computer. 2. Make a copy of the file just copied – so there is now a file and copy of a file. 3. Make some modifications to some objects in the copy. Generally these are tweaks to forms and queries. NOW open some of the reports, even reports whose source queries had not been changed. Date fields display (on screen) in some reports has changed. Example: a column of dates may show 9/8/2013, but where the date should be 9/10/2013, it displays #######, because the field seems just a little too short to display that additional digit. By display, I mean on screen. Enlarge the field size and it fixes the problem.
If I return to the original file, the one copied to the computer in step #1, the same data is displayed properly. There is room for all the dates.
The default printer is the same in both files.
?
Thank you for taking the time to look and contemplate. By now, the reports have been fixed, by enlarging the date fields slightly, but it would be very nice to know why the problem occurred in the first place, and whether it will come back to haunt me.
Sanora

I followed this thread and downloaded and ran fix_new_folder.zip. The New Folder option was back after rebooting. However, the option disappeared again within the work session. I repeated the steps and rebooted, and have the New Folder option again. My fingers are crossed that it will stay.
sanora

I have the same problem. [CTRL][SHIFT][N] produces no response. Mouse menu has New but in the submenu to New does not have Folder; it does have Compressed (zipped) folder. The toolbar menu matches the mouse menu. Any idea why? Or how to fix?

Thanks
sanora

I tried to pose the question without the back-story, but here’s a quick summary. The original database was badly designed – really not designed, just built. We are trying to rebuild the system, and have a lot of faulty data to salvage. As part of the cleanup, we were hunting incomplete records – hence the ‘all sales without matching customers’. Access was doing what we needed, but we were concerned by the difference in responses and figured there was a reason why.

In this case, we were indeed hunting any sales records that did not have customers.

Thanks, and I should have given more info.
Sanora

In the Default Programs, I can tell Windows to change programs, browse to the Office 2010 Powerpnt.exe and select it. Next time I click on my file.pptx file, it opens in 2007. Somehow I need to be able to include the path to the application, and this does not seem to do it.

Nora

Hmmm! That’s new. Not what I had in mind, but nifty. I wonder if I’m remembering a Lotus 1-2-3 feature and not Excel at all. I may have holes in my head.
Thanks.

Bingo! Thank you, Paul.

Bingo! Thank you very much.

My thanks to everyone! It’s gratifying to ask a question that results in this kind of response. It proves there is no neat, easy search & replace type response and I was right to ask for help! Thanks again.

Well, Rats! At least, now I know what I’m up against. Thanks.