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

    Refresh Linked Shapes on Document Open

    I created a company org chart that connects to an Access Database. Using the org chart wizard, I set it to 'refresh linked shapes' custom properties on document open', however, when I open the visio(2002) file, it does not automatically update changes made in the database, I must manually...
  2. susanbl

    Access ADP Expression Builder

    I upgraded Access from 2000 to XP and now the expression builder is no longer available in the adp file I created in 2000. How do I turn it back on or what do I use in its place? Thanks in advance.
  3. susanbl

    Saving Report Designs

    A while back, we had our Access database (mdb) converted to SQL Server. Unfortunately our front-end software had some bugs in it and we had to revert back to the mdb. In the mean time though, I have been creating custom reports in an adp front-end which is connected to the converted database...
  4. susanbl

    Help with SQL Server Syntax

    I was thinking along the same lines so changed the CASE WHEN Statement from: CASE RateTable.Project WHEN NULL THEN a.Rate... to: CASE WHEN RateTable.Project IS NULL THEN a.Rate... and it works!! A big thank you!
  5. susanbl

    Help with SQL Server Syntax

    I added the a.Rate to the beginning of the select list and it returned the same value the exception rate. Then added it to the end of the select list and it brought back a null value again. In both cases, the view created a new column0? Sorry, I am not much help - this is all so new to me.
  6. susanbl

    Help with SQL Server Syntax

    Thanks SQLSister, This codes works (I am getting two lines not four) but it didn't pick up the rate for the ALL project - left it blank? And thanks for the tip SQLBill - my first time posting!
  7. susanbl

    Help with SQL Server Syntax

    I am building a stored procedure in an Access ADP front end to a SQL Server backend referencing a table that lists trade rates. The table includes the trade, the rate and the project # and is linked to a HoursTable which also includes the trade, project #, and the number of hours worked. They...
  8. susanbl

    Help with SQL Server Syntax

    I originally posted my problem on the Access ADP forum but it was suggested that I repost it here. Please refer to Thread 958-916853 - any help you can give me is appreciated. Thanks
  9. susanbl

    Problem with SQL Stored Procedure

    Thanks again - I will repost as suggested.
  10. susanbl

    Problem with SQL Stored Procedure

    To simplify, I would like to see: HrsTable.Trade HrsTable.Prj HrsTable.Hrs RateTable.Rate Apprentice 528 10 20.00 Apprentice 529 20 21.00 Rather than: HrsTable.Trade HrsTable.Prj HrsTable.Hrs RateTable.Rate Apprentice 528 10 20.00...
  11. susanbl

    Problem with SQL Stored Procedure

    I am building a stored procedure in an Access ADP front end to a SQL Server backend referencing a table that lists trade rates. The table includes the trade, the rate and the project number and is linked to a HoursTable which also includes the trade and project number. Because there are...

Part and Inventory Search

Back
Top