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

Thanks, Denny. My first attempt was not successful as it gave me more records than expected. Then I realized one of the source tables has lots of blank/null values in one of the key fields. Once they were filtered-out, Merge Task worked like a charm. Thank you very much.

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

Thanks PHV for your help and the quick response. 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

Thanks, linmey. I've browsed through most of those threads and other related topics and had the impression that iexpress is easy to use based some people's comments. I thought maybe there's something missing after following the step by step procedures in one of the sites.

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

Not sure if it's the best solution but it looks like it's working. I created a temporary table with a single hyperlink field and bound to it a textbox in my form. Now I can drag and drop my saved email to the textbox and use it to populate my records. Hope others may find this useful.

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

Hi dhookom, Are you using Page of Pages on your report? -Yes, but tried deleting it with not much of improvement. Are sections set to allow growing or keep together? - Can Grow/Shrink set to NO - Keep together set to Yes Why are you setting control sources at run time? - users have the...

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

Even with a separate datasource for the main report with a single record per province, it didn't work. The error message is "You can't set the ControlSource property in print preview or after printing has started". It looks like Access won't allow changes in subreports data. Maybe it's Access...

The txtMainRptProv is a textbox in the maint report with controlsource = ProvID. Since both main & subreports use the same datasource, there are multiple records per province. In main report, there's grouping by ProvID. The group header has the province ID & full name while the group footer has...