Recent content by reimondo

Hi, Is it possible to set the 'Control Source' of a text field box to be a query? The text box is unbound (ie. not a physical field in the database tables). I've already got the query and it works fine when I execute the query by itself. But when I assign the query to the 'Control Source', I...

Just to sum it up, the main problem at the moment, is that when a client computer opens up a mail merged form letter, the data source is empty. (as there is no data source located on the client's C drive). I want MS Word to be able to detect the data source from the 'shared folder' on the network.

Just to elaborate on my last post. With 'absolute' address i mean like if I set the data source of a word form letter to be the DB.mdb file located in "C:\DB\DB.mdb", then the word document's data source is always hardwired to that specific address in C driver ("C:\DB\"). As I have the form...

Hi, I'm currently setting up some form letters as mail merge documents which will link up with the Access database. I would like to know is there anyway to change the data source address of a mail merge document to be a 'relative' address and not an absolute address? Or does Microsoft Word only...

Another thing, this problem shouldn't be related to whether the database has been split up or not right? As the version I have at the workplace has yet to be split up. (but because I don't visit the workplace much due to my work being contract work, I haven't had the chance to test it out on the...

At the moment, I'm trying to emulate the error message "The DB has been placed in a state by user ‘Admin’ on machine ‘## that prevents it from being opened or locked.” on my computer at uni, but I can't seem to get the same error message. As this error message only occurs when I try to access...

Hi The_Doc_Man, thanks for the reply. I'm still reading up on the workgroup security stuff, and i have a question to ask. I'm wondering why the error: “The DB has been placed in a state by user ‘Admin’ on machine ‘## that prevents it from being opened or locked.” only appears when I run the...

Hi, I have a problem with multiple users accessing the same MS Access 2000 database at the same time. The database is stored a directory under windows XP Professional which is set as a ‘shared folder’ enabling other users to edit the files. The database is stored on the server machine within a...

Hi, I'm new to VB, and I'm trying to add a bit of VB code to automatically insert a OLE object into a form (via a button). However, when I try to compile the code, I get a error message "compile error: can't find project or library" and it highlights the 'OLE1' object. As I've never used OLE...

Thanks for your reply. I've tried linking the table to the excel spreadsheet but i have a small problem. When I create a link to the hyperlinks from the excel spreadsheet, they become plain 'text' fields in Access. Furthermore, Access doesn't allow me to change the field type for linked tables...

Thanks for your reply. When I import the hyperlinks from the excel spreadsheet, they become plain 'text' fields in Access. Furthermore, Access doesn't allow me to change the field type for linked tables? Any ideas on how to keep the linked data as hyperlinks (without losing the hyperlinked...

Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...

Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...

Hi, I'm familar with Access but new to VB, and I'm trying to add a bit of VB code to automatically insert a OLE object into a form (via a button). However, when I try to compile the code, I get a error message "compile error: can't find project or library" and it highlights the 'OLE1' object...

Hi, I'm helping a friend build an access database and have a problem. I currently have a list of hyperlinks contained within an excel file. At the moment, I have to insert each hyperlink one by one via a RunSQL statement using a macro. This method works but will be rather troublesome for my...