Search results

  1. G

    SendObject not working properly

    Hi all, I have a form with a button that will execute a query, produce a report and then run a SendObject Macro to attatch the report into an email in MS Outlook......my problem is that the attatchment will show for most users, but some it doesn't - is there a common reason for this with Access...
  2. G

    Newbie at Access needs help

    Hi all, I'm just having a dabble in VBA for Access so I'm fairly newbish! I have a field [Reference Number] that increments in the table by 1 everytime - but the user has to enter this manually (its not auto-incrementing). How can I do the following: when the user selects a new row in the...
  3. G

    Quey producing out of bound results

    Hi all, I am performing the following query using an ADO connection from Excel; SELECT [Date], SUM([Batch Qty]) As [Batch] FROM [Speed Fastener Packing] WHERE ([Date] BETWEEN #03/04/2006# AND #05/04/2006#) GROUP BY [Date] ORDER BY [Date] When I execute this statement in Access it generates...
  4. G

    SUM function in Query :: Newbie

    Hi all, Another quick Q - am a newbie at Access! I am performing the following query: .Open "SELECT DISTINCT([Date]), SUM([Batch Qty]) As [Batch] FROM [" & TableName & "] " & _ "WHERE [Date] BETWEEN #" & sDate & "# AND #" & eDate & "# " & _ "GROUP BY [Date], [Batch...
  5. G

    Between Statement not working using dates

    Hi, I am using an ADO connection to an access Db but am having from executing a query on the table. In my table I have a Field named [Date] with Data Type as Date/Time (Short Date dd/mm/yyyy). When I perform a Query on the Db like; SELECT [Date], [Part No], [Batch Qty] FROM [Speed Fastener...
  6. G

    Between Statement not working using dates

    Hi, I am using an ADO connection to an access Db but am having from executing a query on the table. In my table I have a Field named [Date] with Data Type as Date/Time (Short Date dd/mm/yyyy). When I perform a Query on the Db like; SELECT [Date], [Part No], [Batch Qty] FROM [Speed Fastener...
  7. G

    VBA Excel Connect ADO Access

    Hi all, I am using an ADO connection to retieve data from an Access database using Excel VBA - this seems to be functioning properly (I am able to get data as required). My problem is modifying my SQL statement - currently I have; .Open "SELECT [Part No], [Batch Qty] FROM [" & TableName &...
Back
Top Bottom