Recent content by Romanov

What i like is the posibility to link several files to a record. This could be an offer word document, an excel speadsheet etc. Every thing which is related to exactly that record. When someone open the record (in a form) then he should have the posibility to dblt click on the file he is...

How do I link documents to my Access ForntEnd application ? What I worn'a do: I like to have a form in which users can drag document (word, Excel etc.) into - I) don't wornt the document placed in Acces, just a shortcut to the file location. Any idea is appresiated. Romanov

:confused: I'm aware of how to create a function that automaticaly update my Table links from my Access FrontEnd to tables in a MS-SQL database : Public Sub RefreshLinksSQL() On Error GoTo RefreshLinks_Error Dim X As Integer, tbds As TableDefs Set tbds = CurrentDb.TableDefs For X = 0 To...

Linked SQL tables in Access looses primary key ? I'm having a very strange problem with my Access application. I'm using an Acces frontend application and my data is placed in a MS-SQL 2000 backend database.Because of slow communication between two offices, I have merge replicated my MS-SQL...

I found a solution, but......... I just found out what I was missing. I needed to install the Microsoft Office Access 2003 Developer Extensions. After I did this I have a Package Wizard like in the earlier versions. That din't solve my problem - in earlier versions of the package wizard...

With Office 2000 and Office XP I have been using the Package Wizard to build setup packages for distributing Access solutions. One of the strong thing in this soliution is that it scans for dependencies and automatically add these to the package. Now I'm building application using Access 2003...

Hi Al, Your surgesten sounded a little wild -- but then again... I tried it, and you now what - it works. How cut I miss that ?. I have even tried without extension on the filename without look. Thank you - you just saved my day. br Romanov

If have posted this quistion once before without finding any solution. I hope there is someone out there who can help - this is realy giving me a hard time. I trie to do a simple code in Access 2000 : Docmd.TransferText acExportMerge,, "tablename", "c:\filename.doc", True I keep getting the...

I tryed to remove the "" in the end of the code - that did't help. Then I tryed to put in a export specification file - that did't help either. I tryed to build a new database with one tabel to export from, and that did't help either. Any surgestion to what I can trye ??

When I use the following command in Access 2000 : Docmd.TransferText acExportMerge,, "tablename", "c:\filename.doc", True, "" I get an error message saing : Cannot update. Database or object is Read-Only. The exact same code is used in my Access 97 application and works fine. If I take the...