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

    Calculated controls not showing up in Excel

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

    Command in Access that does the same as Compute in SQL Server 2000

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

    Converting Report to Excel

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

    A query that allows to modify but not delete??

    GingerR I tried your suggestion above, but it did not work. My form is based on a query and displays it's results correctly. That part works fine and the end user has no means to delete records from the form. The problem is when I allow them to view there results in datasheet format. That...
  5. Muddman

    A query that allows to modify but not delete??

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

    Upgrade from Access 97 to Access 2000

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

    Can you update the record source through VB

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

    Can you sent the Record Source properties Through VB

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

    Setting the default value in a combo box

    I tried puting this in the default value of the combo box =[ComboBox Name].[DefaultValue] = "String in ComboBox" Also =[ComboBox Name].ItemData(N) N equaling the position the combo Box Does this Help
  10. Muddman

    Setting the default value in a combo box

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

    Changing Background style of a form in Access 97

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

    Opening to a switchboard???

    Dustman, Thanks for your help, it worked great.
  13. Muddman

    Opening to a switchboard???

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

Part and Inventory Search

Back
Top