Search results

I just encountered this issue with one of my clients. She's got 10s of thousands invested in an Access application for her legal practice and the application is integrated with Outlook to send out hundreds of emails each week. So, Microsoft just dropped this on us with no warning that it would...

Thanks for your help dbGuy. It turned out I grabbed an older version of my UsysRibbons table and when I replaced it with a newer version, all that was needed was to set the reports' ribbon property to PrintPreviewRibbon, which was what I'd named it long ago. Good thing I checked as my next step...

Thanks, the suggestion to allow full menus on opening the report didn't work. If anyone knows a sample Access file with a good print preview ribbon and demo code on how to load it, please let me know. I do have a usysribbon table I created back in 2013 to allow the Excel option to show, but when...

Running full-version Office 365, I hide the default ribbon with ChangeProperty "AllowFullMenus", DB_Boolean, False and I'm left with just the Home and File commands in the ribbon. That's good except when the user opens a report (all reports are set to open in Print Preview mode via code). In the...

Speaking as a lesbian trapped in a man's body, I'd never presume to compete in women's sports. :love:

Funny, the dbguy's sample db for moving attachments looks similar to mine here: Data mover sample database moves attachments. He did it more elegantly, but mine is prettier and I think I did it first, back in 2013 or so.

Thanks Colin - you're always helpful. Sent you a few bucks beer money. And, I agree, there is nothing good about the MVF's except possibly the ability to display the data more compactly then, say, a listbox control.

Josef: That's brilliant. Thank You. I was puzzled a bit until I saw the event - very good trick. I was thinking I'd have to extract the data and make some type of detail table, but that probably wouldn't give me the ability to have that MVF control.

Someone used a table-level lookup so multiple records could be selected for a single record in the main table. In this case, the main table is composed of tasks and the related table contains users. I put an active/inactive boolean in the user table and it's easy enough to prevent the selection...

Thanks for all your responses. Perhaps I didn't give you a good background/overview. The client, a law firm, sends out a set of forms for their clients to fill out relating to Estate Planning. The get back a .cvs file that's 1271 fields wide. Ultimately, the date is getting parsed into a main...

This is an oddball. I have to import 255 fields (1 record) from an Excel spreadsheet. So, naturally, I used the docmd.TransferSpreadsheet command. I've used it many times in the past, but never for more than 20 fields or so. With this many fields, it failed, usually around column 117 and/or...

Yes. That's my guess too, but despair as I don't know how to track it down. I did put debug.print statements in just about all form events (for the parent and subforms) and it looks like they are bouncing back and forth a bit before settling down and stopping. My Peter's software sizing code...

Running a split FE/BE application where the BE is on a storage server and each user has a local copy of the FE. It's a complicated app for estimating jobs with large tables. I've done what I can to minimize bloat and turned off transactions in all action queries as well as moving most SQL in...

Thanks Pat, I have a question about this. I have a client who runs my application in an FE/BE configuration where the BE is on a shared network drive and each user has their own, local copy of the FE. The problem is that over a single user session, performance for that user slows down. Now I'm...

Same here - that's why I was amazed a developer wouldn't use it. Again, probably traces to a developer long out of the MS Access development field as I recall a time when there was no intellisense.

Thanks to all for your comments about comments. I agree that it's stupid to comment on obvious stuff, which my previous coder did, and that it's smart to comment on the why(s), which wasn't done. What really confused me is that the guy had a good mastery of SQL, basic logic, etc. but didn't know...

Error handling, er, YES. Always.

Thanks, all - I too find intellisense useful and vaguely recall not having or using it, perhaps 23 years ago. And, yes, if the control is named the same as the source, it would be risky. I was told this developer started the project and then got buried so they hired me to finish it. It does work...

I just inherited another developer's database and noticed tons of code behind forms where he doesn't use me. to refer to the control, just its name. So, for example: He uses statements such as txtAgentID= rather than me.txtAgentID when referring to a control called txtAgentID on the form with...

Thanks Jack and Isladogs, I looked at both INNO and SamLogic, and decided for the price SamLogic is the way to go. Obviously, INNO has a steep learning curve and their support forum looks primitive. I've always been confused by Sagekey as they say if the installer detects full version Access...