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 TouchToneTommy 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: *

  • Users: budbeth
  • Content: Threads
  • Order by date
  1. budbeth

    Calculation with more than 1 Fact table

    I'm new to AS 2005 and am not sure the proper place to put this.... I need to be able to access the following in other cube calculations: Previous Month Current Balance: SELECT CURR_BAL FROM PERFORMANCE P INNER JOIN MASTER M ON P.ACCT_OID = M.ACCT_OID WHERE M.PROCESS_DT =...
  2. budbeth

    Late Bind Excel SaveAs

    In VBA, I'm trying to open a .csv file and SaveAs a .xls file. It will work with early binding, but I have to use late binding due to different versions in use here. The following code will work up to the SaveAs line. Then I get an error #1004, "...Programmatic access to Visual Basic Project...
  3. budbeth

    Control Flow Language

    I need to do the following in a trigger: IF NOT EXISTS(SELECT...) --record doesn't exist IF inserted.CODE = "N" --CODE = "N" INSERT INTO... SELECT.. FROM table ELSE --record doesn't exist & CODE = "S&quot...
  4. budbeth

    Pass Variable from Access to VB

    Does anyone know if this can be done? I have a Public variable (strItem) in my VBA code and want to pass it to my VB.exe I'm trying to get the VB.exe to grab the variable and use it to find records for my DataGrid. Any pointers the the right directino are much appreciated... Beth L
  5. budbeth

    ADO Control Problem

    I'm trying to use the following to look up records. I think my problem is the second RELATE - Loc TO Loc. When I use only the first RELATE - Item_No TO Item_No I get too many records. I need to filter by the second RELATE but can't seem to get the syntax correct, no matter what I try... SHAPE...
  6. budbeth

    This code stopped working after I g

    This code stopped working after I got a new machine. I've checked the references and don't have any missing. I keep getting the error: Run-time error '-2147467259(800004005)': [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied. Any suggestions of what could be...
  7. budbeth

    VB 6 Compile w/o DSN & DB on local network

    I have an exe which tests perfect using my local network info. When I edit the Adodc control and connection string info (server, uid, pwd and database) to work on a different network, I continually get the following error: [Microsoft][ODBC Driver Manager]Data source name not found and no...
  8. budbeth

    Sending two attachments

    Does anyone know how to use the crwrap.bas to send two exported Crystal reports in one email? I can send each one individually, but am having no success doing both in one.
  9. budbeth

    Sending multiple attachments

    Does anyone know how to use the crwrap.bas to send two exported Crystal reports in one email? I can send each one individually, but am having no success doing both in one.
  10. budbeth

    Subreport Excel Export is Blank

    I can export a Crystal 7.0 report in .rtf and have the subreport numbers appear, but when I try Excel (version 5 & 8) they don't. What gives ?? Anyone else have experience with this?
  11. budbeth

    How to Quit VB when through

    I'm feeling kind of stupid here - checked 4 or 5 books, Web searched, Vb Help and still can't figure this out! What code do I need after my Unload frm to close the project and Visual Basic both?? TIA

Part and Inventory Search

Back
Top