Recent content by jibberski

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