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

Access 95 on Windows 2000 data fills report and chart from a query, which is composed of queries and tables as for the database window sometimes openning way in the far right lower corner(have to drag scroll bars of screen all the way to right and down-not the lower right of the screen that...

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