Search results

  1. A

    report view hangs

    Open the database in exclusive mode. This should help eliminate the problem.
  2. A

    Office Links- Analyze w/ Excel

    Jamie - I had this problem a few months ago as well. Here is some more information to go along with the above method: http://support.microsoft.com/support/kb/articles/Q208/8/01.ASP?LN=EN-US&SD=gn&FR=0 AK
  3. A

    Mutiple Criteria Reports

    Base your report on a query that uses parameters for each of the fields you need. When the report is opened, it will prompt the user and pull up the records based upon his or her input.
  4. A

    Input masks and labels

    When you run the wizard to set up the input mask, you need to tell Access to store the data with the symbols in the mask (step 3). Otherwise, you will only be storing the actual numbers, and the symbols will only show up in the user interface. If you don't use the wizard, the "Input Mask"...
  5. A

    Capture Global User Variable

    I'm not sure if this is what you're looking for, but I use a global module that captures the user's Windows ID automatically: Option Compare Database Option Explicit Public lpUserName As String Declare Function WNetGetUser Lib "mpr.dll" Alias "WNetGetUserA" (ByVal lpName As String, _ ByVal...
    • AK
    • Post #4
    • Forum: Forms
  6. A

    Delete tables on Exit

    Try this on the form's Close event: Dim tdf As TableDef Dim db As Database Set db = CurrentDb For Each tdf In db.TableDefs If tdf.Name = "TableName" Then DoCmd.SetWarnings False DoCmd.DeleteObject acTable, "TableName" DoCmd.SetWarnings True Exit For End...
Top Bottom