Search results

The location of the dll file is usually the culprit. That or possibly it not being registered (depending on the dll) on the specific computer.

jepoysaipan, Please keep us posted on your replication process. I'm curious if it's as 'easy' and 'problem-free' as David makes it to be. The 'Best Practices' David describes entails, 'follow this, then that, then that, then that, then this', etc..etc.. and you're done and everything will...

Ha. Shoot - I was hoping for something more involved such as a drive mapping incorrectly, permissions, or other things. Thanks for the reply.

Yeah. I just read his last sentence (laugh) after thinking about all the possibilities and wording my post the best way possible. Now I'm really curious to what the solution was (since I had this site open along with a bunch of others.) Stress relief from work :)

Hey gemma-the-husky, I just noticed your last sentence which said you found the error. What by chance was it?

I've mostly seen code not fire when the vba code needed to be debugged/compiled but that would seem weird since you've indicated (correct me if I'm wrong) that it's the same mdb being accessed, just accessed from a mapped drive. Let me re-state what you wrote - If accessed via a mapped drive...

Menus disappear in design view Also for future reference, If some of the upper menus in MSAccess 'disappear' for design view, you can just right-click in the top grey area (in form design) and check the appropriate menu bar to show (ie. Form Design, Formatting, Toolbar, etc...) I would...

I personally wouldn't recommend Replication. (although David on this forum would disagree). My experience with replication has always been problematic, especially if working with large recordsets (where I'd highly discourage replication.) I've used different techniques for data on the road...

Usually this occurs due to one of the following: 1. One of the FE's doesn't have the tables refreshed after the table has been modified design-wise. MSAccess is trying to 'resolve' conflicts on the FE linked tables where it doesn't match the changes in the BE. 2. The network itself is slow...

Show Navigation Buttons or Bars To remove the navigation buttons at the bottom of a form, you can simply use code as such: Forms!MyFormName.NavigationButtons.visible = false If it's a subform Forms!MyFormName!MySubformName.NavigationButtons.visible = false Note that you can pretty much...

Short of using an API for images (which I've seen posted a few years back), I don't know of a way to do it (although I'm not sure about 2007). Otherwise I've seen API modules (again, a long, long time ago) which seemed to be able to manipulate images. I never used them firsthand so I couldn't...

Bob - My sincerest apologizes to you!! You are 100% correct. I really, really feel like scum now and you have every right to be angry with me for directing the post at you. Now I know why something didn't seem right (I kept thinking, "why is this guy now pushing Replication so much when he's...

I'll have to get back to you on that. It's getting late and I had to answer a very long post earlier. Just trust me with the getuser() method. Everyone who has used it has always told me they wondered how they survived without it.

Bob, I didn't really want to get into this but since I started it with my comments about how bad replication is (and you decided to throw in a few offensive comments about skills)... 1. Autonumbers - they ARE very meaningful data especially when you design relationships based on an...

Are you using any ActiveX controls in your application? I would try creating a new mdb (or accdb) and import all objects which don't utilize an ActiveX control (or things like embedding a word document/etc..)...ie. Import the basic objects (tables/queries) and then import forms which don't...

Here's something which might be helpful: http://www.dbforums.com/6390529-post84.html But it's untested in MSAccess 2007. I use this technique quite often though in almost all my apps. Hopefully it will be of some help. Otherwise (I'm not up-to-speed on 2007), but with prior versions...

Nice app Bob. The only thing I don't like is having to login (I personally like to use the getuser() routine to return the loginID automatically and utilize that with a 'user' table.) But I wanted to let you know I looked at your app since I always like to look at other programs developed by...

Yes. This is a 'work-around' type solution which is actually more difficult to implement/maintain versus the link I posted (I did something similar before I created the getuser() and permissions routine). But to each his own.

I have to totally disagree regarding replication. EVEN if it's used properly! Being a developer since MSAccess version 1.0 (ie. 25+ years as an experienced developer), I learned everything about replication and used it for 2 years (as development and support for what originally started out...

Try changing it to a TEXT (or nText) type field on SQL Server 2008 versus a Varchar(MAX). I believe a TEXT type field in SQL Server still represents a Memo type field in MSAccess which allows more characters than Varchar(MAX).