Recent content by LomaxE

Hi David, I had thought of that and tried a few combinations of count(Dist_no), countofDist_no, countof([Dist_no]) etc to use in the calculation but I can't seem to get the syntax right. Any suggestions of the syntax? I suppose another option would be to have an earlier query doing the...

Hi, I have a macro set to run over night that runs a hundred or so queries in a row. I've just added a few which now cause the macro to pause and ask for parameter values - only none are needed. The parameter box asks for a value for "total". In the query itself I have a column - total...

Ah that worked... I then simplified the query further and was able to get it to open normally again. Will have to keep that vba solution safe somewhere for if it ever happens again. Thanks JANR!

Hi, Just this morning I set up a new create table query in a new 2003 database. The query was too complex at first so I removed a load of criteria meaning to do it in a later query. At which point it worked ok. At some point the database must have been shut down and when I reopened it again...

Thanks All, Setting up my queries to run in VBA and DoEvents in between each one seems to have sorted it! No more wacky results in the morning. Dave - I'm not really sure what you mean but I wasn't getting up any error messages. I suppose it might have had something to do with access not...

Great, well i've gotten a test script working and I've just set it up to run the 100 odd queries overnight. Fingers crossed for no more anomoly lines in the morning!! Thanks again. Emma

Thanks for getting back so quickly! Although I use VBA in excel, I've never used it in access before. I basically stick to the queries and basic macros in access. I don't mind the idea of working out how to do what you described above but how would I then get that to run as a scheduled...

Hello, this is my first post and I'm really hoping someone else will have encountered this. I have an access database which has a run of 100 plus queries which all append data to a single table. I have a macro set up to run these in order so that I can run it over night when nobody (in...