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 ?

Thanks guys - Got it all working!

On the Sequence of things??? If table A is Dependent on B and C should I import B and C then A or vice versa?

How can I temp remove the keys, do the import, and replace the keys ?

YUP - the truncate failed on the tables with the F keys...

I'll try moving things around.. Thanks for the truncate tip. That released some zoom into the routine.

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

Make a bunch of controls on your form and hide them. 'Keep count of what you've used in public vars DropB = 1 CheckB = 1 TextB = 1 'DropDown List Me("cmbBox" & DropB).RowSourceType = "Value List" Me("cmbBox" & DropB).ColumnCount = 2 Me("cmbBox" & DropB).BoundColumn = 1 Me("cmbBox" &...

Thanks for all your help..

Using VBA in access 2003 with the VBScript engine checked on so guess I'm rollin' my own After some hard knocks to the head: What about a replace string for IF to a function XX(,,) How can I run a RegExp.Replace to fixup the IF(.,.,.) to XX(".",".",".") for condition, true, false??

I am now ! Try two (this time straight cut and paste): IF( Corner Trim? ,ROUNDTO(( # of outside corners +IF( Inside Corner Trim? , # of inside corners ,0))* Wall Height - Siding ,1,0),0)

Sorry a little misleading in my post. I'm trying to parse out the IF statements. Matching the parentheses. Is this possible? Matches should be: IF(X=1,IF(y=2),1,0),0) and IF(y=2),1,0) EBGreen thanks for the headstart !

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 highly recommend using DTS to "Backup" your data to a SQL Server. Build a daily ODBC read through the DTS wizards. Make sure your PVSW ODBC settings are pointing to an accoutning folder and the proper permissions are in the registry too. Timberline is very protective of itself. Don't be...

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

You have to edit each record. Think of a recordset as a long hallway of doors. So if you want to edit the "door" you have to tell the machine to do so at each doorway. rst.MoveFirst Do While rst.EOF = False rst.Edit rst("[Subscriber #]") = CStr(Replace(rst("SUBSCRIBER #")...

major help - Thank you for your time

Thanks for all the help but I'm unable to break the connection between label and control to set the hyperlink property (it's read-only). I want the end user to be able to click the label of the control, popping up a help sheet for that input box. Me("txtBox" & TextB).Visible = True...