Search results

  1. G

    Excel formatting outputTo

    Hi Guys, i'm trying to export multiple queries to on excel file with multiple worksheets and keep the formatting from each query. i.e. one query on each sheet. This works fine for one query by using the following : DoCmd.OutputTo acTable, "Query1", "MicrosoftExcelBiff8(*.xls)", "C:\My...
  2. G

    IIF statement not working

    hi i am trying to use the following iif statement in a query. IIf([Forms]![MainForm]![cmb_ExcessStatus]="Resolved",1,IIf([Forms]![MainForm]![cmb_ExcessStatus]="Outstanding",2,IIf([Forms]![MainForm]![cmb_ExcessStatus]="All Records",([MainTable].[Status])=1 Or...
  3. G

    VBA before update problem

    Hi all I wish to create a VBA function that will write details of any form item to a db table for auditing purposes. I had planned that I could call my function in the beforeUpdate event on every form item ( passing in the form and the activeControl. ) Private Sub Text21_BeforeUpdate(Cancel...
  4. G

    access to sql server express connection

    Hi guys, im new to Access and SQL server. Im trying to connect to SQL server express on my own PC but im not having any luck. Is there any documentation anywhere that will explain what i need to do? any help would be much appreciated
Back
Top Bottom