Search results for query: *

Thank you begovics. I looked at the Seagate site but missed that tech sheet. I'll try those steps. Thanks again. Tom

I am trying to make a 200GB Seagate HD (barracuda 7200.7 ST3200822A) and external HD. I put the virgin HD in a external enclosure box and connected via USB 2.0 to me PC. My problem is that when I: right-clicking My Computer > Manage > Computer Management > Disk Management The new ‘Disk 1’...

Thanks for the help Bong. As I was coding your answer, another answer was posted that totally escaped me. Thanks everyone for reading and helping. See the linked thread.

Thank you. I got rid of the save and close action in the Excel macro and changed my Access code as follows: ' run the Excel macro appExcel.Run ("NameOfMyExcelMacro") ' do more stuff MsgBox "Excel is done." & vbCr & _ "Now doing more stuff." ' save and close the workbook...

How would I have Access 'Know' when the Excel macro is done?

I posted my question to the wrong forum and I don't know how to move it to here. Sorry about that. My question is here: thread68-1353640 I can't get past the error in this code. Any help will be truly appreciated. Thank you and sorry again about posting to the wrong forum. Tom

From within Access (XP) I open an Excel workbook and run a macro in that workbook. The last action the Excel macro does is to save and close that workbook. My problem is the VBA code in Access then fails instead of running the next line of code in Access. How do I get Access to continue...

This is the code: Dim appExcel As Excel.Application ... ' combine the path and file name strWorksheetPath = _ strWorksheetPath & strWorkbookName ' open the workbook appExcel.Workbooks.Open (strWorksheetPath) ' set the Excel session to be either visible or not...

I use this code: ' open a session of Excel If funIsExcelOpen Then ' use the open session of Excel Set appExcel = GetObject(, "Excel.Application") Else Set appExcel = CreateObject("Excel.Application") End If

From within Access (XP) I open an Excel workbook and run a macro in that workbook. The last action the Excel macro does is to save and close that workbook. My problem is the VBA code in Access then fails instead of running the next line of code in Access. I trigger the Excel macro with this...

This link may help. http://www.tek-tips.com/faqs.cfm?fid=86 It links to tek-tip FAQ 181-86 titled "How do I make text scroll like a marquee". faq181-86

This reply my be a little late to be of help to you, but it may help others. I have used the method found at: http://msdn.microsoft.com/library/default.asp?url=/archive/en-us/dnaro97ta/html/msdn_autooff.asp Sub AutomateExcel() ' This procedure is a brief sample showing ' how to automate...

Bad example of a URL. Please feel free to use the Yahoo version. My error in posting that URL.

I am looking for help on how to use VBA code behind a form in MS Access 2000 to: 1) Connect to a websites URL, example: "http://www.cboe.com/DelayedQuote/QuoteTableDownload.aspx" 2) Pass a string to the webpage to populate a text box. example: "IBM". 3) "Click" on a button on the webpage...

WOW VBSlammer! You are a hero! Have a star and a great day.

For the easy of discussion I have simplified my code to simplier example. I have a form named (frmCustomerActivity) with a command button named (cmdShowAllInvoices) which opens a second form named (frmShowAllCustomerInvoices). This second form is set a Pop Up with border style set to dialog...

I have a long series of global variable names where the last character is a number. Example: MyVariableName1, MyVariableName2, MyVariableName3, etc. I am trying to cycle through this long series using a loop and then read the value of each variable. Dim intLoopCounter As Integer Dim...

Hello Dreamboat and thanks for the reply. When you write that I could try making a copy of the printer, what steps are you suggesting. It sounds like it might work, but I am not clear if this is not the same as uninstalling the same network printer and then reinstalling, and then setting it to...

Paper Source selection changed “by itself” on 800 documents. Hello, I am working on a support call from one of my users and have run out of ideas. The user has an extensive collection of more than 800 word documents with the print settings configured so that the first page will be printed on...

I found this very useful code sample posted else were and thought others might find it helpful. I did *not* write this. I used the code listed in the article in an Access 2000 DB and it worked perfect. The same technique is also outline in the Microsoft knowledge base article # KB179161. The...