Search results for query: *

Long story short, I create a report in Microsoft Excel by using OLE automation to move data from Microsoft Access to a blank worksheet using a Row/Column loop. Now here's the question: From a speed & file size perspective is it quicker (with automation) to apply Cell formatting: One Cell at a...

I'm re-writting a routine I wrote a couple of years ago that calculates US holidays that's used primarily in MS Excel and Access. The original routine uses static dates to do the calculations so each year it runs a little slower so I figured it was time to re-engineer. I'm lucky in that I'm...

Hello, So I building a custom graphing engine in Excel (2000 SR-1/2003). I'm working with a single chart sheet and want to create a vertical line (shpTracker) that tracks the mouse pointer in the Plot Area of the chart. Eventually the line position will update a 'dashboard' with statistics that...

Du2good, Shell("C:\Program Files\E!PC\extra.exe C:\Program Files\e!pc\SESSIONS\somesession.EDP") Where the first path is the executable Extra and the second path is a valid session (*.edp) The usage in a funtion or sub would be Dim dblExtra as Double dblExtra = Shell("C:\Program...

Has anyone run across a built in routine in Excel that will allow you to prompt a user to select a range from a workbook/worksheet and return the range object to a macro? I'm looking for something similar to button that is available in the Formula Palette that lets you select a range of cells...

Short story: Does anyone know how to write the formula for and worksheet cell that adjusts when a filter is applied. For the sake of discussion lets say I'm calculating a loan balance (well that is exactly what I'm claculating) that is based on the previous balance [R-1] plus current activity...

Scenario: * I have data contained in a web page that uses an https connection that I need to capture. * During regular use I have at least 2 Internet Explorer windows open, and 1 possibly 2 Explorer windows open. Question: What is the trick to differentiating the difference between an Internet...

I have a report that calculates a ranking by performing a Shell sort on a data array that is populated when the report opens. Because of this the report has to be generated twice before the resulting calculation is correct, i.e. if the report is opened to the screen (preview) or printed directly...

I looked through the forum and did not see this topic. I have an ubound, memory resident, ADODB.Recordset that holds the data I need on my report. Because the data is not stored in a table I cannot use Report.RecordSource property. The code is all written to generate the report but here is my...

Has anyone run across a method to output a report in native Word format and not Rich Text? I have been tasked to figure out a way to do this and I don't want to reinvent the wheel if I don't have to. Thanks in advance for any input you can provide.

I am trying to build a query that classifies 95 odd transaction types into 12 classifications, the problem that I have is there are four TransactionTypes that are classified differently depending on other fields in the record, in the table Classification I have a field (Exclude) that contains...

Does anyone know of a built in function/method that will move an entire record out of one table and into another (the elusive archive query)? I know I can do it in code but I'm hoping that Microsoft has done it for me.

I have a form that renders a 12 month calendar, it has 504 controls that need an On_DblClick event. All 504 controls were created with a function, I also wrote a function to build the On_DblClick event for each control, now here is my dilemma. The control's on the form do not recognize that they...

Does anyone know how to pull the GMT adjustment value from Windows 2k for use in a Access Function?

I have a subform with 504 rectangles on it that are used to represent an annual calender, what I would like to do is have a user double click on a rectangle and it open a different form. I know how to do all of this but I am wondering if someone knows a way to get around having to write 504...

Working for a bank almost all data input by my database users are currency. Does anyone know a way to have Access add the comma seperators in real time as the user enters a number, alot of the amounts we enter are round numbers over $1mm and counting zeros is a pain. I did try to use a mask but...