Search results

Paul I have debugged and think i know where the problem is but still can't get the code to work. I have highlighted in red where i think the problem is: The SQL I am copying is: SELECT [PTS AC].[NI Number], IIf([PTS AC]![NI Number]=[NonOperational]![NINUMBER],"No","Yes") AS Operational, [PTS...

Paul Many thanks for that - I am currently debugging and how easy is that to see Every day is a school day :) Rich

Hi pr2-eugin I am struggling to see the SQL it generates as when i select debug it is all highlighted What would be the best way - I use vba quite a bit but I do seem to struggle when I am getting it to run SQL and need to use loads of "" all over the place Cheers thedawn

Hi hopefully someone will be able to help me I am using VBA and querydefs to amend some queries that I have created. I have a table in which I have a list of names that I want to use for fields in these queries and i am opening this recordset and trying to get the code to scroll through and...

Hi I wonder if you could help me - I have a field in a database that is supposed to be a UK postcode. The problem I have is that some people have only supplied the first part i.e. say L1 or LE1 or NG20 and some have supplied the full post code. The data in this field can be from a length of 1...

I tried to solve this another way using VBA as I am struggling with the dcount for some reason. I put the following together using code I had used to run multiple append queries but I keep getting the following error 'Wrong number of Arguments or invalid property assignment' I am not sure...

Sorry, i thought it was in the previous message. I have a table called "Table of Tables' that has the name of each of the tables I want to count in it Thanks Rich

I have another table called TableofTables that lists all of the tables that I need. I have an automated import that creates a table, imports data from excel and inserts the table name into this table every time I import a new dataset. Thanks Rich

Thanks for that but if possible I only wanted to do it for a specific set of company tables - is there a way of doing this Thanks Rich

Hi Is there a way of counting the records in a number of tables and then inserting the table names and counts into a table. I have a table with the names of all the tables in it as this is populated when I import from excel. The resulting table would be Name Count Table1 25...