Recent content by polo

Thanks jkl0 but I don't think its that because I cannot even update the table manually... when I look to the tables they appear to be read-only... I have check the mdb file it isn't read-only... is there anywhere within access that the database or the object could be set to read only?

Hi all, Recently I am getting this message in a database that would allow users to add new rows to tables, even when I look into the tables themselves I can't seem to enter data Would anyone know what could be causing this error? Error (no. 2501): The save action was canceled Thanks Polo :)

TableA Recieved Date | Results ID 31/01/2005 | 3 21/05/2006 | 2 TableB Sent Date | SentID 02/02/2005 | 5 18/05/2006 | 6 TableC Name | ResultsID | SentID Example1 | 3 | 5 Example2 | 2 | 6 For the...

Hey all, Ok I'm having a problem running a query, below is description: TableA has columns RecievedDate ResultsID TableB has columns SentDate SentID TableC has columns ResultsID Sent ID I want to have a result of all values in Table A that have a value of Recieved Date is less than SentDate...

Hi KeithG, The database is on a network... any info much appreciated! :-)

Thanks Banana for your help. I have ammended the query now, although it runs alot slower now :-( Since I modified I am not getting a different error message: The microsoft jet database engine stopped the process because you and another user are attempting to change the same data Would anyone...

Hi Banana, I'm using first because there are exact duplicates in the table.... perhaps this should be done a different way? Thanks Polo

Hey guys, I am getting this error "This expression is typed incorrectly, or is too complex to be evaluated" For this query: SELECT first([TblProp].[Name]) AS [SName], First([TblProp].[CommentDate]) AS DateCommented, First([TblProp].[No]) AS BNum, First([TblProp].[Indication]) AS Ind...

Hello, I am trying to run a select query which I can't get to work. What I want to do is select a purchase order number from table1 then (possibly using a subquery?) do another select where it will return the most recent version number (from table2) for the purchase order number returned in...

Scrap last message! Ignore above post.... :eek: Ok thank you very much Jon that link was great help! :) In the return set now it returns several of the same instances of a cost type ( I know this data is so frustrating!!!!) is there a way I could build in that I only want unique cost types...

Thank you jonK for the link :) I've been working on using a similar method but find it is incredible slow. This is probably due to the fact that it is pulling information from a query rather than a table... is there anyway you can import the data a query produces into a table? Any info...

Hello all :) I'm having a nightmare with a query and the only way I can get it to return what I want is using a subdataset on the main query. Problem is when I try to create a report, it doesn't pull through the values from the subdataset, anyone have any suggestions? Any info really...

Thanks Dembrey for the response :) I am unfamiliar with CrossTab Queries but had a look online.... I don't see how this will give me the result I need... instead I can get the number of cost types per customer but not the result of the cost types being appending into one column.... any ideas?

*bump* Sorry to post again but I'm sooo stuck on this... any info apprecated! I think a search on site but couldnt find anything to help! to re-hash what I said above: I have a table that looks somewhat like this: clientNo Cost type 0628 Lighting 0628 Gas 0628 Elec 0628 buildings There...

Anyone got any ideas on this? I am completely stuck on this and not sure what to do.... is there some function I can use to append text? any info appreciated