Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: SteIT
  • Content: Threads
  • Order by date
  1. SteIT

    Populate listbox with table fields

    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)...
  2. SteIT

    Adding dates to ComboBox

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

    using event Worksheet_Change excel

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

    Using event Worksheet_change

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

    Display form/message whilst processing code

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

    Using Dir command to loop through documents

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

    Opening a number of word docs to edit bookmarks

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

    Using userform to add data to multiple word documents

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

Part and Inventory Search

Back
Top