Search results for query: *

Yes, that's the route I'm just about to head down - was hoping I could avoid this though! Thnks for your time and help, its much appreciated. Grieg.

Cheers for the reply. Theres no autoexec macro however there is a form that launches when the database opens and this has an 'on open' event that calls a module that initialises screens and variables. Neither of these objects have any path references in them and the events are ok. Also, I...

Hi, I have a database which is split to give two files (a front end file with the forms / code and a back end file with the tables). I have copied these files from one server to another and re-linked the tables, however now whenever I open the database I get a message stating that Access...

Hi, I have an automated Word letter template where the user has to use a custom icon\menu item to save and close the document (so that code behind the template can carry out various checks on the content and decide where the document is to be saved to). What I need to know is, is there anyway...

You're right. Sorry for not making this clearer. Grieg.

Hiya skip, Problem was that I didn't want to open an active version of the document I was taking the text from so the user would only have the one visible document. In the end I solved it using the following code (included it in case any one ever has the same query!); Dim objST As Object...

Hi, I have a word template where I want the code behind it to import a section of bookmarked text from another word document and load it into a string\form property. I can't use the open the document as a text stream as its a word doc - could anyone point me in the right direction. Any help...

Hi, I have a form on an Access 2000 database which displays a record from a table and on the form the controls (combo\text boxes) are locked to prevent the data being changed. When a button is pressed the controls are unlocked and the following code is used to take a copy of the record, load it...

Hi Nikki, Thanks again for your reply and help (I think you replied to an posting of mine from last year as well!). I don't think I explained myself properly in my posting as the main area I was having the problem with was the connection string and setting the reference however I managed to...

HI, I'm fairly new to excel and looking for some help. I have a spreadsheet where I need to send data captured via a dialog box to a table in an Access database. How can I connect to the database and append the data to the relevant table. I've been trying the code suggested in the excel...

Nikki, Thanks for the reply. Tried reassigning the code using the property window but still getting the same error (for all event procedures in module). Ended up having to make a duplicate of the form, copying the code from the old form to a text document and pasting it back into the new...

I have various bits of code attached to buttons/labels as events however when these buttons/labels are clicked I get the following error message; "The expression *(event name)* you entered as the event property setting produced the following error: Procedure declaration does not match...

Jeff, Thanks for your help -its much appreciated. Grieg.

I have a form with a combo box (cmbUser) and two text boxes (txtUser & txtBranch). The combo box has 2 columns. When an item is highlighted in the combo box and the user clicks a select button I need to set txtUser to the data in column 1 and set txtBranch to the data in column 2. The data from...

Good afternoon, I'm hoping someone can see where I'm going wrong! I have a form where you can enter criteria into text boxes to search for clients records. The details of the clients records then appear in a subform (subClientSearch) on the form. The subform data is provided from a simple SQL...

Excellent, that works a treat - many thanks. Grieg.

Hi, I have 2 forms ('client' & 'review'). Both forms are based on seperate tables however both have a field 'policy' which links the two. When I click on a button ('addreview') on the client form I need this to open a new record on the review form. I also need the field 'policy' to be set to...

Thanks for your post. I've tried putting that in but it threw up a 'user defined type not defined' error. Prior to this I had tried; Dim rs as Recordset however this made it come up with a 'method or data member not found' error in the Findfirst statement. Back to the drawing board...

Hi, I have a form (select_client) where I have a combo box (clients) showing certain fields from a table. When a record has been selected from the combo box and the user clicks on an item (select) I want another form to open up showing all the fields from this record. The code I am using is...

Hi, I have exactly the same situation as yourself - I was wondering whether you managed to debug your type mismatch error?