Search results

  1. I

    Permanent filter on form based on unbound text box on another form

    The problem is where you have your quotes located. The way your quotes are placed, you're specifying the month 'Me.[Month of Forecast]' instead of the value in the field Me.[Month of Forecast]. It should look like this: DoCmd.OpenForm stDocName, acFormDS, , "Month([Backfill Info].[Month]) =...
  2. I

    getting total number of records off a table

    Try using dcount("field","table")
  3. I

    query using list of values from a field in another table

    Try using this in place of your current where statement: WHERE (((TblTasks.TeamDetails) like "*" & ([qryWhoAmI]![teams]) & "*"))
  4. I

    Crosstab Query

    You don't need a crosstab to do what you're looking for. Just create a query and use the Totals button in the toolbar. Your query should look as follows: column 1 column2 column3 column4 field: Month Make Model Model total...
  5. I

    using column 2 in unbound combo box to choose form

    Use the following to refer to the value in column 2: comboboxname.column(1)
  6. I

    How To Restrict User Entering Record Thru Form

    Set the Allow Additions property of the form to no.
  7. I

    Passing DB Password w/ Batch File

    Is there a way to pass a database password when opening a database through a batch file? I know you can pass user/password information, but I haven't been able to find a way to pass a database password.
  8. I

    Mail Merge Error

    Thanks! The wordapp.visible=true was inside an if statement so it was never getting to it. I added it outside the if statement.
  9. I

    Mail Merge Error

    I inherited a database from a contractor. The database includes a number of mail merges. One particular mail merge runs fine, but doesn't bring up the document even though the code contains wordapp.visible=true. If I try to run it again, I get an error message that I already have the word...
Back
Top Bottom