Search results

Sorry for the delay in posting, thanks for all the help so far. I'm actually pleased (and very relieved) to say that I've actually found where the issue was and managed to fix it. It turns out I did have an "infinite loop" in my code that was opening a connection over and over again until it...

My apologies - I didn't think that the code snippet was really vital in this case so I only wanted to show the bit where it fell over ;) Anyhoo, I tried what you suggested and copied everything into new databases (apart from the reports) and still ran into the same issue. I also tried to...

Thanks for the reply :) Actually I have defined it, it's just that I've only shown you the line that the code fails on, which I don't believe is actually the cause of the problem anyway... I agree that having the amount of tables and queries and forms that I currently have is not much, and it...

I have been building an Access Database (2010) at work for a good few months now (on and off), and I have tried my best to keep to best practices where possible. It currently has; 16 Tables (split into a back end database, and linked to the front end database) 13 Queries, none of which are...

I get what you're saying about not using temp tables this way, but for the purposes of what I'm "trying" to do it works, so I'll leave it as is :rolleyes: I wasn't really wanting to put any tables into the front end database, so I followed your suggestion of creating a link to the TempTable and...

Thanks for the tip - I think I see what you're saying, however I'm not sure that that's what is causing it to fail. I have tried changing it to; CurrentDb.Execute "Query_ConvertImportDates", acViewNormal but still have the same issue. The error is 3078 - "The Microsoft Access database...

Hi all, I have an Access 2010 database that I am developing at work. I recently split the database (using the wizard) into the front end database with the interface and all the queries/reports etc., and the back end with just the tables. That's all fine, and my front end database shows the...

The entire error is: I have checked my primary keys, indexes and relationships and they are all set up fine. I have also checked for duplicate data in all of my tables and there is none. So actually, what the error message tells me is kinda useless unless I know more about the underlying...

Thanks, I will take a look at the thread. It's just a main form that I'm using, no sub forms. The code is executed on form load; Sub LoadProcessOrder() Dim procOrder As Variant procOrder = "" Do procOrder = InputBox("Please enter a Process Order number", "Enter...

Thanks for the quick reply! :) Not at the moment, I did try using On Error Resume Next, but of course it then doesn't do the refresh which is a bit of an issue. To be honest I wanted more to get to the bottom of why the error was occurring in the first place... not a fan of workarounds if I...

Sorry if this is a total newbie and over-asked question, but I have been trawling the internet for hours (...days) and cannot seem to find an answer that works... I have an Access 2010 database with a form that allows me to input data which is saved into two tables (i.e. Orders and...