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...

Thanks. I wish I could do that -- it would make life simpler. But I need to set this up for users who don't have a clue how to use access. They need to open up their spreadsheet and refresh the pivot table. I guess that if there's no way to get past the undefined function, I'll have to set up...

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 run into the same problem. 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 would need to rewrite the query to...

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...

Thanks. I was on a wild goose chase trying to figure this out. So does that mean, if I want to set up some cubes for end users, that I'd have to build everything on the server and tell them to RDP in order to use the cubes? seems odd...

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...

yes, it does the same thing -- just copies a link

wow. why does it do that?

Why not just use the Round function? e.g. round(3750*.0225,2) will round to 2 decimal places. Note that this is different for formatting to show 2 decimal places. The function will return the rounded number, so it should work in subsequent calculations.

Assuming each type can be either Hardcover of Softcover, both not both: You would create another table, call it tblCover. You would have 2 fields in the table, one for the Type and the other for your CoverType. The entries might look like this: Romance Softcover Golf Softcover Comic...

You can. Search the help for "conditional formatting" good luck

If you want to show 5 records on one row in your subreport, you'll need to create a 5-column layout. Let's say each field can fit in one inch of space horizontally. Create a report with just a detail section. Drag your data field there and adjust the right margin so that it's at the one-inch...

I'm having trouble understanding why you need 2 subforms to get this done. Please explain what you're trying to accomplish. Usually, when you see errors like that, it's because the main form record might not be saved yet when it tries saving the record in the sub-form. I always try to avoid...

Is it correct to assume that one of the Shares or Amount fields is always null? Meaning, either you have an entry for one or the other, but never for both? If so, it's pretty simple. Base your report on a query that includes the following calculated field: SharesAmount: =nz(shares,amount) see...

I don't really understand your second question about categories, but I'll give your first question a shot. 1) One method is to base your report on the records in Table 1. Then write code attached to the OnFormat property of your detail section to: a)Find the related records in Table 2, and...

make sure you put an = in front of the calculation. i.e., the control source for your text box should read: =DateDiff("n", StartTime, StopTime)

In the BeforeUpdate event of your Form, you can write code that checks to see if certain fields have been filled in. You can also check for legitimate values in those fields. Example: If isnull(me.LastName) then msgbox "You must enter a Last Name" me.LastName.SetFocus cancel=true end...

Firstly, I'm assuming that there is a many-to-many relationship between your Projects and Contracts. Otherwise, if a given Contract only relates to a single Project, then you can create a one-to-many relationship between Projects and Contracts, eliminating your match table. Given that...