Search results

Hi There, I have a Marco that outputs a CSV file. This Marco previously used a standard query. However, the client requested that depending on a result the column's value will be x, or, y etc etc. So, I have the new query that contains a SWITCH function. The query runs fine via the...

Again, completely understandable. I will approach them when I can regarding this. I have seen those tips before and yes I understand why my query would not work i.e. too many joins is the obvious I think. But, my question is really how to achieve what I am asking with a similar structure i.e...

Fair enough, but this is work from a predecessor I.each I've been handed this from the client. So regards to naming conventions I don't think it stops folk from solving the issue. I'll recommend this to the client but time is money and I doubt they will pay for a clean up.

Hi There. Hopefully I can clearly explain my woe. Problem: I have a Main Form and a SubForm. The SubForm contains fields to a table (Booking Item) that records - Qty, Item ID, Booking_Id Description and Price. The Subform source is a query that gets the details from the following Tables...

Hi there. I have discovered that the Sub form is based off a query that produces the Price from a Stock table. So in terms of the function I made, it was completely redundant. However, Trying to get the Subform to work now i.e. making the RecordSet editable, but because the new structure is...

Hi there, I have a project at hand and it's been a predecessor of mine (you know where I'm going, yeah?) and client has asked me to do some work on it and extend functionality - but I have not really delved into Access before and I have had to worked my way through to this final snag :/ A...