Recent content by Alex McDevitt

Try.... SQLWhere = " WHERE tblPersonalInformation.PersonalID = " & Forms!frmMain!txtCandidateNumberReadOnly & ";"

Date query: SELECT Order.OrderID, Order.OrderDate FROM [Order] WHERE (((Format([OrderDate],"mm"))=12)); This'll give you the orders in dec. -------- SELECT Company.CompanyID, Whisky.RegionID FROM (Region INNER JOIN Whisky ON Region.RegionID = Whisky.RegionID) INNER JOIN (Bottling INNER JOIN...

Are you deleting the record based on the date.. If so & you are doing it from code, use SQL...."WHERE (((Table1.Datefield)=#" & Format(Me.txtdate, "mm/dd/yyyy") & "#));" even if txtdate is in uk format it will still delete the correct record...

Cheers...thats just what I just thought of...my only hessitation was the fact that the dates could be the same...so I had to do another query with min ID...don't things get complicated! Thanks for everyones help..

You might be closing the database(at your end), before the code has been executed.... Might be worth closing the database in ZZZ_Totaal or incorperating the database in the Switchboard database...

Cheers George, The problem is it's not always the max ID, the returned results are... ID1 | MinOfDate | MaxOfID -------------------------- 1 |19/01/05 | 3 2 |20/01/05 | 5 Not.... ID1 | MinOfDate | MaxOfID -------------------------- 1 |19/01/05 | 3 2 |20/01/05 | 4 SQL...

Not sure without looking at any data but will this work? SELECT Table_AreaAbbrs.AreaAbbr, Table_AreaAbbrs.AreaID, Table_Grantees.SDPINShort, Table_Grantees.SDPINumber, Table_FormLogInfoGrantees2004.FormRequired, Table_FormLogInfoGrantees2004.FormRequiredComments, Table_Grantees.SDPIName1...

I wondered if anyone new how to return the following Table of Data ID|ID2|Date ---------------- 1 | 1 | 20/01/05 2 | 1 | 21/01/05 3 | 1 | 19/01/05 4 | 2 | 20/01/05 5 | 2 | 25/01/05 I want to return the minimum date grouped by ID2, but with the corresponding ID i.e. ID|ID2|Date...

Hi, It must be because you have set a new instance in the first procedure i.e. New Access.Application Out of interest, why are you opening & calling external dB's, can you not group these dB's together?..

Hi, Now stay with me on.... Query1: field1ID(key),field2ID, field3(Date) field1ID=autonumber field2ID=ref to another table(table ID field) field3 = date How do I return field1ID,field2ID,max(field3) without returning all fields(because I can't use 'Groupby' with field1) Heres some data to...

'******************** Code Start ************************ 'This code was originally written by Dev Ashish. 'It is not to be altered or distributed, 'except as part of an application. 'You are free to use it in any application, 'provided the copyright notice is left unchanged. ' Function...

Good morning, I think I've figured it.... If strFile dosn't exist, sBackupPath = strFile Check to see the correct file path is being entered....try simplifiying the code & forget about the copying for now....

...confused... when I tried a basic version of your code, it returned correct sBackupPath & sBackupFile... Dim sSourcePath As String Dim sSourceFile As String Dim sBackupPath As String Dim sBackupFile As String Dim strFilter As String Dim strFile As String 'strFilter =...

what does strFile return?

Hi, I have posted this thread before, but still have not found a solution...... I'm trying to export a query/table to excel from access. I understand the "TransferSpreadsheet"/export method, but when this method is executed, the excel sheet displays the ' character at the beginning of each...