Search results

Okay so I got the Inventor View ActiveX File registered and such. I can put it in my database and it all works however if I change the size of the control, larger or smaller it causes access to crash. Any ideas on how to get around this?

I found this forum post. It isn't exactly what I am trying to do but I think it will work as a substitute as long as it isn't too slow. http://www.access-programmers.co.uk/forums/showthread.php?t=139043 I am working on getting it functioning now. I will let you guys know if I get it to work...

If I found a dll that would help me implement this how would I go about telling VBA to use it?

That is kind of what I was thinking but I wanted to throw the question out there in case someone else had come up with a way to bend access's functionality to fit something like this. Thanks Ryan

I understand what you are saying and that is similar to the system I have in place now but it only works with jpg files because access can render those. I am currently converting all the IDW files to jpg files and storing them. The problem comes when the IDW file is updated by our engineers...

Well the basic idea of what I want is when you click on, lets say an IDW file in Windows explorer it can show you a thumbnail of that file. I want to use that in Access. More specifically I want to attach an IDW file to a related record using it's location (c:/prints/1234.idw). I then want to...

I am looking to incorporate thumbnails similar to what can be seen in windows explore for non bitmap file types such as IDW files or PSD files. I am not even sure what could be used to accomplish this. I am pretty sure explore uses a dll to render the thumbnails it displays. I don't know if...

I tried that and it seems to work just fine so thank you for that. I am having another problem now though. I want the form to reopen to the same record it was on before the macro was run. I thought I could do this by assigning the record number to a TempVar called PreviousRecord and then then...

Thanks. I will try that. Will that fix my problem with the table not being able to be locked?

I am trying to create a new table using a macro however everything i run the function it tells me that the table can't be locked because it is already in use. I added a command to close the form the macro is launched from because the table is used on that form but I still get the same error. I...

Okay, I'll give that a try on Monday when I get back to work. I'll let you know how it turns out.

That sounds similar to something else that I tried, does it work with reports?

I was wondering if anybody knew of a way to to create an automatic OLE attachment base on a specific field. What I was thinking was adding an OnUpdate function to the field I want to use and after it is updated it look for a jpg with the same name to link to the OLE field for that record...

Photo Editor works right after installing it. The images are rendered in the access database. The display quality is so so but I needed the images mostly for print and they look fine then.

I got it working. What I ended up doing was installing microsoft photo editor. It has the correct OLE server to render jpgs. It all works just fine now. Thanks for the help

I am working on a database that manages parts for a plant. It is set up with an access front end and a Mysql backend. I have a table called tblParts. This table contains all the information about each part inclueding an field for a blueprint. I originaly had the backend set up in access and then...

I am wondering if there is a way to display a pdf file that is attached to a record from a report. I know access will do this for jpg files but I need it work for pdf files. Any ideas?

I think I understand what you are talking about. I am fairly new to access. I will give it a try and see what I come up with. Thanks

The inventory is calculated on the fly and my database is set us very similar to how you described. I just can't figure out how to make it subtract all the parts when one item is built. That is the problem I am having. At lagbolt - that is the next step that my boss wants...

I work at a manufacturing plant and I am currently working on getting an inventory system set-up to track parts. I have it all done and functioning except for one part. My plant builds large farm equipment out of several hundred different parts. My current system keeps track of these parts...