Search results for query: *

I have a gragh on a form that shows data for each month of the year so the grapgh has 12 bars. I would like to be able to click on each bar and have it open up a report or table that shows the detail record for that month. Thank you very much.

I have a graph that plots data for product sales for each month. I need to update the graph with the data for each month as a selection of month name is made from the combo box How do I go about getting this to work? Thanks

Need help with my graph on a form. The graph is based on a query that is sorted by the Month Num, which therefore sorted the Month Name column -Jan, Feb, Mar, etc. However, the graph is based on the month name column so it got sorted by month alphabetically. How do I go about getting it...

Question: I am trying to open a form from a subform. Dim strDocName As String, strLinkCriteria As String strLinkCriteria = "[IssueCount]= '" & Me![tblIssues_subform]![IssueCount] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria The result did not apply the filter. Pls help. Thanks

Both the Design and the New button in the Access form section are dsabled. How do I get them enabled? Thanks very much.

I am trying to import a FoxPro table into Access 2003 with a macro using TransferDatabase. Here are my settings: Transfer Type: "Import" Database Type: "ODBC Database" Database Name: Path where the file reside Object Type: I left this field blank Source: Name of the file.DBF Destination: Name...

Is it possible to pull data into access from Oracle by linking to Oracle tables? If yes, how do I go about doing that? Thanks for anticapated response.

I understad it is possible to automate SSAS backups. How could I edit the backup script below to have it ready for automation? <Backup xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <Object> <DatabaseID>Project_Test</DatabaseID> </Object>...

hello, I am still finding my way around SSAS. Question: How do I run a trace on a cube/catalog/server Thank you

I am using BO 6.5.1. I am creating new report using the wizard and when I get to the step where I need to specify data access, I choose "stored Procedure". However the list of stored procedures in the database are not listed on the next screen. The database is sql server. Has anyone...

Hello - I Need to create a script that deletes certain file types from a folder. For example: Delete file type .log that is > = 30 days old Thanks in advance.

All, I notice a blank page opens up eack time I try to export a report from report manager to any formet eg. Excel, pdf. Is there a way to suppress this page from opening up? Thanks for your help.

I have a table 2 columns (Object and Weight) with data like below: Object Weight(lb) table 5 Chair 6 Computer 3 Computer 5 TV 20 TV 15 Radio 10 Computer 10 Question: I would like to create a new table with one column that would join the above two columns like below...

I have a column that is 8 characters in lenght. The values in starts with: 1) a set of numbers varies in lenght 2) next is 2 spaces 3) then a set of characters that varies in lenght starting with P and tries to spell the word Point. Examples are: 699 Poi 1,314 P 90 Poin 0 Point I would...

All, I have a table CustInfo that stores customer information:FName, Lname, Address, City, State, ZipCode etc. I would like to pull only the duplicate records. In this case those records having the same FName, LName and ZipCode Thanks.

Using variables Startdt, Enddt, how do I determine the first day and last day of a given month. For example if Date1 = 12/24/04 Without hard coding the days, how do I make startdt - 12/01/04 and Enddt - 12/31/04. Thanks.

If you have a variable JobTitle having "busines manager" How do I code VB to check that Variable jobTitle contains the word 'Manager' Note: This variable always has 'manager' as the last word in the string Thanks.

What is the SQL code to define variables @Begindt to generate 12/01/2004 @Enddt to generate 01/01/2005 Thanks.

I am trying to insert an identical set of colums to an existing table1. A column in the new set of colums has some null values ' ' that needs to merge with the existing column in table1. I think this is why I am getting the following error. "String or binary data would be truncated. The...

How could one replace the Null values on a column joined with the Left Outer Join command to zeros - 0 This would make it possible to do some calculation with the colum. Currently I am getting Nulls when I subtract that column from another. Thanks you.