Search results for query: *

Hi, My routine creates a new workbook from a template that contains links but I don't want to update the Links yet. So I use the line Workbooks.Add templateStr This works fine but every time it runs asks if I want to update the Links. Is it possible to amend the line so that it does not...

Some time ago I installed Messenger with a @MSN.com passport, I only want to use it for chat, voice, and web cam but not email. Now I have just created a logon for my wife and she wants the same but the install wants me to create a hotmail account. Can’t this be done anymore?

Does anyone use this routine, if so do you know if it is possible in VBA to check to see if it is already running, if not then start it and then at the end of the routine to close it

Please help, I am getting a bit confused. If I want a variable to be only available in the current Sub routine then I use Dim, If I want the variable to be available in all Modules then I use Public. Does it matter if I make the statement is before or after the beginning of the Sub routine? What...

When I send an email using VBA, I found that the copy in my sent items does not contain the body or any attachments, I do need a proper copy of any emails that I send, does anyone know of a way to overcome this problem please ?

Please help, I have written my first major VBA routine to send emails with attachments to customers, but for every one of the 150 emails being sent Outlook pops up with the message “A program is trying to send mail using Item.Send”. I can click Yes but not 150 times, and with a 5 second delay on...

Please help, I have created a working Access VBA routine that searches through a query for customer Email Name and Product Type in that order and sends an email to each customer with a data sheet for each product attached. There are 9 different data sheets held as Word templates and each...

Please help, this routine will work the first time it is run, the 2nd time it will fail at the first "Selection." statment with the error Run-time error '91' Object variable or With block variable not set. What have I done wrong? Another error message I sometimes get is Run-time...

Please help, I have a routine that opens a Word doc from Access, but now I want to open 2 documents at the same time. How do I set 2 variables so that I can activate one, then switch and activate the other? Public Const WordDot As String = "c:\Test.dot" Dim objWord As...

Please help, I have 2 questions. 1/. I want my routine to send all .doc files in a folder to a contact but how, the Attachments.Add will not allow me to put “c:\docsemail\*.doc 2/. I want to start Outlook before running this sub routine because it is part of a loop, it will be very slow if I...

Please help, I am writing a VBA routine in Access to send emails with 1 of more attachments based on the same Word.Dot template. The idea is to open the Word template, make some changes and then SaveAs into a temp folder, then when ready email the attachments, clear the folder and then move onto...

Hi, I am a beginner at VBA for Access and have only used code on my Tables, I have a database with a Table and a Query. I want to write some VBA to use data in the Query, my questions are: 1/. Do I need to run the Query before I try to use the results, if so is it a DOCMD command? 2/. Do I use...

Please help, I have been writing an Access Database for a few weeks, it is not very big or complicated and only has a few VBA bits. My problem is that often when I close the Database and go back to the Object View, all I can see is the Object buttons but nothing in the main window, not even...

I have a Table of Names and a Table of Addresses. I want to join the 2 together in another Table using a Form with 2 CombBoxes but I only want to see the Names that have not been use yet in my Name Combobox, I dont want to see all the Names. How can I create a query of all Names in Table 1...

I have 3 tables joined by a query, the results are shown on a form that is set to continuous and this works OK, my problem is that I cant fit all the data on 1 line so I want a "More Info" button on each line that will open a popup form but when I do this the popup always goes to...

I am having trouble trying to design an Access2000 query to use with a dropdown ComboBox. I have created ComboBox that uses a Query to list parts and put them in order but what I wanted was for the dropdown list to NOT show any parts that had already been selected. I guess that I need another...

Please help, I have a sheet in a workbook that has password protected cells. I want to change the contents of some these cells in VBA but I would need the routine to unprotect the sheet, update the cells and then re-protect the sheet with the same password. Is this possible, if so how.

Please help. I am trying to copy data from one table to the END of another, although the copy works it seem to go where ever it wants. Set db = CurrentDb() Set rec1 = db.OpenRecordset("Table1") rec1.MoveFirst pcpCodes = rec1(0) mess1 = pcpCodes rec1.MoveNext Set rec2 =...

I need to make a lot of changes to a live database, can I prepare the updates using a copy of the original and then just import them when convenient, if so how do I deal with changes to the tables?

I want to test a record set to make sure it is at the new record and then copy several sets from another table, this is how far I am, mydata1 will be the number of records to copy and mydata2 will be the start of the transfer. The bits that are commented out are the bits I have the problem with...