Search results for query: *

Thanks MajP. I think I can use this, the problem I am having is tblContacts doesn't have companyName field but is linked to Company using CompanyNumber (auto number when new company added to tblCompanies). I need to associate the companyNumber to the CompanyName selected in combobox, then look...

I have a form (Send Email) which has a combobox (cmbCompany) which row source to table tblCompanies.CompanyName, and another combobox (cmbEmailType) which is linked to table tbleEmailType. tbleCompanies is linked to tbleContacts (which has all contacts for each company including Email address)...

I am tring to add dates (today & tomorrow) to a combobox. Private Sub userform_Initialize() today = Date tomorrow = today + 1 ComboBox1.AddItem today ComboBox1.AddItem tomorrow End sub The first date is showm as 30/4/08, second date is shown as 5/1/2008. Second date should be 1/5/2008 for...

I do apologise. I have now posted question on vba forum. Thanks SteIT

I am using the event Worksheet_Change to trigger a macro when a value is enter in a range of cells (column J). How can I run a different macro when a value is entered in a different column (column B). Regards SteIT

I am using the event Worksheet_Change to trigger a macro when a value is enter in a range of cells (column J). How can I run a different macro when a value is entered in a different column (column B). Regards SteIT

:-D Thanks MikeC14081972 This does do what I asked for. Thanks all for the responses. Regards SteIT

Thanks TheAceMan1 I have tried displaying a form as modal and non-modal, but the code stops until the form is closed. Do you have an example ? Thanks SteIT

No, if I open another form (with a message on the form) the code stops until the new form is closed

:-) Thanks for the replies. The problem with using a message box is the code stops until the user hits the okay button, I would like to keep a message displayed until the code has finished (as the updates to the word docs are done with visible=false). Once completed I display a message saying...

Using access2003. Is it possible to display an access form or message box, but continue runnning vba code ? After user adds data to a form, I process a number of word documents. I wish to display a message informing user that documents are being created. Once completed, remove the form/message...

Thanks. I suppose I can keep Word application open, and then close it outside of the loop. Forms![Retainer Companies]!CompanyName is a company name selected from listbox in access form. I have assigned this to variable 'compname'. All works okay on first document, but the next document...

Extract of code. Do a lot of othere things within the macro Dim newdocpath As String Dim compname As String Dim Fname As String Dim objWord As Word.Application newdocpath = "C:\RCS\" ' folder contains compname folders compname = (CStr(Forms![Retainer Companies]!CompanyName)) Fname =...

Not sure I know what you mean. Fname = Dir(<doc path string>) <doc path string> is a variable set to the path of the documents I opening/editing. Thanks for the prompt response

Sorry, missed this off. Fname = Dir(<doc path string>) Regards

I am using Access to edit a number of word documents in a folder. I need to edit each file within the folder, save file (same name & same folder). All works okay but am having trouble picking the next document within the folder to edit. Using: Do While Fname <> "" open Fname...

I have a number of word documents which are updated with data (company name,dates etc.) and then saved as a copy of the original. I am looking for the best method to prompt user for the date, then open each word document, populate the required fields (using bookmarks) and save a copy. I have...

I have a number of word documents which are updated with data (company name,dates etc.) and then saved as a copy of the original. I am looking for the best method to prompt user for the date, then open each word document, populate the required fields (using bookmarks) and save a copy. I have...