Search results for query: *

I want to query the suppliers table for vendors added to changed on a certain date. PL010200 seems to be the table but cannot find the field for the date added/changed. Can anyone help? Thanks a lot.

Is it possible in to have two different chart types for two different series group in Reporting Services 2008 (or Report Builder 3.0). For example, in one chart Budget figures are represented by a line graph while Actuals are in bar graph. Thanks

I'm working on a financial report with current period, year-to-date columns and comparative columns for same period and year-to-date from prior year. Datasource is a cube but unfortunately, it doesn't have the PriorYear_Period and PriorYear_YearToDate as measures. Cube has FiscalYear dimension...

We have our databases on SQL 2008 Express which we want to move to a different machine with SQL 2008 Standard. The databases are relatively small. After doing the necessary configuration, how much work is needed recreate the databases? Is it possible to restore Express backup into the Standard...

My SSIS package imports data from a text file. The Data Flow works fine until reaching a certain row and it gives out error message "[Flat File Source [1]] Error: An error occurred while processing file "myFile.txt" on data row 663207." Upon checking, data row 663207 is a blank row but not the...

I'm using Cisco VPN client version 5.0.03.0560 in my laptop with Windows Vista. When trying to connect, this error message show up when trying to log-in "Failed to enable Virtual Adapter". The surprising thing is one time it works, the next time, it doesn't. The last time it didn't, I just...

I'm trying to write an SSIS package with 3 important tasks. Task 1 queries from a couple of joined tables. Task 2 queries from another couple of joined tables. Task 3 joins results from Task 1 and Task 2 and write the results into a staging table. My option at the moment is to use view for each...

My spreadsheet has hyperlink that points to say, cell A50. When selected, it goes to A50 but at the bottom of the screen. How can I make it display as the first cell on the top right of the screen? Thanks for the help.

I have one main report with 3 subreports using the same recordsource (say, qry_Source). Each time a subreport is opened, the recordsource is re-queried. Question: Is there a way to requery the recordsource only once instead of 3 times? Thanks a lot. jj

I copied an mdb from another computer. Its queries has the WITH OWNERACCESS OPTION. Now when I created a new mdb in my computer, the new queries have the same option as default. Is there a way to disable this option? What is its implication if I distibute my mdb's to other users? Thanks. jj

I have a VBScript (MySetup.vbs) that creates folders (C:\Documents and Settings\#UserName#\All Users\MyCopyFolder) and copies files (icon, shortcuts, mdb) from a shared network drive and to user's folders. It works fine. Now I want to create a self-extracting file using iexpress. I included a...

I have a table with one of the fields as hyperlink to store saved email messages. While I can drag and drop the saved message from a folder into each record, it would be nice to do it in an unbound textbox (in a Form) and update all the records in the table at one time. I tried creating a...

I have a set of reports with running time ranging from half a minute to 2 minutes. Another set of reports takes only 15 to 20 seconds and both sets are using the same query (tried query of linked tables and pass-thru query, there's not much difference). The reports have sorting and grouping in 3...

My access main report looks like the following, where revenue and expenses portions are subreports with page break by Province: (all reports are using the same dataset/pass-thru query) Province: BC Rooms Revenue xxxx F&B revenue xxxx Others xxxx Total revenue xxxx Rooms expenses xxxx F&B...

I've read all the threads about this subject but still can't seem to make it work for me. My form accepts input from user to run a query and reports. To inform the user of the progress of the processing, there's a textbox which is given a value of the status. The form has the following with...

I'm ready to email an Access report using SendObject method. The recipient names (first & last) are in Access table and this will be used to search the Outlook address book (not from Contacts folder). Would somebody show me how to "read" the address book from Access using VBA codes? Thanks and...

My DTS package transfers data mostly codes from temp to master table. The master table has 10 description fields for each of the codes. These description fields are then populated using update statements joined with 10 description tables. However, the update process is so inefficient since a...

I have a DTS package with a query to pick up data between Date1 and Date2. At present, these two variables are defined as Global Variables as parameters. If these variables are stored intead on a table on same database which can be managed/changed by another program (say, Access), how can the...

I have the following tables: Table1 keyFld fldGroup fldAmount fldA fldB key1 A 10 key1 A 10 key1 B 10 key1 B 10 key1 B 10 key1 C 10 key1 C 10 Table2...

My PS Query is giving out this error message: SQL error. Stmt #: 0 Error Position: 0 Return: 8150 - Left-of-decimal digits truncated from FETCHed value (SQLSTATE PS150. Has any encountered it and how is it resolved? The query runs perfectly using SQL Query Analyzer with some rows showing .00 in...