Search results

In the VB window go to Tools>References Make sure that you reference to Microsoft DAO 3.6 is higher priority than Microsoft ActiveX Data Objects 2.5

I think you will need to code this rather than use SendObject. This link may give you some ideas. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30353 ie .Attachment = c:\Your_File .Attachment = c:\your_other_file

Try www.cprogramming.com I found it quire helpful.

Thanks Doc_Man, That was my first suggestion but unfortunately it would mean opening and saving hundreds of .dwg files and also new additions would have to be saved twice. This is not something the user wants to do. I did purchase the powerup from 'USA' to enable the Autocad integration but...

Hi, I am using an unbound frame to view linked images. When linking to .bmp or .jpg etc I just select the file and then through code inserts it into my frame. Whenever I select an Autocad (.dwg) file Autocad opens up and I have to close it to insert the file which is taking ages to do. Is there...

Use the Unbound Object Frame

I had this problem a while back. What I ended up doing was importing all the Lotus tables into Access. I think I used DBase5 as the import option but I can't be certain now. Then I rebuilt the forms from the imported tables. Most of the data imported OK but it did need a bit of formatting. I...

Alex, I think I will take yours and Pat's advice and switch to API's. I have only just become aware of the registering problems (probably more luck than judgment). I havn't come across the pb problem yet but if I do and find some sort of solution I will be sure to let you know. Kev.

I have been using the Microsoft Common Dialog Control. This works fine once you get past the .ocx registering. If your application is being used in house then that is not too bad but if it is for an external project then you are not going to be able to fiddle about registering controls. Pat...

Sorry my last post was a bit vague. I have been trying to attach a simple example for the past hour but this bloody pc keeps playing up. I will try again from home later. Sorry.

Create a new table called ImageTable. In the table create a text field called ImagePath. On your form create an unbound Image frame and call it ImageFrame. On the OnCurrent event for your form paste this code On Error Resume Next If Not IsNull(Me![ImagePath]) Then Me![ImageFrame].OLETypeAllowed...

The send object is the easy option I think. I prefer to use code expecially if I want to send attachments or referencing field values. If you want to send me your database I will have a look and see if I can help you in any way. It might be easier than trying to post code on the forum.

Thanks Pat I see your point. Luckily I can access everyones pc to register the controls. I will bear your suggestion in mind for any external work that I do. Thanks again.

RESOLVED If anyone else has this problem the answer is to use the 'Regsv32.exe' from the Microsoft download centre. Drag and drop the controls onto the file and it will register them for you. It works with both full Access and Runtime Access.

Doc_Man. Thanks very much for your quick reply. I had checked the references and they showed up as MISSING. I copied the .dll /.ocx files onto the pc. They now show that they are not missing but still no common dialog control. It must be the registering part that I need to do. I will have a go...

You can do this using Send Object or by writing your own code. Use this in the 'after update' event. ie If Me.Fieldname = "Your Test" Then DoCmd.SendObject acSendNoObject, , , MailNames, , , "Your Subject", "Your Text Body", 0 Else Exit Sub End If

Hi all, I developed a database which stores the path to an image in a table. I use the common dialog box to allow the user to select an image from a network drive which then inserts the file name into the table. On my pc this works fine and on about 50% of the users pc' it works fine but the...

I've attached a very basic database that will do this. Use it and modify it to what you need. Kev.

Post your code so as to see what you are trying to achieve.

The path should read something like this - "C:\Program Files\Office\ART\Office\MSAccess.exe" "C:\YourDb.mdb" /WRKGRP "C:\YourDb\System.mdw" I Think