Recent content by FFever

Thanks ! This solves my location problem, but makes me less flexible in using different format, like PDF or xls. Do I have to set possible codes for various format in the code like below ? Dim objword As Object Dim strFile As String Set objword = CreateObject("Word.Application") strFile =...

That works great ! Thanks However, is it also possible to use the location of the database in code, so I only have to upload the invoice number (without path). When I place this on a CD-Rom, the drive is not always the same, so it should use the location of the database. Fred.

When I use the code below, I get the message "Microsoft Access can't find the macro 'Application'." Application.FollowHyperlink [YourTextBox] What am I doing wrong? Fred.

Please, someone help me :o I have created a table including a column "Invoice number". Softcopy invoices are in the same directory as the database is. By using a form, I would like to open the softcopy invoice. Can I link the invoice number to the softcopy invoice, by using the current...

Daft, I have 100 softcopy invoices and a list of invoice numbers. I would like to create a hyperlink to every softcopy invoice by using the imported list of invoice numbers. I viewed your thread about "Storing a hyperlink" and it looks interesting to me. Do you think you can help me ? Regards...

Hi all, I am trying to digitalize my administration. I have figured out most of the problems, accept one: I have a folder with 100 softcopy invoices. Furthermore I have imported an Excel file with a list of invoices. When I click on the invoice number in the imported table, I would like Access...