Recent content by fuglyjowls

I have a database which we have been using for some time. A colleague has just got a new computer and for reasons I won't go into only has Access 2003 on it. When she tries to open a macro it comes up with the action failed error message although it is fine on my computer which has Access...

Sorry not explaining myself clearly - I can copy and paste the SQl text but pasting it into a new query still had the same problem

Yes that's right - it opens up but I can't add anything into the fields I used to be able to edit.

Can anyone help? This is holding up my work and I urgently need to get it sorted so appreciate any ideas.

thanks for suggestion but it hasn't worked unfortunately :confused: Any other ideas?

hi I hope someone can help me with a small problem. My database crashed recently and threw a bit of a wobbly - it lost information randomly and deleted all queries, reports and macros which was really strange. I managed to copy over all of the queries etc from an older copy of the database and...

Anyone???? I'm getting desperate now as I have asked the company who do our technical support to look at it and they don't know the problem (but they are not too good at Access anyway).

Thanks Neil - I have looked at it and it says: [qrybrochure] in "customer.mdb!QUERY qrybrochure"

Sorry - I don't know how to find this out.

Can anyone help further, please?

MSAccessRookie - thank you thank you thank you - you have sorted my problem out - I copied the SQL and created a new query and it worked fine. It must be a bug of some sort. Thanks so much and thanks Mailman for all your help too. I'll be back no doubt :rolleyes:

Aaaagh I find Access so frustrating - I have just looked at the SQL for the query ProductionOrderSummary and it does not have any such parameters regarding dates - when you open it up it just opens and shows all orders. So I am still none the wiser. Unfortunately I did not create the...

Thank you for the reply - can you explain to me how would I refresh the link or check the path or is it something I would need any expert for?

Thanks for your advice - I'll know to format it in future. I think Production Order Summary is another query - does that help?

OK thanks for your help - sorry I am not a programmer so I need lots of help. The SQL is: SELECT [Production Order Summary].id, [Production Order Summary].[order no], [Production Order Summary].Surname, [Production Order Summary].colour, [Production Order Summary].Model, [Production...