Search results for query: *

Wow, and I thought I had got compulsive about this kind of thing! :-D I've never got quite that bad, but in total I must have spent countless hours adjusting the cases of field names on the various systems I've written.

Ok, I've tried the decompile option, and it does indeed let you change the case of those stubborn fields. However once you recompile they capitalize again! :-(

Thanks Remou, I tried that but the results were mixed though I managed to alter some of my fields. Genomon, wow never heard of this. I'll have to read up on this first to see exactly what's involved. Thanks.

Hi all, for years now I've been a good boy and have been using field names such as 'TotalBalance'. However as some of my databases were written in the bad old days when I was undisciplined about naming conventions many of my older systems have capitalized field names eg... 'TOTALBALANCE'. My...

Whoops, didn't realise I had left this question unresolved. I know what causes this problem now... The problem is caused when editing code in a form if another form (which might be invisible) is still open in run view. It seems to create some kind of conflict.

Thanks for your help, I will check that out.

While previewing reports from a form (Access 2000) the report margins often keep resetting to the default values. This results in potrait format reports incorrectly previewing or printing across two pages. The problem does not though seem to occur if the reports are printed before they are...

Just to correct my original post, the new code lines are not coloured red as I stated, only amended code lines. The problem is not machine specific which probably rules out the graphics card. After reading one reply, I have since experienced the problem on a machine with a wheeless mouse...

When using the VBA editor in Access 2000 and occasionally XP using a varierty of machines and platforms I get the following problem... The textbar at the top of the screen starts flickering rapidly. Any new line of code being entered is coloured red and spaces cannot be entered (until the line...