Search results

VrtAugerSpd%TIA: 1-([SumOfVrtAugerSpdTIA]/[SumOfRunTime]) ...is one of many fields in a query. Converting to sql server 7 view or sp is touch. can anyone rec a website that has examples of access jet being converted to transact sql ?

Someone recommend me a book for access 97 VBA(intermediate to advanced). I have beginning access 97 vba by smith and sussman wrox books-love it...but I need a more in depth, i wish to write vba all over access-need a large well written book to do the job...any rec for me.

1. Any vba or api to hook the user action of clicking F-11 to pop up the database window? 2. Sometimes a report opens fine, sometimes it opens with no data! Is it because I am using Access version 95, or does it need a requery or refresh method, or ... any ideas post back or email me at...

1. Any vba or api to hook the user action of clicking F-11 to pop up the database window? 2. Sometimes a report opens fine, sometimes it opens with no data! Is it because I am using Access version 95, or does it need a requery or refresh method, or ... any ideas post back or email me at...

How can I prevent the occasional unpleasentry, when I click F11 the database window sometimes goes to the extreme lower right corner?? Also, sometimes when I open a report, it displays incorrect data. If this happens, I open and close the report till I get the correct data. Any ideas in solving...

How can I prevent the occasional unpleasentry, when I click F11 the database window sometimes goes to the extreme lower right corner?? Also, sometimes when I open a report, it displays incorrect data. If this happens, I open and close the report till I get the correct data. Any ideas in solving...

If my client's data range contains no data, and he opens a report...an obnoxious built in message says "no data". Despite adding cancel=-1 to open report method, it crashes. How do I have it: if a report has no data, I wish the report (with code you advise me) to close the report-how do I do this??

1. I have just built some access charts, and sometimes when I or a client clicks one open...it will display no data when there is data. When it is closed and reopened, the normal data then shows. Anyone have a cure/idea/longshoot for me. 2. I have a report which displays the date in the...

1. I have just built some access charts, and sometimes when I or a client clicks one open...it will display no data when there is data. When it is closed and reopened, the normal data then shows. Anyone have a cure/idea/longshoot for me. 2. I have a report which displays the date in the...

On forms I can remove and rebuild record selectors and close buttons, but how it this done on reports?? mike michael.lynn@us.gases.boc.com

On forms I can remove and rebuild record selectors and close buttons, but how it this done on reports?? mike michael.lynn@us.gases.boc.com

How can I have a chart display data where the tallest columns begin on the left, and as they go right they get smaller (Pareto Chart). The y-axis represents percentage of inefficiency in a factory areas, the x-axis rep seven factory areas. A factory manager would like to see from left to right...

How can I have a chart display data where the tallest columns begin on the left, and as they go right they get smaller (Pareto Chart). The y-axis represents percentage of inefficiency in a factory areas, the x-axis rep seven factory areas. A factory manager would like to see from left to right...

How can I have a chart display data where the tallest columns begin on the left, and as they go right they get smaller (Pareto Chart). The y-axis represents percentage of inefficiency in a factory areas, the x-axis rep seven factory areas. A factory manager would like to see from left to right...

How can I have a chart display data where the tallest columns begin on the left, and as they go right they get smaller (Pareto Chart). The y-axis represents percentage of inefficiency in a factory areas, the x-axis rep seven factory areas. A factory manager would like to see from left to right...