Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jibberski

    WSS 3.0 and RS2000sp2

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

    DTS to Sql express(2005)

    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 ?
  3. jibberski

    Relationships causing problems

    Thanks guys - Got it all working!
  4. jibberski

    Relationships causing problems

    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?
  5. jibberski

    Relationships causing problems

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

    Relationships causing problems

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

    Relationships causing problems

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

    Relationships causing problems

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

    Programtically create text boxes

    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" &...
  10. jibberski

    RegExp for Nested IF

    Thanks for all your help..
  11. jibberski

    RegExp for Nested IF

    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??
  12. jibberski

    RegExp for Nested IF

    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)
  13. jibberski

    RegExp for Nested IF

    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 !
  14. jibberski

    RegExp for Nested IF

    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!
  15. jibberski

    Trap Eval

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

    Timberline 9.2.1 and ODBC with ASP

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

    Access Smart Tags

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

    Updating Recordset

    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 #")...
  19. jibberski

    HyperlinkAddress is Read only

    major help - Thank you for your time
  20. jibberski

    HyperlinkAddress is Read only

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

Part and Inventory Search

Back
Top