Search results for query: *

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

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.

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

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!

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.

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!

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

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

Thanks again - I will repost as suggested.

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

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