Search results

  1. K

    Calling a function from a command button

    Hello Everyone, I have been more involved with Excel VBA and I am getting back into Access vba. I have the following code: Private Sub Command2_Click() Call TableInfo DoCmd.OpenTable "DBdata", acViewNormal, acReadOnly End Sub Function TableInfo(strTableName As String) On Error...
  2. K

    Converting Access 2007 Reports to SQL Server 2005

    Hello All, I am converting some Access 2007 databases to SQL Server 2005. I understand that my forms will have to be recreated in ASP.net. I am evaluating some software to help with the conversion. I would like to see if anyone has used anything that they really liked and why. Another...
  3. K

    Using Access VBA code to count all forms, tables, queries, reports, vba modules, etc.

    Hello Everyone, I know it can be done and I have seen some code snippets before, but how can I use Access vba code to count all forms, tables, queries, reports, vba modules, objects to get a total count of each for an Access database? Any help is greatly appreciated. Thanks, Kurt :)
  4. K

    I have the same row in an item description that I only want to appear once

    Hello All, How can I get this to appear once and sum on a field? Let's say the field name is Owner_Desc and the field I want to sum on is Volume. What kind of formula would I need? Thanks for the help from yesterday's question. Thanks for reading! Have a great day! :) Kurt
  5. K

    Formula syntax error

    Hello All, I am having problems with this syntax in Cyrstal 10 Formula editor: If {ORDER_MV.O_CAT_TYPE} in ('TS') and {ORDER_MV.OM_REPORT_GSV} >=1 Then {ORDER_MV.OM_REPORT_GSV}; I want it to display the results of {ORDER_MV.OM_REPORT_GSV} when the condition in the IF statement is met...
Back
Top Bottom