I am coverting a report that has calculated controls on it over to Excel. I click the Office links button on the toolbar and it converts the data over to Excel. It brings over the data that appears in the rows on the report, but it does not include the calculated controls which are subtotal...
Does anyone know if there is a command in Access that yeilds the same results as Compute in SQL Server 2000???
Basically want to show a Sub total and total of columns in an Access Query
Thanks.
I am coverting a report that has calculated controls on it over to Excel. I click the Office links button on the toolbar and it converts the data over to Excel. It brings over the data that appears in the rows on the report, but it does not include the calculated controls which are subtotal...
I have a database that has a search screen that allows users to type in a piece of criteria and then search for it. It displays the results on a "Results form" and allows them to scroll through as many records as is returned. It also allows them to view in datasheet format which more...
I am attempting to script up a database that was built in Access 97 up to Access 2000.
The database works fine on Windows 98 - Access 97, but when I attempt to open it in Windows 2000 - Access 2000 it ask me to convert the database to Access 2000. When I say yes, it begins to convert the...
I am running a query and then displaying the results on a form. This works fine. I set the Record source properties of the form to my query and it displays nicely. Now, I would like to have about 7 more queries that would display on a form. The only way that I can think of getting around...
I am running a query and then displaying the results on a form. This works fine. I set the Record source properties of the form to my query and it displays nicely. Now, I would like to have about 7 more queries that would display on a form. The only way that I can think of getting around...
I am having trouble setting the default value in my combo box. What I am trying to do is have a particular value in my list show up first when a form is opened. My list is being pulled from a table in the DB. I have tried writing an expression in the expression builder section of the combo...
In Access 97, you can build forms using the Form Wizard which offers a few background color schemes i.e. Clouds, Evergreen, International, ect.
My question is, does access allow you to add you own color schemes behind the forms, specifically a Logo. I would like to Tile my Companies Logo...
When I click on my database to open it up, while opening, it first flashes to the (Tables, Queries, Forms, Reports, Macros, Modules) screen and then opens to the switchboard.
Is there any way that this can be avoided and the switchboard can open immediately?? It is not that big of a deal, but...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.