Search results

Ahh...but it still works, try it I dare you.. Martin

Hi Lawrence, Try the following SQL, it should be what you're after: UPDATE myTable SET myTable.[comments] = replace([Comments],".","/") WHERE (((myTable.[comments]) Is Not Null)); Cheerio Martin

Maybe an easy one (I hope!) that someone could help me with... I am having trouble getting a pivot form to show the whole pivot table (example attached as .jpg). For some reason once I edit the table I can see the whole thing but when I return to Access I get the same restricted view. I'm...

That will do me just fine, thanks for your help AN :)

Is there a way to use code to change the zoom in a report on open (from a form)? I would like to set the zoom to 72% but I believe there are only preset zooms available? Any help would be appreciated.

Now solved..

Hi, I would really appreciate any suggestions for my problem! I keep getting #Error fields in a report (From the second page onwards) when I open it from a form. When I open the report by myself the field appears as normal. It is a date field, not populated for every row. there is no format...