Recent content by Rob007

That was the second reference that I mentioned: "I have tried removing all references except Visual Basic For Applications and Microsoft Access 11.0 Object Library..." Thanks, Rob

Thanks Bohemian, That was one of my guesses as well. I was using some non-standard references. I have tried removing all references except Visual Basic For Applications and Microsoft Access 11.0 Object Library and using code (refer initial post) that doesnt require any extra references...

I am not a new user but I am having a problem that has me stumped! I have a large database that I have been trying to fix for the last 2 weeks and tried everything I can think of. Problem is that code wont run (I know there are a lot of things to try and fix this). Today I decided to start at...

Hi lagbolt, Yes I have compiled the project. I have also decompiled and re-compiled, no issues in the code. Ta, Rob

Tried hard to write an appropriate title but I dont know what the problem is sorry. I have a large database: Tables: 74 Queries: 253 Forms: 114 Reports: 121 Modules: 10 Database is in use with multiple users and I edit it making small tweaks as required. I have been trying to make a small mod...

I have a problem where I can create queries in code using functions such as Left() and they will work fine on my clients machines with a complied MDE file but if I try to use the same function in a saved querie they get an error: "Function is not available in expressions in query expression..."...

Microsoft Bug I checked Microsofts web site and they have this problem listed there with no solution. Article 839779: In Microsoft Office Access 2003 and in Microsoft Access 2002, you can set the Vertical property of a text box control to Yes in a report or in a form. When you do this, you may...

Have you found a solution I have a similar problem except with Arial font! I have a report with both horizontal and vertical labels. It was printing fine on all of our machines (All Win XP Pro) but now it wont print vertical labels on some machines - just leaves them blank. From the reports...

Worked For anyone interested - I rebooted and it worked.

I am trying to create an mde file. I have read lots of threads that suggest ensuring that your code compiles before beginning which I have done, I have also "compacted and repaired" my mdb file but my P4, 3GHz machine has been trying to create an mde file for over an hour. The mdb file it is...

Ta Thanks Ray705, I spent so long trying to get it to work that I have run out of patience with SP2, maybe in a couple of months I will have forgotten how annoyed I was and have another go. Appreciate the advice - although if I have to do that for all 10 of our computers I wont be real happy...

Uninstalled XP Thanks Mdemarte, I have uninstalled SP2 - it has some great features but none of them are any good if you cant print! (even with the firewall turned off) Ta.

I have just installed Windows XP Service Pack 2 and a number of my access reports are extremely slow to load and work with (10 mins to open when they used to be nearly instant). Has anyone else experienced this or is it just a coincident and some other problem causing this? Thanks, Rob

Thanks MDEMARTE, The formulas do work, when I view the query in database view I can see the calculated values, they just dont work in the form - wierd. I have put the formulas in to the textboxes in the form and it is now working OK, just frustrating that it didnt do what it was supposed to...

I have a subform whose source is a query that contains formulas e.g. TotalCost: Products!CostPrice*(Products!OnOrder+Products!Unprocessed+Products!InStock+Products!Galvanised) The subform is viewed as a datasheet and when I view it all the fields look fine however, when I view the subform in...