Moving Files

[mikemaki]

We would like to give the users of our Capital Budget Request database the ability to link to any supporting documents they may have. In order to do this the documents must reside in a common area on the network. We can tell users where to put their attachments. But I don't really trust they'd follow my instructions. When they create the link is there any way I can use VBA to move the file to a desirable spot on the network?

 

[spacepro]

We would like to give the users of our Capital Budget Request database the ability to link to any supporting documents they may have. In order to do this the documents must reside in a common area on the network. We can tell users where to put their attachments. But I don't really trust they'd follow my instructions. When they create the link is there any way I can use VBA to move the file a desirable spot on the network?

I have adapted my original sample in the sample db forum using the filecopy API function.

Download Here
Andy

 

[TIDMAN]

Hie there is this sample available in A97 format please?

Thanks in advance

 

[WayneRyan]

Don't know if Andy's around ...

Wayne

 

[TIDMAN]

Thanks so much for the reply Wayne i tried running the converted db and received this error
Run-time error '438'
Object doesnt support this property or method

Hope that you can help me here please

Thank you in advance.

 

[WayneRyan]

TIDMAN,

I just ran the A2000 and A97 versions. Both worked fine.

Let me make sure I posted the right db.

Wayne

 

[TIDMAN]

Thank you for you time

 

[WayneRyan]

TIDMAN,

It looks OK to me.

Wayne

 

[TIDMAN]

Thanks for you help Wayne the db opens fine its when i click one of the buttons that i get the errors

 

[WayneRyan]

Which button?

I just moved to another computer. I'll give it a try.

Wayne

 

[TIDMAN]

there are 3 buttons they all give 'Object doesnt support' errors something is telling me that the code is not compatable with A97 but you will know better than me on that one

thanks again

 

[WayneRyan]

TIDMAN,

If it's any help, I ran it through its paces and it works fine.

No errors on any buttons. But I converted it to A2000 to run it.

Wayne

 

[TIDMAN]

Thanks for the help Wayne it must be an A97 problem i guess i am SOL again.

Thanks for everything.


TIDMAN.....

 

[spacepro]

Hi Wayne,

I'm around just really busy. Hope you are well!
You did get the right db.


Tidman,

The db 97ver works fine for me. Have you tried re-downloading just incase the download was corrupt.?

Andy

 

[TIDMAN]

Thanks for the tip i tried that about 3 times and also tied on a new machine i have looked into this and come accross this http://support.microsoft.com/?id=177105 but i would not be able to do this as its a work machine could somone translate this for me please?

Hope that you can help me here

Thanks again.

TIDMAN....

 

[WayneRyan]

TIDMAN,

Microsoft's aware of the problem (A97 works with the older version of
Shdocvw.dll that you don't have) ...

"CAUSE
The file, Shdocvw.dll (version 4.701.300), is replaced with a newer version that is installed with Internet Explorer 4.0. Microsoft Access 97 does not recognize the newer version (4.71.1712.5) of the control."

Microsoft's status is that it doesn't care about A97 folks anymore ...

"STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 2000."

At least that's the way I read it.

Wayne

 

[RyanB]

Hi,

When i try to create my own variant of this code for my database it tells me i don't have the required license to use this activex control?!?

What do i do?

 

[spacepro]

RyanB,

If you don't have licenses or access to activex control you can substitue the commondialog control with windows api. Do a search for win api and/or commondialog and I think there are some posts with sample code.

Post back if you have no joy.

Andy