Search results for query: *

Any chance Sharepoint 3.0 will work with Reporting Services 2000 sp2? Trying to take advantage of the free templates and advanced layouts. Thanks, Jibber

The sql server 2005 upgrade was cut from my budget. I'm developing a client app utilizing sql 2005 express and sql server 2000. Is it possible to use SQL 2000 DTS (or any other methods) to broadcast upgrades to the client machines ?

I have an app that uses over 100 flat files that I import via DTS. My routine Drops all the tables in the DB and then imports them. I recently have begun development on this DB and need to relate some tables. Once I create relationships I can no longer simply drop and import. So I've...

Trying to setup pattern to return the outer If statement Expression: IF(X=1,IF(y=2),1,0),0)*5/3 Returned should be: IF(X=1,IF(y=2),1,0),0) Here's what I have for a pattern: (IF\()+(.)+\) Thanks for your help!

Is there a way to test the function Eval() for a valid return? I'm receiving Error 2425: "The expression can't be found" 'With formula table Do while not .EOF strAnswer = !formula For Each ctl In Me.Section(acDetail).Controls Do Until InStr(1, strAnswer, ctl.Tag) = 0 strAnswer...

I've been searching for hours on building a smart tag inside VBA. I'm trying to create a nice pull down to lookup references on the items in a datasheet. Is there a sample DB or a tutorial out there that I can learn from. Am I crazy for wanting to use smart tags? Thanks for your time. Jibber

I have a form that unhides controls and sets the caption for the label. Can I make a controls label a hyperlink? Here's my error: The HyperlinkAddress or HyperlinkSubAddress property is read-only for this hyperlink.

GRRRR - frustrating error Using access 2003: How do you handle a Dlookup with a single quote in the criteria? ie < O'brien > or < The smiths' > Nz(DLookup("[TotalSales]", "SalesTeam", "[Name] = '" & StrV & "'"), 0) Produces Runtime error 3075: syntax error in string in query expression...

Using VBA for an access 2003 sales app. Does anybody know of an eval function, library, calc tool, algebra tie-in, or addin that will run 'if' statements? I have a large table of calculations that are used to get my total items count. ie if(x=1,120,0) I can parse this into variables...

I have built a portable Access app to use for our sales team. Because of the security needed our app must be an executable (no linked tables). When our sales staff return from the road I would like to update their app with the new commodities pricing on our SQL server. Is there a simple...

I am able to complile this DLL but unable to register it using: regsvr32 "c:\...\2.5\bin\CRUFLTest.dll" Receive the error: Entry point not found Wrote the code in .Net and have Crystal 10 OEM for Timberline References include system system.data system.XML Public Class CRUFLTest Const...

I'm trying to create child nodes in a treeview dragged in from a listbox. There have been two posts(archived) on this but no answers. I have read the MSDN on simulating the drag and drop also but concerned about dropping the "foreign" listbox object to the treeview. Does Anybody have this...

I’m using Access 2003 and would like to dynamically add controls to a form. However I could not find any info specific to access 2003. Does Access 2003 still require the forms to be in Design Mode to write in controls? Is there still a limitation of 754 controls that can be added over the...

I'm trying to compile a list of Variables from a DB of stored formulas. Below is a basic 'if' statement with V(<VarName>) denoting the variables. String to be parsed: IF(V(# Diff Door Sizes)>0,V(Door 1 Count)) How can I loop through to parse the above string in order to store '# Diff Door...

I have an application that stores data using iterators (as below) ID Description Level 600 Demolition -1 670 Demo Exterior Flat Work 0 675 Remove Foundation Walls 0 680 Remove Concrete Stoops/Steps 0 900 Concrete Curb...

Using Timberline ODBC and access to pull data and FTP to our subcontractors portal website. I'm trying to automate this process for our users and have everything set except for the ODBC login window. How can I grab the pop up windows focus and send the proper login? The login's are dynamic...

I'm trying to automate putting a report away on our docs server. I'm running CR9 for Timberline. I must run the report via Timberline's Report Manager (timberline proprietary odbc) so no 3rd party app will work. However, is there a way to code an automatic export ( or hyperlink to ) the...

Keep getting an error on this! How to I reset the flag "Tops"? ///////////////// Shared BooleanVar Tops; Switch( {@Job} = "5199", 2, {@Job} = "5299", 3, {@Job} = "5501", if {@Tfound} = true then Tops:= False; 4, ) Thanks for your time!

I would like to set some flags in my database after the report is run. How would I go about having CR9 connect and execute an insert SQL command at time of execution? Thanks for your time!

I would like to ease some user pain. Is there a way to change the formula name for exporting? IE ( click the envelope with the red arrow, select pdf, and the filename is set from the data within the report)