Search results

Hi Paul Thanks for your very quick response. I amended the code on your suggestion as follows: Set rs = CurrentDb.OpenRecordset("SELECT Agency, Customer FROM tblMaster GROUP BY Agency, Customer") However - I just got the same results as before - a new table for each Agency. Just in case...

Hi all Again, I've searched for ages but I think there's a particular element of what I'm trying to do that I can't find the answer to. The code below basically loops through the table (tblMaster) and creates a new table for each Agency. All works fine. What I've now been asked to do is add...

Hi Paul Apologies - that was a typo in my post. I've attached a screenshot of the VBA window with the code and error message. Hope you can help!

Hi Paul Thanks for your very quick reply. I understand the VBA I think but I've had a couple of problems. The first one was that the 'Set tmprs =' line was highlighted red with a Compile Error expected end of statement but I think I've fixed that with brackets. Is that right?!? However...

Hi all After a thorough search I can't find a solution to my issue. Any help gratefully received. I have a table (tblMaster). In the table is a field called Agency. The table is 200,000+ records and there are around 35 Agencies. The table grows monthly, with potentially new Agencies added...

Cheers Jonathan, it's not looking good! I have read a few posts kind of relating to my problem that suggest Terminal Services as a possible solution. Do you (or indeed anyone taking the trouble to read this) have any idea if that is something to pursue?

Hi Jonathan Thanks for your super quick response. SQL Server and Sharepoint are not viable options unfortunately. My company has neither and there would be no budget for that (and we don't even have an IT department).

Hi all Apologies for the new thread. I have been through umpteen threads that kind of address my issue but nothing that really outlines how I should proceed. Anyway..... We have an Access 2007 database at work. At present it works fine, standard front end-back end set up with BE on the...

Sorry David - yes all users have their own front end on their machines.

Thanks for replies and interest. GTH - the issue doesn't seem to be to do with duplicate fields. David - not that I'm aware of. The issue is the same for all users - same errors. There is no sophisticated stuff - just a standard front end back end link.

Hi all I know it's bad form to bump your own post but the issue has occurred again and I am just wondering if anyone else has ever experienced this? It's as if the link to the back end is getting lost, causing the queries to default to this Expr1, Expr2 etc but when I go in and check the...

No problems - worked fine. Also, just deleting the Expr1 prefix in the queries results in the queries working again. So it seems it's not so much an issue of fixing the queries, it's more why did it happen and will it happen again?!?!?

Yep, the fields are still there (this isn't a problem specific to ClientName - that was just one example). Where the query is querying a table the field appears in the field list. Where a query is querying a query, the original query is working fine.

Hi David Thanks for your quick response. The tables are still there. There are other queries that look at ClientName that are not erroring in this way.

Hi all I've searched to try and find the answer this this but with no luck - probably not searching for the right keywords. Anyway, hope someone can help. I built a pretty standard Access 2007 database at work, front end back end set up, all been working fine. Been on a weeks holiday, come...

Hi Guys, thanks for all the replies - superb stuff! I agree with everyone that this is a weird request and that a proper ascending invoice number series would have ensured that this never happened. Part of the problem is that the invoice numbers are completely random - not in series at all...

Hi all Apologies for the new thread, had a long search and solved most of my problems but one remains! I'm working on a database that identifies duplicate invoice numbers. The one remaining issue I have is that the spec requests the ability for the database to find potential duplicates where...

Great stuff Thomas, you're a genius. Many thanks!

Hi folks Apologies for a new thread but I've got a real head-scratcher that I hope someone can help with. Couldn't find anything to solve this using the search. It's basically trying to find duplicates in a list of invoices, but with an added complication. We are interested in 3 fields -...

Hi I've had a search through but to no avail. I'm trying to import data from an Access query into a blank spreadsheet (Data-Import External Data etc), but it's only giving me a list of the tables in the database and not listing any of the queries. I've never had any problem with this before -...