Search results

My database was working well but I decided to clear out unused objects, etc., because a major revamp is coming. I made several copies, ran FMS Total Access Analyzer on one copy and started removing objects. After removing a number of 'unused' queries, my modInitialize started yelling DEBUG at me...

Tim, thanks for the further insight. No, the "single instance" terminology came from a network guy I know; I actually searched the forum for that term and came up blank. My Best Regards - Sean

Tim, thanks again for your help. I've implemented the work around that you and A.Sinatra suggested, and it is working beautifully. And, yeah, we've got over 100 users spread across 3 linked databases - and I've yet to get any formal Access training, which is causing me headaches because my...

Thanks; I'll check that ASAP. I appreciate you taking the time to help a non-coder. :) - Sean

Works great. Thank you. Am I wrong in thinking that the "can't be zero-length string" is not normal? :confused:

...in the dark night of my despair a bright candle of inspiration flares.... Tim, my deep thanks for your idea - hack or not, I think it will solve my problem - as a friend of mine says "One man's hack is another man's hairpiece." :p Got time for one more question? After inserting your code...

I've searched the old posts and MS support for hours and I'm not finding the answer, yet I feel I'm simply missing something basic...please be patient. I have 20+ concurrent users in an Access 2000 FE/BE Win NT environment. They are constantly entering 'Contact Notes' which are sub records of a...

Issue 0 :D WOW - Thanks! Issue 1: Will do . 2. SECURITY ISSUE: “What kind of security setup do you have?” I will explore this issue. I’m not sure if we set up workgroup security using the built in Access functions, or if we simply imposed it by structuring user access to forms, etc. How...

I'll try to keep this brief: my users are losing certain records; approximately 1 record lost every 2 weeks for past several months. Users create 'Contact Notes' which are part of a larger record; the larger record remains intact when loss occurs. Sometimes, not always, certain table...

This is to The Doc Man: Sorry about the direct e-mail. And just to reiterate - I really appreciate your thoughtful post. I've printed it out , and e-mailed it to my programmer. Thanks again - and thank you for your other service to me and my family, too. Be careful out there. - Sean

Thank you for your response, but unless I'm missing something in the genealogy programs I've researched, they don't provide the functionality we need. Most of them depend on setting biological relationships, and finding common bio-ancestors to create those relationships, and they do not allow...

I'm a social worker for the state of Maryland, pushing hard to build useful software for my fellow Child Protective Services workers. My partner in this is a great programmer who is overloaded with trying to keep the agency's 90 plus Access 2K up and running - and he can't devote much research...