Recent content by djones

Thanks RG. I think I've just found out what the cause is. It's down to the security settings that I had setup under Tools,Macro,Security. I've set these to low and it works fine now.

Hi, I'm using A2003 to try and create an mde file but it is not playing ball. The mdb is compiling fine with no errors but when I click on "make mde file" and supply the path/filename, Access appears to try to open the mdb again and prompts me with a security warning saying that 'opening this...

Thanks Hudson, I've used a slightly modified version of your code to automate the dropping of all the ImportError tables. Many thanks. I tried using DROP TABLE but Access didn't seem to be playing ball. Your code has saved me a lot of time. Thanks again.

Hi, Can anyone help me with the following problem: I get the above error message when I try to open a recordset. If I run the query directly it returns a record with no error messages but when I insert it into my code I get the error. Here's the part of my code that seems to give me the...

Thanks Rich, In this instance it doesn't work as I am derriving the 0 value based on the data contained within another field with the formula iif([field1]) = "A", [Field1], 0). My first thoughts were to change the 0 to "" or Null. This works but when I try to total the report it gives me an...

I've created a simple tabular report in Access 2003 that lists values for products in 2 columns. The first column has positive values in it and the second has negative values in it. However there are a lot of zero values that just clutter the report and I want to suppress all of them so that...