Search results

  1. J

    Split Form does not show data in table

    I have made a form and put the Default View to split form. It was working just fine until today when suddenly the datasheet view showed an empty table. I have checked the table itself and it contains the expected data. The record source of the form is the table tblExpenses. In an effort to...
  2. J

    TextBox as a Sub parameter

    I am having a problem using a TextBox as a parameter in a Public Sub. I have tried passing it as a string, as a property of a form and with no luck. I am lost. It compiles but will not run without errors. I am an Access Rookie. Here is the code of the sub: Public Sub AllCostsMTD(frm As String...
  3. J

    Table and Form as Sub Parameters

    I am an MS Access rookie. I am trying to create a sub routine in a module and would like to have two parameters in the Sub. The first parameter is the name of a table, and the second the name of a form. In the code below I have only put the type of parameter I would like to put in the sub...
  4. J

    ORDER BY is not working

    I have a form "frmWeightReduction". From that form I am opening another form "frmDietExercise". I have written the following SQL statement. Upon opening the "frmDietExercise" the records are in random order and not as in the SQL statement. I am a rookie. Any help would be appreciated. Here is...
Top Bottom