Search results

This is how I understand it.

Is it okay to use the built in bitmap images? Will it cause the size of the database to increase? Or should I go through the effort of making a linked image?

This is something that we do from time to time, which means it justifies a routine in a module I think. Here is some reusable code: Public Sub MoveTo(frmToMove As Form, strNameOfIdField As String, lngId As Long) On Error GoTo err 'this will move a form to a record with a specified...

Regarding the powershell thing, you're looking at the wrong post in that thread.

Did you look at the references? Make sure none of them are missing.

Regarding the user type not defined error, this makes me wonder about your references. Take a look and see if anything is out of order with those. Sorry for double posting, but I can't edit records on this computer...

Both of those paths you need to change to a folder on your hard drive. It doesn't make any difference where you save them as long as you can navigate there.

Have you tried a decompile? I usually follow David W Fenton's advice from this thread: http://stackoverflow.com/questions/3266542/how-does-one-decompile-and-recompile-a-database-application

Are you importing the objects one at a time to narrow down which one is causing the issue?

It works beautifully for me on both 32 and 64 bit Office.

I feel like you're missing the point. We are discussing relativity. Time is relative. As far as I'm concerned, a watch on my wrist moves at a constant speed regardless of anything else. An external observer might argue and say my rate of time is different than his. Neither would be wrong...

Yup! Time dilation is always with regard to two parties in different frames of reference. If I get on a plane, time is normal to me, but if you looked at me from the ground, it would appear that I was slowed down just a tiny bit to you.

From their point of view, time is constant. Time dilation is only seen when you compare two different parties with different velocities (accelerations?). I think Minty was comparing their viewpoint to that of people on earth. edit-Yeah...accelerations, not velocities.

Funny, I use similar code and I just modified mine for the same reason. The below is currently working on 32, and I believe it will work on 64, but I need to test it again. Just call the scroll function from the form's mouse wheel event. Option Compare Database Option Explicit...

If you're still having issues perhaps the easiest fix is to create a shortcut on the desktop and set the image to your image path. You can do all this in code in the front end.

So you're saying that the else part is running when it should not be? If so, there is only one if statement, so it must be returning false when it should be returning true. Debug the strPath part right before that if statement and try to navigate to it in Windows. It probably wont work which...

Bear in mind using APIs can cause issues if you try and deploy on Access 64 bit. Usually not an issue, but it was for me recently. So now, I try and avoid APIs when possible or code for both 32 and 64 bits.

A couple things. First of all, I recommend validating the value you are setting at this line: xlWORKSHEET.Name = strFORCE & "-" & strCLASS A worksheet name has a length limit, so find out the limit and use .name=left(strFORCE & "-" & strCLASS, x). I also recommend stripping out spaces and...

Access is not made to be secure. If security is a must, consider a different technology. In Access, you can mostly only prevent people from snooping around. On the plus side, few people really know Access. I've found that even people who claim to use it use it in the same fashion as Excel...

This is why I try and steer clear of all references and APIs. If there are not many APIs in use, it could be easy to fix with a little bit of research.