Search results for query: *

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...

Hi, thanks for the reply. I'm thinking about using a mapped network drive as the data source. ie. create a folder, map it to the drive letter 'Z' and then set the path of the database to be at Z:\DB\db.mdb However, I'm not sure if the server itself can access the database via the network drive...

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\")...

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 any way 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...

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 any way 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...

I've tried following the two suggestions from hymn and foolio, but it still doesn't help. 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 so i...

Hi, I've just split up my Access database file into the FE and BE parts. I've noticed that it takes a really long time to load up the FE database file now? around 1-2 minutes? Is this normal? It seems rather long, considering it only used to take a few seconds to load up the database before it...

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...

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...

Thanks for your reply. It seems to work if you 'import' the excel sheet to Access but if I create a linked table, then Access doesn't allow me to change the table properties. As I wish to have a linked table to Excel, not an imported one. Also with the 'import' facility, even though you can...

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 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...

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...

Hi, I've got a sub form table which is created via a "create table" button on the form which is linked to a macro. The macro just contains a series of runSQL actions which insert records into the database and I then have a "ShowAllRecords" action at the end which refreshes...

Hi, I've got a sub form table which is created via a "create table" button on the form which is linked to a macro. The macro just contains a series of runSQL actions which insert records into the database and I then have a "ShowAllRecords" action at the end which refreshes...

Hi, I've got a sub form table which is created via a "create table" button on the form which is linked to a macro. The macro just contains a series of runSQL actions which insert records into the database and I then have a "ShowAllRecords" action at the end which refreshes...