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

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

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

Hi, When i try to run a macro via a button in a form, I get a "type mismatch" error while the macro is running. What does this error mean? The macro I am running has links to other smaller macros depending on the ID field value in the form. The macros mainly involve runSQL actions...

Hi, When i try to run a macro via a button in a form, I get a "type mismatch" error while the macro is running. What does this error mean? The macro I am running has links to other smaller macros depending on the ID field value in the form. The macros mainly involve runSQL actions...

Hi, When i try to run a macro via a button in a form, I get a "type mismatch" error while the macro is running. What does this error mean? The macro I am running has links to other smaller macros depending on the ID field value in the form. The macros mainly involve runSQL actions...

Hi, Inside my main form, I have a sub form which displays a table. I have a command button called "Create table" which is linked to a macro which is meant to build up the contents of the table. The macro contains a series of runSQL statements which simply insert records into the...

Hi, Inside my main form, I have a sub form which displays a table. I have a command button called "Create table" which is linked to a macro which is meant to build up the contents of the table. The macro contains a series of runSQL statements which simply insert records into the...

Hi there, I'm trying to create a form letter in MS word which can be accessed via a hyperlink on the main form. ie. If i'm on client ID 1, and i click on the hyperlink, it will create a form letter will the name and address details automatically filled in. But I'm having problems with the...