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 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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.