Search results

  1. R

    Exports/Outputs Suddenly Very Slow

    Hi, I have an Access 2010 database which has very suddenly become very slow when either exporting to excel or outputting reports. The two common places where this happens are below (this code hasn't been changed any time recently). Any thoughts would be much appreciated! Example 1 - Printing...
  2. R

    Memo Field Not Growing on First Page of Report

    I have a report which is basically a form letter. The text of the letter is in a memo field, which is set to "can grow". This works fine - on all pages except the first page. On the first page of the report the text displayed in the memo field is limited by the actual height of the text box...
  3. R

    Combo Box Problems with Hyphens and Spaces

    Hi All, I have an unbound combo box on a form called cbo_LastName. Because the row source for this combo box contains almost 100,000 distinct values, I have set it up to only load the row source after the first three characters has been entered. So when the user starts typing, the combo box...
  4. R

    Access Front End SQL Server Back End

    I am using SQL Server as a back end to Access for the first time, and I am having difficulty understanding how the two work together. Using Access VBA, I am able to open a connection to SQL Server, and I am able to execute a basic stored procedure (which accepts no parameters, just creates a...
  5. R

    Filter One Combobox based on selection in another combobox

    I have two comboboxes on a form (cbo_Start and cbo_End). The record source of both is currently set to the same query: qry_StartEnd. qry_StartEnd contains the following fields: StartEnd_Name (Text, example - "08/2010") StartEnd_Start (Date, example - "08/01/2010") StartEnd_End (Date, example...
  6. R

    Define Excel Range from VBA in Access

    Hi All, I have a procedure which allows the user to export a filtered recordset from an Access subform to Excel (using the CopyFromRecordset method). I am in the process of making sure the resulting excel worksheet is formatted appropriately. I would like to add borders to the exported...
  7. R

    Using Month() in If Then Statement

    I'm trying to create an If Then Statement using criteria based on a calculated Month field. My code currently looks like: If [tbl_ImportedMonths].[ImportMonth] = Month([tbl_Time].[Time.Date]) Then MsgBox "The month you have chosen already exists. Continue?", vbYesNo, MonthAlreadyImported End...
  8. R

    mail merge help

    I have a mail merge function in Access 2007 which is supposed to merge the records (multiple) from a query (in which the user selects different criteria) into a letter in Word. The merge works - except that it only merges the first record. I want to be able to merge all the results of the...
Back
Top Bottom