Search results for query: *

Has any one run into an instance when performing an XP install on a new drive and having NTFS secondary drives attached and when the install gets to the choose partition it doesn't recognize the existing partitions on the secondary SATA drives? I installed XP twice. First on a blank drive and...

Yes. That worked. Thank you. I couldn't find the options button.

Using Excel 2007 and with cell formatted as Number I have to enter 5. or 500 for cell to equal 5. Even if decimal place = 0 it does not accept it as a whole number. Even if start with TEXT cell format if I change the cell to number it converts the value to a decimal moving the decimal two...

I think I found it. It seems to have to do with me.allowedits logic. When I click on the edit record button, I can toggle between them, but have to click on edit record button each time and the filter works. So I guess I have to have me.allowedits = true even when filtering?

Created an option group for filtering the records (all and Retention) with two buttons. But the form is not toggling between the buttons. I used the wizard to build it and selected "Save the value for later use." I tried it in Access 2003 and Access 2007 with the same problem. It works in an...

Very bizarre. All of a sudden, every time macro buttons in my Excel spreadsheet are clicked the text shrinks. Format controls everything in locked and no size changes, etc. I checked the following thread and it does not apply as no windows are frozen. thread707-1042392 Any ideas? Jimi

Thank you! That did the trick. I have been out of "it" for too long! Dim RetVal RetVal = Shell("C:\WINDOWS\NOTEPAD.EXE", 1) ' Runs Notepad

Hi, I don't have access to Schedule Tasks in Window due to our info security gustapo. So I cannot automate running some reports and hope there is a way to initiate external applications from within an Excel spreadsheet. I tried "application.run "'filename.ext'" and it cannot find the file. Is...

Thank you, but what you provided copies the whole range A1:F154. That's the problem, I don't want the whole range of the table. There are no blank cells in the whole table as shown in my examples. Cells in column A (A1:A154) contain commas (,) and cells in columns B - F contain dashes (-)...

I have an ugly spreadsheet that I inherited and want to select a range of cells in a table to copy (and send out in an email) based on finding the last row of usable data in the table. The table is fixed:6 columns x 154 rows RANGE(A1:F154). Data is copied and pasted into this fixed range...

White605 gave me this link showing examples: http://www.ozgrid.com/Excel/run-macro-on-time.htm Works great! I have a macro kick off every hour on the hour using it.

Is there a way to have MS EXCEL kick off a macro once an hour? (working on the Access version, but in the meantime...) I have a report that is run ~ once an hour using imported data. I can't find anything that describes a timer or event that can do such a thing. Is this something I have to...