Search results for query: *

Is there VBA code I can run from within Access to determine whether or not another application is running, and if not, to start it? Also, is there a way to determine, when a user runs an MDE, whether or not another instance of that same MDE is already running -- and if so, to just switch to...

I am using an Access query as the data source for an Excel pivot table. My Access query uses a custom function which generates the "undefined function" error when I try to base a pivot table on that query. I tried pasting the function into an Excel module, but that didn't help. I'm guessing that...

I have defined a time dimension based on a date field in my fact table (needed a quick and dirty analysis). For my analysis, I need to look at weekly aggregations. However, my company's week starts on Monday. I know that in a stored procedure, I would be able to SET DATEFIRST before using the...

I'm sorry if this is a no-brainer. I'm brand new to AS. I've installed AS on a local workstation and I'm trying to build a cube that connects to data on a SQL Server in the same domain. When I set my data source, everything seems fine, i.e. the Test Connection works and I'm able to browse rows...

Can anyone tell me if this is possible? I have populated a TreeView control on a form in the Form Load event. After the view is populated, I test for certain conditions (not available when the TreeView populates) that would require me to change the Parent node of some of the existing nodes...

I am trying to use the Line method to draw a rectangle around the detail section of my report. The detail section contains 2 subreports, both of which CanGrow. The detail section itself also CanGrow. I am calling the line method as follows (snippet) from the OnPrint of the Detail section...

I have an Access 2002 app spilt into front and back-end MDBs. I'm trying to write a function that will archive data on the back end once a year. My first though was to use the CopyObject function to create a new copy of my table, give it a new name, and then delete records to prepare for a new...

In Access 2002, I'm trying to use a Select Case statement to assign a time of day to a particular shift (numbered 1,2, or 3). Here's a code snippet: myEnd is a date/time parameter passed to the function. For now, I only care about the time portion. Select Case FormatDateTime(myEnd...

Hello all, Can anyone tell me how to drag and drop a selection from a list box onto a Tree View control? I'm using Access 2002 with the Microsoft TreeView OLE control. The application is for seating guests at a wedding. The List box contains all guests that have not yet been placed at a table...

I have a Main form (an invoice) with a subform containing line items. The footer of the subform has a calculated text box containing a total. I want to set up a text box in my main form, bound to the record that is displayed in the main form, that copies the value from the subform footer. Should...