Recent content by gti_jobert

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...

Managed to find and use the following code that works just how I wanted it to... Private Sub Form_Current() If Me.NewRecord Then On Error Resume Next 'It should never occur, just to be sure... Me.Reference_Number.DefaultValue = Nz(DMax("[Reference Number]", "tblData"), 0) + 1 End If End Sub

Hi thanks for quick response! I'm Selected my Reference Number Textbox on my form >> Properties >> Data Tab >> Default Value >> =Nz(DMax("[Reference Number]";"tblData"),1)+1 Doing the following above, select another text box and go back to Ref Number properties and the default value text has...

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...

Thank you very much....Have sorted the problem now!

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...

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...

Thank you so much, it now works!

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...

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...

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 &...